Unable to create login

Question

Post reply

Unable to create login

soniaj

SSC-Addicted

Points: 465
More actions
February 6, 2012 at 2:09 am

#254950

Hello All,
I am an admin on my sql server instance, however, i am unable to create any logins for user who have to access my db.
Can someone help me here, Please.
Thanks,
Sonia

Viewing 9 posts - 1 through 8 (of 8 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Check your own login:

which server roles are assigned to your login?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

soniaj SSC-Addicted Points: 465 More actions · Answer 2

When i ran SELECT IS_SRVROLEMEMBER('sysadmin');

It resulted '0'.

Looks like i have not been assigned admin permissions.

sonia

soniaj SSC-Addicted Points: 465 More actions · Answer 3

Hello,

I checked with my Network admin and he replied saying "You are a admin on this Windows 7 VM so you can just terminal service in to do anything including changing your right in SQL. "

Can you help me with understanding this?

Thanks,

Sonia

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Members of the built-in Adminstrators group in Windows are not automatically members of the sysadmin role since SQL Server 2008. Only the one that installed SQL Server is granted sysadmin privileges.

There is a work-around:

http://stackoverflow.com/questions/2833373/sql-server-2008-database-engine-login-failed-for-administrator-user-in-windows-7

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

More resources:

Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005

Recovering SQL Server Built-in Administrator Access to Database

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

mvishnu7 SSC Journeyman Points: 97 More actions · Answer 6

hi

select * from fn_my_permissions(null,'server')

run this query in your server

soniaj SSC-Addicted Points: 465 More actions · Answer 7

Koen Verbeeck (2/6/2012)
Members of the built-in Adminstrators group in Windows are not automatically members of the sysadmin role since SQL Server 2008. Only the one that installed SQL Server is granted sysadmin privileges.
There is a work-around:
http://stackoverflow.com/questions/2833373/sql-server-2008-database-engine-login-failed-for-administrator-user-in-windows-7

Thanks Koen.. This worked.. Thanks soo much! 🙂

Sonia

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 8

soniaj (2/6/2012)
Koen Verbeeck (2/6/2012)
Members of the built-in Adminstrators group in Windows are not automatically members of the sysadmin role since SQL Server 2008. Only the one that installed SQL Server is granted sysadmin privileges.
There is a work-around:
http://stackoverflow.com/questions/2833373/sql-server-2008-database-engine-login-failed-for-administrator-user-in-windows-7
Thanks Koen.. This worked.. Thanks soo much! 🙂
Sonia

Allright, glad that it worked out.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP