Connecting to remote database using C#

[stephentanph]

Hi there I have been trying to connect a c# windows application to a remote sql server. However, i am still unsuccessful in doing so. Please help here's the software im using visual studio.net sql server 2000 Connecting to a local sql server has no problem however when im trying to connect my c# application to a remote sql server the connection cannot be established. Here are the connection string i tried... so far Data Source=[remote_ip],1433;Network Library=DBMSSOCN;Initial Catalog=pubs;Database='Northwind'; another is Server=[remote computer ip here];Trusted_Connection=sspi;Database='Northwind' Please help me out on this thanks... i don't know what's the problem is it sql server settings? regarding making it remote? or the connection string ... the network connection has no problem so far.. both computers is connected well through a router and recognizes each other. thanks in advance. Stephen Tan

[Gokulan Venattil]

I think there is some problem in ur conn string. Connection string must contain SERVER=myIP;user id=myuserid;password=myPwd;DATABASE=MyDatabaseName Gokul

[J4amieC]

You've not told us the most vital information we need to answer this question... the error message you receive on trying to establish the connection. Assuming its a permission denied, which it probably is, specify a username and password in the connection rather than trying a trusted connection.