SETUSER to an NT Auth account - 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)

SETUSER to an NT Auth account

Author

Topic

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-10-28 : 09:28:25

I have some NT Groups setup and I need to do some testing. I went to use SETUSER 'DOMAIN\USERNAME' and I get the error:


Server: Msg 8198, Level 16, State 31, Line 1
Could not obtain information about Windows NT group/user 'DOMAIN\USERNAME'.

Any ideas? Lol. I guess, over my 5 years as a DBA, I have never tried to switch to an NT account before.

Daniel, MCP, A+
SQL Server DBA
www.dallasteam.com

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-10-29 : 12:13:31

Is your SQL Server service running under a domain account?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-10-31 : 10:10:13

quote:
Originally posted by derrickleggett

Is your SQL Server service running under a domain account?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Nope, local system account.

Daniel, MCP, A+
SQL Server DBA
www.dallasteam.com

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-10-31 : 14:07:42

Change it to a domain user account.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources