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.
| Author |
Topic |
|
macca18
Starting Member
7 Posts |
 Posted - 2006-05-22 : 10:45:18
|
| Hi,My C# app uses SQL Server 2005 Express edition. I store my connection string in a config file. My application will run on numerous machines and therefore the machine name will be different each time. What I would like is a generic connection string so that I don't have to change it each time I install my app on a different machine.I therefore want to avoid specifing the machine name in the connection string as shown below :-"Data Source=MachineName;Initial Catalog=pubs;Integrated Security=SSPI;" Is there any way to make this connection string generic so that it can stay the same between different machines?ThanksMacca |
|
|
timgaunt
Posting Yak Master
115 Posts |
Posted - 2006-05-22 : 10:53:34
|
| What about specifying the IP address of the machine instead?Tim |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-22 : 20:41:27
|
Use the loop back address 127.0.0.1
KH |
|
|
|
macca18
Starting Member
7 Posts |
Posted - 2006-05-23 : 06:00:44
|
| Thnaks for the replies guys.I want to avoid any machine specific settings so that I don't have to change the connection string each time I deploy my app to a different machine. Any ideas?ThanksMacca |
|
|
|
|
|
|
SQL Server 2005 Express Edition Connection string