Add a window acccount to SQL server account

Question

Post reply

Add a window acccount to SQL server account

Jasminesingh48

SSC Rookie

Points: 36
More actions
December 10, 2009 at 11:11 pm

#218637

Hi ,
I need to add the window controllerservices account to the SQL server account. I used the below command-
CREATE LOGIN [domain\account] FROM WINDOWS -I used the [servername\account]
It gave me error-
Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'Servername\ControllerServices' not found. Check the name again.
Please let me know how can I accomplish this. I also need to give the access to start and stop the trace to that SQL account after it is creat

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

dmoldovan SSCertifiable Points: 6334 More actions · Answer 1

I'm not sure if I fully understand you.

Does the Windows account exist? If not, create it first.

See also BOL ---> CREATE LOGIN (Transact-SQL)

SQLRNNR SSC Guru Points: 281344 More actions · Answer 2

Are you trying to add an account that only exists on the server that SQL Server exists, or are you trying to add a domain account?

What happens if you try to create the account through the GUI? Browse for the account from the New Login screen and see if you can find your account that way. If you are unable to find your account - the account may not exist yet. As dmoldovan said, to add a windows account to SQL Server - it must first exist in Windows (server or AD).

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jasminesingh48 SSC Rookie Points: 36 More actions · Answer 3

Yes this account exists. It is listed in the widow local user as a controllerservice account.

Jasminesingh48 SSC Rookie Points: 36 More actions · Answer 4

I did try to create through GUI. It gives the same error.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 5

Is it a domain user?

It is possible that a domain user was added to your local user group on the server. Verify the "source" of the user.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events