Click here to Skip to main content
15,901,001 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
dear friends,
i create setup file and instal it on another PC.
when run the software an error will show like this:
"A network related or instance-specific error occured while establishing to sql server.the server was not found or was not accessible.verify that the instance name is correct and that sql server is "
please help.what is the problem?
Posted
Comments
Timberbird 14-Aug-12 6:35am    
Looks like you work with database in your development environment, and this database is unavailable from the server you install your software on

Hi Dear.

you should check you database connection. Basically this error comes when you database like SQL Server is not running or your database path is wrong.
 
Share this answer
 
Hi,

This exception occur when,

1) You have setup incorrect Database Credential\Database server instance name\Database Name.(High possibility)
2) your database server is not accessible. (High Possibility)
3) Your SQL service is down.(Less possibility)


Hope you find solution from this information

Thanks
-Amit Gajjar
 
Share this answer
 
"A network related or instance-specific error occured while establishing to sql server.the server was not found or was not accessible.verify that the instance name is correct and that sql server is "

Above error only shown when there is no connection established with the database. So first check the existence of SQL Server in your Setup file and also the connection.


Thanks
Ashish
 
Share this answer
 
Comments
FM7 15-Aug-12 6:30am    
my connection string is:
connection string="server=.,database=book,integrated security=sspi";

is it wrong?
AshishChaudha 15-Aug-12 13:54pm    
what about login credentials???? userid and password

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900