Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failing to get logged in sql server throught windows login Expand / Collapse
Author
Message
Posted Wednesday, December 11, 2013 9:29 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135
Hi friends

At one of our client side we are not abled to get logged in sql server through windows login and we donot have sa pwd or any other sql logins.Any idea now how to proceed.

Thanks and regards
Anoop Pandey
Post #1522128
Posted Friday, December 13, 2013 9:32 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 3:24 AM
Points: 412, Visits: 10,887
If BUILTIN\Administrators has been left enabled you could try getting your account added to the server Administrator group temporarily to allow you to log in to SQL Server and then grant your windows account permissions.

If BUILTIN\Administrators has not been left in place then to recover the sa password you will still need to be added to the Administrator group on the server but you are going to need to stop SQL and start it in single-user mode e.g. net start mssqlserver /m this will then give members of the Administrator group access to SQL Server. You can then grant access and/or change the sa password.

There are a couple of articles on the web that go into more detail if you search for "recovering the sa password".
Post #1522768
Posted Friday, December 13, 2013 9:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 12,916, Visits: 32,080
anoop.mig29 (12/11/2013)
Hi friends

At one of our client side we are not abled to get logged in sql server through windows login and we donot have sa pwd or any other sql logins.Any idea now how to proceed.

Thanks and regards
Anoop Pandey


this script from microsoft has worked flawlessly for me twice now; it's a cmd/bat file which prompts you for the servername,a dn adds the current windows suer as an admin tot eh instance you identified.

http://archive.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=addselftosqlsysadmin&DownloadId=9198


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1522770
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse