SQL Connection in Dreamweave CS3 ????

**jmcnellis** · 08:08 PM

I am currently developing a web site/database for my company and am having issue with Dream Weaver. I have a MS SQL 05 db set up on another machine and can connect fine using MS Visual Dev and MS Server Express, but I can not connect with Dreamweaver which is what I would prefer to use. I set up the SQL connect using Integrated Security and it will not allow me in. Any ideas ? Am I using the correct provider ??

Here is my code :
Data Source=******\***;
Initial Catalog=*****;
Integrated Security=SSPI"

I get the error Login faild for user. " the user is not associated with a trusted SQL Server connection.

**Brian07002** · 10-15-2008, 03:35 AM

Quote:

Originally Posted by jmcnellis

I am currently developing a web site/database for my company and am having issue with Dream Weaver. I have a MS SQL 05 db set up on another machine and can connect fine using MS Visual Dev and MS Server Express, but I can not connect with Dreamweaver which is what I would prefer to use. I set up the SQL connect using Integrated Security and it will not allow me in. Any ideas ? Am I using the correct provider ??

Here is my code :
Data Source=******\***;
Initial Catalog=*****;
Integrated Security=SSPI"

I get the error Login faild for user. " the user is not associated with a trusted SQL Server connection.

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

Hth

**Learning Newbie** · 10-15-2008, 02:22 PM

When you connect through VS and SSMS, what type of authentication are you using? My guess is you're simply passing your Windows account through, in all 3 instances. But maybe I'm wrong? If there's a specific user authenticating against the database when things do work, that would be your answer.

**Sean@WMS** · 10-17-2008, 12:03 AM

I would agree with @Brian07002

Esp. as the SQL server is not on the same machine as the site (which is a good structure usually), you should use SQL Server Authentication and provide the server location, name of the database, UID & PWD in the connection string.

Something like:

Code:

<add key="ConnectionString" value="server=123.123.123.123;database=MyDb;uid=MyUID;pwd=MyPWD;" />

There are definitely more secure ways to handle that, but this should get you going in the right direction.

**itHighway** · 10-31-2008, 10:26 AM

Did you try to use IP address in Data Source?