My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Old 26-Jul-2012, 01:20 PM
G.W.Green G.W.Green is offline
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 485
Thanks: 0
Thanked 68 Times in 43 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 Images
File Type: png SQLCon.PNG (7.8 KB, 455 views)
File Type: png SQLCon1.PNG (26.0 KB, 428 views)
File Type: png SQLCon2.PNG (10.6 KB, 437 views)
File Type: png SQLCon3.PNG (33.5 KB, 444 views)
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 01:41 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.