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.

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

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.

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:

<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.

Did you try to use IP address in Data Source?