Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Hot to set which IP address MSDE to use when there are several IPs?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-11-12 : 08:26:49
Kristian writes "Hello!
I hope that my question will not look a stupid one!:) Here it is:
I want to install MSDE from the setup of my product. And if the computer has more than one IP address, is there some command line switch, which tells SQL server which IP address to use or some other way to do this?
Thank you in advance!"

sbt1
Yak Posting Veteran

89 Posts

Posted - 2003-11-13 : 13:51:53
Mmm, the connection strings in your application code should use the server name, not IP number. For example, in apps I write I pass the server name, user name, password, and database name as parameters to the function that makes the database connection.

Even if you can connect using an IP instead of a computer name, I'd recommend not to, since IPs usually change :-)
Go to Top of Page

krisbg
Starting Member

5 Posts

Posted - 2003-11-14 : 10:51:46
Thank you!
Go to Top of Page
   

- Advertisement -