C# application Deployment with remote server

Asked Feb 02 '16 at 08:02

Active Feb 02 '16 at 08:57

Viewed 186 times

I developed a small application in C# Winforms with a SQL Server database. Now I want to deploy it where client is using server with SQL Server installed on it, and he wants to use the .exe file on another machine.

I need to make a connection so I added my database files in SQL Server and I changed my connection string to this:

public class DatabaseConnection
{
    private static string constring = @"Data Source=192.xxx.x.xxx\MYSRV;Initial Catalog=dbEmployee;User ID=sa;Password=sa$123";
    public static SqlConnection cn = new SqlConnection(constring);
}

but I still can't run my application - I keep getting this:

Error .

edited Feb 02 '16 at 08:57

marc_s

732,580
175
1,330
1,459

asked Feb 02 '16 at 08:02

Iqbal Khan

Do you have an instance of SQL Server at that IP named "MYSRV". Check out http://www.connectionstrings.com/ As a side note its not a good idea to use sa for user connections – Fred Feb 02 '16 at 08:07
Check the IP address of the SQL Server which hosts your database. – bit Feb 02 '16 at 08:07
@bit i verified the ip address there is no problem with that. – Iqbal Khan Feb 02 '16 at 08:12
Can you connect to the database using SSMS ? – bit Feb 02 '16 at 08:17
yes, i checked the server machine and i used to the database with SSMS. – Iqbal Khan Feb 02 '16 at 08:21
Are you able to do all this from the machine on which the client has the .exe ? – bit Feb 02 '16 at 08:51
Probably a firewall issue, try searching. – CodeCaster Feb 02 '16 at 08:52

C# application Deployment with remote server

0 Answers0