Win AUth User grant pergatory - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Win AUth User grant pergatory

Author

Topic

scottpt
Posting Yak Master

186 Posts

Posted - 2005-03-01 : 10:25:03

Grant login works fine. Why is the sp_adduser throwing a fit. User exists in syslogin. Windows group exists. I have no clue. help

USE master
GO
EXEC sp_grantlogin 'ret7w003\efisadmins'
go
USE DBA
GO
exec sp_adduser 'RET7W003\Efisadmins','efisadmins'
GO
EXEC SP_ADDROLEMEMBER 'db_owner','efisadmins'
GO
--------------------------------------------------------------------
Server: Msg 15007, Level 16, State 1, Procedure sp_adduser, Line 15
The login 'RET7W003\Efisadmins' does not exist.
Server: Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 66
User or role 'efisadmins' does not exist in this database.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-01 : 13:22:40

You need to use sp_grantdbaccess for Windows accounts instead of sp_adduser.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources