No announcement yet.

Unable to connect to SQL Server errors

  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to connect to SQL Server errors

    If you get an SQL Server does not exist or access denied error, like this one:

    SellerDeck failed to open the database DSN=ActinicCatalog11. This prevents SellerDeck working.
    The error was:

    SQL Server does not exist or access denied.
    ConnectionOpen (Connect()).

    Please refer to the troubleshooting section in the MU Installation and User guide for possible solutions.

    There are two areas to check. The first is that the SQL Server service is running.

    • Open ‘SQL Server Configuration Manager’ from ‘Start | All Programs | Microsoft SQL Server 2008 R2 (or your version) | Configuration Tools’
    • Cilck ‘SQL Server Services’ from the tree on the left
    • You should now see a list of all the services related to your installation of SQL Server
    • One will be named ‘SQL Server (your instance name) and may have a state of ‘Stopped’
    • Double click this and start the service.

    The state should then change to running.

    If it’s a client PC across a network that cannot connect, the other area to check, is that you have enabled the TCP/IP protocol.

    • To do this, open SQL Server Configuration Manager as before
    • Click/Expand ‘SQL Server Network Configuration’ from the tree on the left
    • Now click on ‘Protocols for [SQL Server instance]’
    • In the window on the right you should see ‘TCP/IP’ Enabled or Disabled. If disabled, double click it and change it to Enabled.

    You should now be able to connect to the SQL Server.
    Attached Files