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 |
|
bainn
Starting Member
1 Post |
 Posted - 2009-12-09 : 12:59:11
|
| I have a solution with two three projects. The application project (is the startup project), the data access project and the setup project. All the connection to the sql server 2008 database is through the data access project. Actually, there are two databases and access to these databases is through the data access project. Everything works fine on the development computer.When it is compiled using the setup project and installed on the target computer an error message appears. The following is the message : "A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network interfaces, error 26 - Error Locating Server/Instance Specified)".I have check the config files to make sure the names there are correct. These are the two connection string names:1. Data Source=LABORATORY\SQLEXPRESS2008;Initial Catalog=PreSoft.Digital.Archive;Integrated Security=True2. Data Source=LABORATORY\SQLEXPRESS2008;Initial Catalog=PreSoft.Archive.Users;Integrated Security=TrueI need help ASAPThank you folks, in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
System.Data.SqlClient.SqlException