August 18, 2013 at 10:23 am
hello every one.. this is my first post here. i have a vb application that i want to connect to sql server hosted on a different pc. I need to connect with ip address. What ip address should i give to that sql server ? will it be fine if I give the same address of that pc which is in domain ?
August 18, 2013 at 11:47 pm
Unless you have installed SQL on a cluster, you can't assign an IP-address to the SQL instance. The SQL instance will use the IP-address of the host server / pc.
August 19, 2013 at 1:07 pm
You should be able to connect with the ip address of the server\pc where the sql server is installed. Just use it in the connection string. A couple of possible issues. You might need to enclose it in square brackets []. also, is it the default instance, or is it a named instance of sql server. if it is a named instance, you will need to include that, like servername\instancename. also, if the default port number is not used, you may need to include that. do a google search for connection strings, and you will find plenty of examples.
Leonard
August 21, 2013 at 11:33 am
You can use ping [SQL Server Name] to get the ip.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply