enable login failed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » enable login failed

enable login failed

Rate Topic

Display Mode

Topic Options

Author

Message

sumith1andonly1

Posted Thursday, February 14, 2013 2:56 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, May 05, 2013 11:09 PM
Points: 66, Visits: 260

enable login failed .for login 'sa'

sql server error 15151

Post #1419902

anthony.green

Posted Thursday, February 14, 2013 3:00 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Is this topic, releated to this topic http://www.sqlservercentral.com/Forums/Topic1419820-391-1.aspx? If so dont cross post.

15151 means login doesnt exist or you dont have permission.

Go seek permission from a higher power who has the nessesary rights to do what is needed.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1419907

GilaMonster

Posted Thursday, February 14, 2013 3:01 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 37,678, Visits: 29,933

Go speak to your DBA and ask him for additional permissions on this server.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1419908

sumith1andonly1

Posted Thursday, February 14, 2013 3:17 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, May 05, 2013 11:09 PM
Points: 66, Visits: 260

actually the user (with admin privileges) is already removed from domain and machine.
the only user having sysadmin privilege is 'sa' .

i cannot find any way to add new sysadmin user?

Post #1419918

anthony.green

Posted Thursday, February 14, 2013 3:22 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Then going back to the first post in the other topic, start SQL in single user mode, ensure your a local admin on the windows box and add a new sysadmin user to SQL.

Post #1419921

e4d4

Posted Thursday, February 14, 2013 3:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 150, Visits: 1,026

Or try http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/ need no instance shutdown or reset.

Post #1419927

GilaMonster

Posted Thursday, February 14, 2013 3:35 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 37,678, Visits: 29,933

Will only work if System is still a SQL login with sysadmin.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1419928

« Prev Topic | Next Topic »

Permissions