Click here to Skip to main content
14,298,716 members
Rate this:
Please Sign up or sign in to vote.
See more:
i have 2 computer in my company

1- first com Name= Server with port 1433
2- second com Name= Server with port 1430

And The two Pc have the same Database And I Make AppConfig
Like This

add name="DBCS"
connectionString="data source=Server,1433;Database=MnStores; Integrated Security = False;
User ID=pc1; Password=admin;
Trusted_Connection=false;"



But Not Working

What I have tried:

Can Not Connect To Specific Server
Posted
Updated 13-Mar-16 10:24am
Comments
OriginalGriff 13-Mar-16 5:10am
   
Stop reposting your question: bear in mind that it's a Sunday, and most of the western world is not working today. Continually reposting because you haven't had an answer is rude, and unnecessary. And if you continue to do it, I'm going to start considering it abusive behaviour...
Richard MacCutchan 13-Mar-16 6:34am
   
Change the name of one of the PCs so it is unique.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Try using the ip address instead of a name, example SQL Server connection string:
Data Source=123.4.5.6\SQLEXPRESS,1433;Initial Catalog=MnStores;Integrated Security=SSPI; User ID=pc1;Password=admin;

In SQL Server Configuration Manager->SQL Server Network Configuration->Protocols, check that named pipes and tcp/ip are enabled.

Check if your firewall is blocking the port.
   
v2

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

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100