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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-04-27 : 13:11:41
|
| Hello Folks,Could somebody please tell me how to resolve permission issues on a sql 2000 server.I have got a user named niku in my database and a login with the same name. When i try to get into the database with query analyzer it comes up with login failed for user niku. I have used the sp_change_user_login options but none seem to be working.When i select from sysusers and syslogins in the master db i can see the user and SID but for some reason i cant just log in please help. |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
vdavid70
Yak Posting Veteran
67 Posts |
Posted - 2005-04-27 : 16:28:33
|
| Hello,The user is listed with a permit access.Furthermore when i do a select from sysusers in the user database it comes up with a null password.ThanksRegards V David |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-02 : 00:41:44
|
quote:
Originally posted by vdavid70
Hello Folks,Could somebody please tell me how to resolve permission issues on a sql 2000 server.I have got a user named niku in my database and a login with the same name. When i try to get into the database with query analyzer it comes up with login failed for user niku. I have used the sp_change_user_login options but none seem to be working.When i select from sysusers and syslogins in the master db i can see the user and SID but for some reason i cant just log in please help.
is the password correct for the login specified?  --------------------keeping it simple... |
|
|
|
pentiumsingh
Starting Member
9 Posts |
Posted - 2005-05-02 : 06:58:27
|
| can u please tell me 1.All steps u have taken to create that user.2.The permission given to that user 3. the default database set for that user 4. are you able to login with user sa and a password 5. and the passwords(eg. xxx, give me fake example no need of tru password) or login options set for that user |
|
|
|
|
|
|
Permissions