MSDE and ASP .NET problem.

[Ranv]

Well, I'm not sure if this is the right place to post this but here goes:

I've just installed MSDE and have created a simple database by using Visual Studio .NET. I'm trying to access this database in an ASP .NET page (using C# as the scripting language). When I run the web application (running it on the same computer as where MSDE is installed), I receive the error:

System.Data.SqlClient.SqlException: Login failed for user 'MYCOMPUTER\ASPNET'

I'm not really sure how to set up users in MSDE, I tried to use Microsoft SQL data web administrator, but I can't seem to log into it. Thus, how would I allow access to the ASPNET user? Hope somene can help, I've searched everywhere and can't get any answers.

 

[hmckillop]

Have you tried the default administrator login of sa and blank password?


"I'm living so far beyond my income that we may almost be said to be living apart