+ Post New Thread
Results 1 to 5 of 5
Windows Server 2008 R2 Thread, Unable to Access SQL Server 2008 R2 Database via management studio in Technical; Hi I am unable to access a database via the management studio. I have tried logging in using windows authentication ...
  1. #1

    Join Date
    May 2009
    Posts
    575
    Thank Post
    0
    Thanked 89 Times in 50 Posts
    Rep Power
    30

    Unable to Access SQL Server 2008 R2 Database via management studio

    Hi

    I am unable to access a database via the management studio.

    I have tried logging in using windows authentication and SQL authentication.

    I believe the default SQL user name is SA and a blank password.

    The problem we have is that this was set up by a 3rd party who we are now officially in dispute with and they simply aren't talking to us at the moment. We usually set up our SQL databases to use windows authentication but my gut feeling is that they have used sql authentication and a non standard password.

    Is there any way we can access this or at least confirm the level of authentication used?

    Any assistance with this would be greatly received!

    Cheers
    Last edited by superatticman; 6th August 2013 at 11:54 AM.

  2. #2

    Join Date
    Jul 2009
    Posts
    267
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    superatticman,

    whats the error you get when trying to load then login management studio? is it access denied? are the SQL services started>?
    are you connecting to the right DB? could be a number of things.

  3. #3

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    From your first post, i'm a bit unclear on the detail, but I'm assuming that you can start Management Studio using your Windows account, but cannot connect to a particular database.

    Have you tried mapping your user to the database from Security>Logins>Properties>User Mappings?

    Otherwise, try this:
    SQL SERVER – Forgot the Password of Username SA | Journey to SQL Authority with Pinal Dave

    Sometimes the sa account is disabled, and another (secret) account is created with sa privileges as a security measure to prevent attacks on the sa account.
    Last edited by jinnantonnixx; 6th August 2013 at 12:32 PM.

  4. #4

    Join Date
    May 2009
    Posts
    575
    Thank Post
    0
    Thanked 89 Times in 50 Posts
    Rep Power
    30
    Hi

    The sql database is running fine as an application that uses it is functioning perfectly.

    This is the process I am using to gain access. We also need to start backing this database up so I need the credentials for the backup software. This is what alerted me to the password issue as I could not gain access via arcserv


    Standard screen you get when opening management studio


    Sometimes, this screen appears first, which suggests that the 'sa' and blank password may be hitting a problem elsewhere


    This is the error which I get the majority of the time when entering the above credentials and various other standard passwords which we use. Plus when attempting to log in using windows authentication.

  5. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by superatticman View Post
    I believe the default SQL user name is SA and a blank password.
    The password won't be blank, it would have been set when the SQL instance was installed if mixed mode authentication was enabled.

    How are your databases being backed up? Any scripts that may contain the SA password in them?

    I think you also need to specify a SQL instance to connect to. ie localhost\sims2008.
    Last edited by Rawns; 6th August 2013 at 12:43 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server 2008 R2 move from SQL Server 2005 Free
    By M0MST in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 15th January 2013, 10:26 AM
  2. SQL Server 2008 R2 enterprise evaluation edition
    By sippo in forum Windows Server 2008 R2
    Replies: 13
    Last Post: 17th May 2012, 02:47 PM
  3. Need a virtal program to practice Windows Server 2008 R2 on
    By simples12345 in forum General Chat
    Replies: 18
    Last Post: 6th July 2011, 03:18 PM
  4. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  5. Hyper-V Server 2008 R2 standalone - remote management and RAID
    By OverWorked in forum Windows Server 2008 R2
    Replies: 13
    Last Post: 14th November 2010, 08:35 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •