C# window Application

Hello Sachin,

I have tried all the steps you shown me and everyonce suggestion but nothing is working.

I even tried to install SSMSQLSERVER on the user computer but the system keep giving me the same error like 

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 sqlserver is configured to allow remote connection. (provider Sql Network interfaces, error; 26 -Error Locating Server/Instance Specified)

I thought it is firewall that is blocking the sqlserver port and assign 1433 to the inbound port but it is still not working.

Please though SSMSQLSERVER was successfully installed and when I try to login then the error popup, but what could be blocking the sqlserver from working on the user computer though everything work fine on my laptop ?

1. Go to the folder which is not opening and right-click and select properties
2. Select the Security tab. ...
3. Click Edit.
4. In the Group or user name section, select the user(s) you wish to set permissions for.
5. In the Permissions section, use the checkboxes to select the appropriate permission level.
6. Click Apply.
7. Click Okay.

Thank you Sachin,

That is exactly the answer am looking for, but with the MDF file, what I can see now is [ Program Debug Databases], is it the same as MDF file.

Thank you Sachin, that is exactly the answer am looking for, but with the MDF file, what I can see now is [ Program Debug Databases], is it the same as MDF file

Thank you Kumar, Muhammad,and Sam but please my question is must I install SSMSQLSERVER on the user computer before my application can work because I thought I have published the C# application with the sqlserver

Ensure that SQL Server is executing. You can do that in many ways but since I currently do not have SQL Server installed in my system I cannot confirm how to do that. I assume the system has SQL Server Management Studio (SSMS) installed and you can use that to check on SQL Server. Otherwise there are many ways to look at and start services; SQL Server is a service.

I think you can use SSMS also to get the connection string.

Another way to get the connection string is to first create a text file with any name and then change the extension to udl. So in other words create cs.txt and rename it to cs.udl. Then open the file (double-click or whatever). A GUI will open that will make it easy to create a connection string. Then open the udl file using a text editor and you can copy the conmnection string from there.

From the error message it’s apparently not able to establish connection with sql server. Check the following

1. sql server installed on the system?
2. Is the connectionstring set correctly?
3. if connecting sql server not installed and connecting from different system or server then ensure the internet connection and communication between client system and sql server. You can check using telnet command in the command prompt.