خرید بک لینک

Vote count: 0

I am trying to run my SQL Server based Winform application from two computers which are coected in LAN.(Desktop PC, Laptop)

I followed MSDN and the below mentioned StackOverflow answers:

LINK 1 (Verified Answer)

LINK 2 (dyslexicanaboko's Answer)

I tried the below steps:

My Winform app's coection string:

<coectionStrings>
    <add name="WinFormMetroTest.Properties.Settings.SampleDBCoectionString"
        coectionString="Data Source=192.168.1.6SAINSTANCE;Initial Catalog=SampleDB;User Id=sa;Password=bpmadmin1;Integrated Security=False;"
        providerName="System.Data.SqlClient" />
</coectionStrings>

In my Laptop:

  • I have SQL Server 2008 R2 Enterprise edition, Windows 7 64bit Ultimate.
  • In SQL Server Configuration Manager, I enabled the protocol for TCP/IP for my instance "SAINSTANCE" and in the IP addresses, I specified TCP port as 1433 for all IPs. In IP4, I mentioned my Laptop's IP 192.168.1.6 and restarted SQL Server Instance and SQL Server Agent.
  • In Firewall setting, Inbound Rules - Specified TCP port as 1433

And finally I run my application in my Laptop, it gets coected to my DB and works perfectly.

In my Desktop PC:

  • I have Windows 64 bit Ultimate. I do not have SQL Server 2008 R2 or any other version here.
  • In Firewall setting, Inbound Rules - Specified TCP port as 1433 and also UDP port as 1434 Outbout Rules - Specified TCP port as 1433 and also UDP port as 1434

Now I ran my application in Desktop PC and it shows coection error. I also disabled firewall completely in my Desktop PC and tried, it doesn't coect and shows the same error.

Please tell if I went wrong in any steps which I referred or provide possible fix for this.

Please comment if you require any further details about this issue.

asked 57 secs ago

برچسب: نویسنده: استخدام کار تاريخ: شنبه 12 تير 1395 ساعت: 13:44

صفحه بندی