I am using CS4 and trying to get my connection string set up with the SQL database that is being hosted by LP.  We are on a windows based account and use Plesk for the admin side of things. 

I am able to create an odbc connection in plesk with no problems and when i test the connections it suceeds with no errors.  However when i try and create the connection string in DW(cs4) i get an access deined error.  I have confirmed a thousand times that the user id and password are correct.  Can anyone point me in the right direction.

Here is my connection string i am using in DW.  I have tried both a ODBC as well as a OLEDB connection string.  See below for my connection strings.

Provider=sqloledb;Data Source=ipofserver;Initial Catalog=db_name;User Id=username;Password=password


Driver={SQL Server};Server=ipofserver;Database=db_name;Uid=username;Pwd=password

Thanks in advnace.

Nick