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

No login access to SQL Expand / Collapse
Author
Message
Posted Monday, November 12, 2012 5:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:11 AM
Points: 31, Visits: 164
Hi,

I have received a new laptop with sql server 2005 installed and configured. Unfortunately I do not know the sa password and my windows user does not have permission to access the localhost (its a dev laptop). The guy who set this up has unfortunately gone, so I'm a little stuck.

I now have admin access on the maching, so wondered is there a way that I can give myself permissions at windows level to get onto the DB? I don't want to go through the process of re-installing the application from scratch if I don't have to.

Thanks
Tom
Post #1383620
Posted Monday, November 12, 2012 5:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:47 PM
Points: 12,890, Visits: 31,848
in 2005, there's the surface area configuration utility to add yourself:



in 2008, you need to start the service in single user mode, and add yourself.
http://www.bradg.co.za/?p=51


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 #1383632
Posted Monday, November 12, 2012 7:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:11 AM
Points: 31, Visits: 164
Great, thanks - I knew there was the option, I was just looking in the wrong place!
Post #1383682
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse