Connection login control with the backend db

microsoft.public.dotnet.framework.aspnet

10 Dec 2005 10:16 PM

John

Hi

I have placed a login control on a web form. When I run the webform and
click on the login button with dummy username & password, I get the
following error;

Exception Details: System.Data.SqlClient.SqlException: Cannot open user
default database. Login failed.
Login failed for user 'MYSERVER\ASPNET'.

The control is in template mode as I had to customise it and has been copied
from Sample Access Provider Starter Kit login page;
http://msdn.microsoft.com/vstudio/downloads/starterkits/. I have used the
SQL Server Surface Area Configuration to turn on remote connection for both
the sql server and sql server express instances as per attached image. I
have also attached the web.config file that I am using.

What is the problem and how can I fix it?

Thanks

Regards

[attached file: login.gif]
[attached file: web.config]