July 30, 2008 at 2:56 pm
I'm trying to connect to a SQL Server2005 database on a MS Windows Server 2000 from my PC using Microsoft Visual Developer Environment.
This is my connection Profile:
DataSource: MS SQL SERVER ( ole db)
Server Name: Servername/ServerInstanceName
Sql Server Authentication:
User name: xx
Password: xx
Database Name= thedatabasename
I get the following error message:
DBNETLIB Connection Open ( Connect() ). Sql Server does not exist or access denied.
Thanks for your help.
rfalagan
July 31, 2008 at 3:44 am
It should be
DataSource: MS SQL SERVER ( ole db)
Server Name: Servername\ServerInstanceName
You need to use a backslash between server and instancename
[font="Verdana"]Markus Bohse[/font]
July 31, 2008 at 6:55 am
Sorry, I meant to write a (ServerName\ServerInstanceName).
I do have a back slash.
July 31, 2008 at 8:46 am
are you able to ping the server?
July 31, 2008 at 9:49 am
yes
July 31, 2008 at 9:53 am
are you able to connect from other places (odbc, udl file, etc)? if so, try using the connection string from where you ARE able to connect. if not, check things like sql port, firewalls, etc.
July 31, 2008 at 9:56 am
have you enabled the databse to allow remote connections?
July 31, 2008 at 10:00 am
Seems to connect fine in the same box (server), the problem happens when I try connecting to the server from another computer.
I think is a port, firewall issue. Don't know in specific what to do.
July 31, 2008 at 10:16 am
yes, remote connections are allowed.
July 31, 2008 at 10:20 am
if you suspect your windows firewall, you can temporarily disable it, then add an exception to it if you're able to connect after it's turned off. also, check to make sure you're using a protocol that your server is listening on, or if not, enable the protocol you're using on the server.
are you able to connect from any machine OTHER than yours or the server?
July 31, 2008 at 10:40 am
Check the SQL Browser service and make sure it is running. This is required to be running when you have a named instance.
If you don't want the SQL Browser service running, you need to identify the port the named instance is running on and add the port to the connection string. This usually means setting a static port for the instance and/or creating DNS entries for that instance on that port.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 10:53 am
Can only connect locally. How do I disconnect the Firewall in MS Windows Server 2000.
It might help to say that on the same Box (Server). I have SQL SERVER 2000 instance running in addition to the SQL SERVER 2005 ( the one I'm having issues with ). I'm doing a side by side set up of SQL SERVER 2005. Never had this issue with SQL Server 2000.
July 31, 2008 at 10:56 am
Is SQL Browser Running?
July 31, 2008 at 11:58 am
I have a named instance. Yes the Sql Browser Service is running.
July 31, 2008 at 12:00 pm
Yes. The Sql Browser Service is running.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply