How add asp1.14 permissions to SqlExpress

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

How add asp1.14 permissions to SqlExpress

Author

Topic

MichaelKhalsa
Starting Member

2 Posts

Posted - 2005-04-25 : 15:59:38

When using sql2000 on asp.net i always had to add permission for the asp.net process (with dbo privilages) using enterprise manager

Trying to run a project in sql express using asp.net 1.14 and get the following expected error:
Cannot open database "SilverExpress" requested by the login. The login failed. Login failed for user 'SILVEREARTHTWO\ASPNET'.

How do i add the aspset user to sql expreess??? (The manager has no support for adding or editing users, just displaying them)

Local instance environment - April 2005 beta

Thanks

Michael Khalsa
Silver Earth

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-04-25 : 16:50:17

If 2005 has these system stored procedures like 2000 does for security, then try these out:

sp_grantlogin
sp_grantdbaccess
sp_defaultdb

Tara