SQL Server does not exist or access denied

Question

I am new to using Dreamwaver. I am trying to create a
database connection to my MS SQL server but I keep getting the
following error message when I test the connection: 
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.
I can set up an odbc connection to the database without any
problems so I don't believe it is a security issue.
I am using Dreamweaver MX 2004 on a WIndows XP SP2 computer
connected to a MS Active Directory network. The SQL Server is MS
SQL 2000 (I have also tried to connect to a MS SQL 2005 database
with the same results) running on Windows Server 2003. I am
scheduled to take a class for Dreamweaver, but it has been
postponed until June and I can't wait that long to fix this. Any
help is appreciated, Thanks

wizbang · Answer

I had this same problem and on a hunch I deleted the brackets so that the connection string instead of being,

"Persist Security Info=False;Data Source=[THESERVER\SQLEXPRESS];Initial Catalog=[AdventureWorks];User ID=[ATEST];Password=[kjdkjdkjd]"

is now,

"Persist Security Info=False;Data Source=THESERVER\SQLEXPRESS;Initial Catalog=AdventureWorks;User ID=ATEST;Password=kjdkjdkjd"

This was in Dreamweaver 8.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded