remote access to sql server 2000
-
-
hi I want to connect to a sqlserver instance on another computer in the workgroup network. my program is win application with c# VS.NET 2008 and SQL Server 2000. what settings are needed for my sqlserver instance and my application? can you help me?
H.R
Do you want to Access the SQL Database or you just want a remote Connection ? if you want to access the Database i dont think your Connection String will change, it will still be Normal , or are you asking how your Connection string look like ?
"User id=SA;Password=oops;Server=myremoteserver;Database=mydb"
Please be Clear
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
-
hi I want to connect to a sqlserver instance on another computer in the workgroup network. my program is win application with c# VS.NET 2008 and SQL Server 2000. what settings are needed for my sqlserver instance and my application? can you help me?
H.R