I have 1 PC (Windows Server 2003 + SQL Server 2008)
and 2 PCs (MS SP2 + my APP)
how I can let my APP connects to sql server 2008 on other PC My APP will connect to server to store data in SQL Server 2008 and re开发者_StackOverflow社区ad/delete/edit (basic operations)
what is the best way to do that?
NOTE: my APP is written in C# (.NET Platform)
Look here:
how to connect to another sql server database(server pc) in local area network
How to connect to SQL server through IP
From Connection strings for SQL Server 2008 you have:
Connect via an IP address
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;InitialCatalog=myDataBase;User ID=myUsername;Password=myPassword;
DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server.
精彩评论