No login access to SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » No login access to SQL

No login access to SQL

Rate Topic

Display Mode

Topic Options

Author

Message

Tom West

Posted Monday, November 12, 2012 5:11 AM

SSC 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

Lowell

Posted Monday, November 12, 2012 5:25 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:22 PM
Points: 11,792, Visits: 28,077

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

Tom West

Posted Monday, November 12, 2012 7:10 AM

SSC 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 »

Permissions