Creating a user in SQLExpress with SQL Server Management Studio Express

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Andrew Chalk" <achalk@xxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 13 Dec 2005 23:49:50 -0600

I have created a user in SQL Server Management Studio Express. However,
whenever my ASP.NET application tries to connect I get the error
Cannot open database "ABC" requested by the login. The login failed. Login
failed for user 'Fred'.

If I change my login string to Integrated Security=SSPI it works. Also, I
was able to add a user successfully in SQL 2000 but SQLExpress is differnt.

Can anyone tell me how to add a user and give him permissions for a
particular database? Or refer me to a URL that does.

Many thanks.

.

Prev by Date: Re: SQL Server Express as an embedded database
Next by Date: Re: FireBird Replaces MSDE
Previous by thread: MSDE Purge/shrink not allowed as it would take over 2048MB?
Next by thread: Re: Creating a user in SQLExpress with SQL Server Management Studio Express
Index(es):
- Date
- Thread

Relevant Pages

Cannot open database requested in login ASPState. Login fails. Login failed for user sa.
... Visual Studio app, I got round to the option for storing the state in SQL ... sessionState statement (so the app runs with the default in-proc session ... What is causing the login failure? ... Cannot open database requested in login 'ASPState'. ...
(microsoft.public.sqlserver.security)
Re: Cant connect through Management Studio, Can connect Visual Stu
... If your remote server is "Registered" in your SQL Server Management Studio, ... Try deleting your registration and recreating it, ... your login and password, to see if that resolves the problem. ...
(microsoft.public.sqlserver.connect)
Re: How to change the account that ASP.NET uses
... this error message or, the file wizou.mdf exists:/ Any idea? ... Cannot open database 'C:\Program Files\Microsoft SQL ... Login fails. ... execution of the current web request. ...
(microsoft.public.dotnet.framework.aspnet)
Error : "Cannot open database XXX requested by login."
... Cannot open database 'C:\Program Files\Microsoft SQL ... Login fails. ... execution of the current web request. ...
(microsoft.public.dotnet.framework.aspnet)
Error : "Cannot open database wizou.mdf requested by login."
... Cannot open database 'C:\Program Files\Microsoft SQL ... Login fails. ... execution of the current web request. ...
(microsoft.public.dotnet.framework.aspnet)