newbie trying to connect to MSDE db

[Kevin]

hi,

Just starting w/ asp.net. I downloaded the WebMatrix gui tool, downloaded
MSDE -- installed both. Using the Matrix tutorial, I have been able to make
OLEdb connection to an access database, but cannot make an sql connection to
a database I created using the Web Matrix gui -- dragging the connection
onto the design page -- and going from there. All I get is:

=================================================================
Login failed for user 'ThisMachine\ASPNET'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'ThisMachine\ASPNET'.
=================================================================

I have the MSDE login mode set at 1 in the registry -- I tried playing
around with mixed-mode. No luck. I've tried playing around with the
web.config file -- no luck -- and I've tried every imaginable connection
string -- no luck.

There is nowhere in the MSDE to add a user named ThisMachine\AspNet -- as
I've seen other posts in other forums suggest.

Any ideas, help?

thanks

 

[Miha Markic]

Hi Kevin,

I don't have a clue about WebMatrix though one thing seems clear enough.
It is trying to connect to MSDE using machine aspnet account (under which
aspnet apps are run).
One solution would be to grant aspnet account connecting to msde (setting
msde accordingly).
Or better, change the login credentials and/or mode for WebMatrix in design
time.

 

[Cecil Howell]

Kevin,
MSDE's only admin tool is a command line util called OSQL. Here
is microsofts help on this tool:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003

There are sample scripts at the link that do just what you want.

Cecil Howell MCT, MCSD

Email: add an 'h' between 'cecil' and '@' in return address