Failed Local connection but remote connection OK.

Hi
I can connect to a remote SQL Express server using the connection string

_str_connectionStringX = "Data Source=192.168.1.67; Provider=SQLNCLI11; DataTypeCompatibility=80; Network Library=DBMSSOCN; Initial Catalog=vocab; User ID=[ID]; Password=[Password]"

But Not a local server instance. Any ideas? No problem connecting to the local server using SSMS.

Thanks
TW.

0 answers