SqlConnection on a LAN - how to do it

[ice78991]

I am trying to connect to a SQL Server 2005 database on a lan using SqlConnection. Should I attempt to connect through the IP address and port number or are there better options ? Can I use the server name for example. If the computer name is Comp1 and the server instance on the computer is myserve1 how would I formulate this addressing method?

 

[chiph]

ConnectionStrings has some really good examples of how to connect to various databases.

http://www.connectionstrings.com/?carrier=sqlserver2005

____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first