SQL Server 2008 R2 only system databases show in system dsn configuration

Posted on 2011-05-03
Last Modified: 2012-05-11
I am migrating an application from SQL Server 2003 to SQL Server 2008 R2.  I have restored the backup of the database to the new server.  I am now trying to connect to it from a Windows 7 client.  I am using a System DSN to setup the ODBC connection.  The DSN configuration connects to the SQL server.  

However, when I try to select the restored database, the selection for Change the default database to:  only displays System databases.  Ie:  master, msdb, and tempdb.  

Any thoughts?
Question by:ctconnolly
    LVL 16

    Expert Comment

    What authentication are you using, SQL server login or windows authentication?

    Author Comment

    SQL Server and Windows Authentication Mode is the server authentication method.  The ODBC connection is using a SQL Server authentication.  The credentials being entered into odbc are for the owner of the database.
    LVL 12

    Expert Comment

    Have you set up the Login on your new server?

    You need to set up the Login (reference an active directory login or specify an internal SQL server login) then map it to users that have access to the database
    LVL 16

    Accepted Solution

    Are you using the same sql login name that existed on the old system, if so it may be this that is causing you an issue.

    Author Closing Comment

    Excellent!  Ran the Auto_Fix and the DB showed!


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now