Windoes 7 and SqlExpress 2005 Trust error

Question

I'm using Windows 7 64 bit and SQL Express 2005. I've created a database in a C# app and get the following error when attempting to access the database from the CreateUserWizard. I've got the ASPNET security set up properly as I can make changes to the database through the configuration manager. I've been all over the WEB and tried numerous solutions. None worked. Is this a W7 issue? I see where others are having the same problem, but nothing in the way of a "This will work" solution. Way too many speculations on try this or try that. Here's the error: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Sql exception 0x80131904.

Answer 1

First of all be sure that you are importing/using (depending on language) the System.IO namespace for this to work. But what you can do is something like this

string pathToCreate = "~/UserFolders/" + TextBox1.Text;

if(Directory.Exists(Server.MapPath(pathToCreate))

{

   //In here, start looping and modify the path to create to add a number

   //until you get the value needed

}

 

//Now you know it is ok, create it

Directory.CreateDirectory(Server.MapPath(pathToCreate));