Friday, March 9, 2012

Remote MSDE Connection string?

For a SQL Server 2000 connection string I usualy use the following format:

server=somewhere.com;uid=sa;password=sa;database=myDB

or:

server=66.33.11.123;uid=sa;password=sa;database=myDB

However, now I am dealing with a remote MSDE database. What is the format to connect to a remote MSDE database? Is it:

server=<IPADDRESS>\<INSTANCENAME>;uid=sa;password=sa;database=myDB

Where <IPADDRESS> is the Ip address of the remote machine and <INSTANCENAME> is the MSDE instance name. Is this correct? If not, what am I doing wrong?I've used the <MACHINENAME>\<INSTANCENAME> successfully before, but I'm not sure about the <IPADDRESS>\<INSTANCENAME> combo.|||I would only think that I can use the <MACHINENAME>\<INSTANCENAME> way if the machine was on my local area network. But the machine is not, it's on a remote network on the internet. So I couldn't use <MACHINENAME>\<INSTANCENAME> because how would it find that machine unless it had an IP address?|||you need the ip address, and have that msde server accessible through their firewall.|||So,... in other words,.. I was right,... the correct way to access it is:

server=<IPADDRESS>\<INSTANCENAME
correct?

No comments:

Post a Comment