Getting 'connection to SQL server' error while installing a .exe file of my c# project on client's computer

Question

I have created software in c#.net which has some database into it. After creating a .exe file it works fine in my system but after installing that application in another system it gives following error.

Error: A network-related or instant 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 connection. (provider: SQL Network Interfaces, error: 26 - Error locating server/instance specified).

I have tried installing SQL Server and .net framework in client's machine but still, it's not working.

Do I need to install anything else on the client's pc to run my application?

Well what have you setup as his sql server, and connection string? Are you sure you have access to it? — BugFinder, Apr 03 '19 at 14:56
You need to install Sql Server, create your database, configure the connectionstring of your application to use this database — Steve, Apr 03 '19 at 14:56
It is likely that your client does not have access to whatever database you were using. Look at connection strings in your config — Hasta Tamang, Apr 03 '19 at 14:56

score 0 · Answer 1 · answered Apr 03 '19 at 14:57

0

Check the connection string to the database. The connection string should point to the SQL database the Client has access to. Most of the time this is not the same as the one you are using while developing.

answered Apr 03 '19 at 14:57

ywwy

124
1
2
18

how would I add a connection string to my application after creating a .exe file? – virendra ahire Apr 03 '19 at 15:05
Do I need to add it before publishing ? – virendra ahire Apr 03 '19 at 15:06
Do a search on ConnectionString in your solution. It can be in the c# code or in a config file. – ywwy Apr 03 '19 at 15:11
Once you have found it, post it – ywwy Apr 03 '19 at 15:13
– virendra ahire Apr 03 '19 at 15:15
You should make a backup of your Database QPGenerator,. And restore it on your clients machine. Then change the source in your connectionstring to point to that restored database. – ywwy Apr 03 '19 at 15:32
Yes but, how would I change the connection string after creating a .exe file ? – virendra ahire Apr 03 '19 at 15:36
You can have the config file in the same folder as your exe file. I have to look it up myself how to do it exactly. – ywwy Apr 03 '19 at 15:42
so, would you tell me after doing some research on it? – virendra ahire Apr 03 '19 at 15:50
you could define the path where the config file is located in your code, like this : AppDomain.CurrentDomain.SetData ("APP_CONFIG_FILE", "path to config file") . [discribed here](https://stackoverflow.com/questions/1838619/relocating-app-config-file-to-a-custom-path?lq=1) – ywwy Apr 03 '19 at 16:16
[this](https://stackoverflow.com/questions/14194114/configuration-file-in-c-sharp-default-location) page might also help you finding your config file in your client's pc – ywwy Apr 03 '19 at 16:36

score 0 · Answer 2 · answered Apr 03 '19 at 15:01

0

Change connection string of localhost to IP address of Database PC.

answered Apr 03 '19 at 15:01

Can u tell me a step by step process to do it because I'm a beginner at this? – virendra ahire Apr 03 '19 at 15:07
Yes go to code and change connection string line of localhost to server name. In order to figure out server name or IP address open CMD and write "ipconfig /all" – Apr 03 '19 at 17:38

score 0 · Answer 3 · answered Apr 03 '19 at 17:42

You are going to have to add a connectionstring to your App.config file.

    <connectionStrings>
        <add name="ConnectionString" connectionString="Data Source=PRANOYPC\SQLEXPRESS; Initial Catalog=DatabaseName; Integrated Security=True;" providerName="System.Data.SqlClient" 
    </connectionStrings>

If you are using Windows authentication you can leave Integrated Security = True if not you will have to provide the authentication for the Database.

Also you have to make sure that the Client has access to the database that you are trying to access.

Getting 'connection to SQL server' error while installing a .exe file of my c# project on client's computer

3 Answers3