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.
| Author |
Topic |
|
fpineda101
Starting Member
7 Posts |
 Posted - 2006-06-13 : 01:03:32
|
| I coding an ASP.NET app. I'm getting some error messages about the ASPNET user can't access the DB. How can I manage a user (specifically add one) in SQL Server 2000? Thanks in advance for your help! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-13 : 02:05:32
|
use sp_addlogin if you have the permission to create a new loginif login exists then provide the appropriate permission and grantdbaccess if you're the dbootherwise ask your DBA to do this for you  --------------------keeping it simple... |
 |
|
|
fpineda101
Starting Member
7 Posts |
Posted - 2006-06-13 : 23:18:58
|
| I've created the account ASPNET. However, I do not know how to set the permissions and grants in SQL Server. Please tell me the command to do that. This is a setup on my personal development machine, there is no DBA.Thanks |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-06-13 : 23:30:45
|
| see the Books on Line (BOL) about security. Start with sp_grantlogin (NT user) and GRANT (type these key words in the index tab page).May the Almighty God bless us all! |
|
|
|
|
|
|
Manage Users in SQL Server 2000