Post reply

No login access to SQL

  • November 12, 2012 at 5:11 am

    #264621

    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

  • November 12, 2012 at 5:25 am

    #1558120

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 12, 2012 at 7:11 am

    #1558162

    Great, thanks - I knew there was the option, I was just looking in the wrong place!

Viewing 3 posts - 1 through 2 (of 2 total)

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