Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Cannot connect to sql server through ado.net

Author  Topic 

tvjunkie
Starting Member

1 Post

Posted - 2010-05-20 : 05:17:11
Hi everyone,

i have the problem, that i can connect to an sql server 2005 with sql management studio with sql authentication. But with the same credentials i cannot connect through ado.net with a connection string like that:

server=SERVERNAME; database=DATABASENAME; Persist Security Info=true; User ID=USERID; Password=PASSWORD

I have no administrative access to the server, so i can not say anything about the configured users.

Does anyone know, if the management studio gives any additional information which the sql server could miss?

Thanks for all hints
   

- Advertisement -