Sql DB Connection Error in Installed Apps on Client System

Pnkl

Hello Guys,

I have developed one windows application in .net framework 3.5, VS 2008 and inbuilt sql server Database,

But one issue arise on client pc when I installed application, when I run the App then one Error coming relating to Database connection :

'A network-related or instance-specific error occurred 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)'

My App config ConnectionString is :

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DataBase\Database1.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

Also, I have installed Microsoft Sql Server Compact 3.5 SP1 on Client System

Please me reply if U have solution

Thanks....

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dazy Parker11y ago
Hello,

Please check these things which has been mentioned in this blog:
http://www.sswug.org/articlesection/default.aspx?TargetID=44331

Good Luck!!
0
Srinivas Pabballa11y ago
First check your Sql Authentication is working properly or not.

if sql authentication is not working use windows authentication.

Check ur database name and ur table name properly first and if everything is okay

i suggest you to use simple code as below for connection string in web.config file..

i.e

sql authentication string is :
"server=servername;database=databasename;uid=sa;pwd=password"

if ur database is in ur own system u can use the

Windows authentication connection string:

"server=servername;database=databasename;trusted_connection=true

in the c# code u can use this as below

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ToString());
0
Raja T11y ago
Hi, Checkout bellow points
Basically, when you failed to connect to your SQL Server, the issue could be:
1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.
Refer bellow urls also

http://stackoverflow.com/questions/16256533/a-network-related-or-instance-specific-error-occurred-while-establishing-a-conne

http://stackoverflow.com/questions/1391503/a-network-related-or-instance-specific-error-occurred-while-establishing-a-conne

http://www.codeproject.com/Questions/335874/A-network-related-or-instance-specific-error-occur

http://www.codeproject.com/Questions/686076/A-network-related-or-instance-specific-error-occur
0
Karthikeyan K11y ago
Hi Sir,

Refer the following links

1.http://www.c-sharpcorner.com/UploadFile/5089e0/create-single-connection-string-for-all-windows-form-in-net/

2.http://www.c-sharpcorner.com/UploadFile/1a81c5/configuring-connection-string-in-app-config-file-during-runt/
0