SQL Local VS Machine Name

[Developer/Programmer]

Hey,

I am using VB.NET. In my code I have used the SQL connection string "workstation id=(local);packet size=4096;integrated security=SSPI;data source=(local);persist security info=False;initial catalog=TestData" to access the database. "Local" is working on my machine.

I created a windows installer using setup wizard in Visual Studio.Net. I installed it on another machine and when I tried to run, its having trouble in accessing the database. "Local" seems to be not working. So I had to include Machine Name in the connection string and create separate installer for that machine.

I have couple of questions:
1. What do I need to do to make "local" work?
2. What modifications do I need to do to have the SQL connection string same for every machine?

Thanks for your help.

[Elton Wells]

Since this question is specific to ADO.NET, I suggest posting this question to the microsoft.public.dotnet.framework.dotnet newsgroup. You may want to also look at Connection Strings.com.

- Elton