SQL Server on a remote computer

I have an instance of SQL Server Express on a computer with IP 192.168.66 on the home network.

I enabled TCP / IP on port 49170 and added the incoming rule to the Windows firewall.

I have an application that I want to install on different computers inside my network. When I test my application in Visual Studio, I cannot connect to my instance on the remote computer.

<connectionStrings>
    <add name="EquipamentoDal.Properties.Settings.ExtinguisherMngConnectionString"
         connectionString="Data Source=192.168.1.66,49170;Initial Catalog=ExtinguisherMng;Integrated Security=True"
         providerName="System.Data.SqlClient" />
 </connectionStrings>

Server name DESKTOP-HU51203\EXPRESS. What did I do wrong so I couldn’t connect?

+4
source share
1 answer

, , IP-, , .

SQL Server Express - "" SQL Server (Standard, Workgroup, Developer Enterprise Edition) :

  • - SQL Server
  • SQLEXPRESS
  • SQL Server Express AttachDb LocalDb - SKU/ AttachDb LocalDb.

AttachDb LocalDb, :

, <host>\<instance name>,<port> Data Source= Server=, . Data Source=foo\SQLEXPRESS,1433, :

Data Source=192.168.1.66\SQLEXPRESS,49170;Initial Catalog=ExtinguisherMng;Integrated Security=True

, , , , Active Directory Kerberos, SQL Server Express , ( NT AUTHORITY\NetworkService , , Integrated Security=True ( Integrated Security=SSPI, , SSPI ), SQL Server .

  • Login ( , , , sa, )
  • , Integrated Security=True User Id=<userName>;Password=<password>;
+3

Source: https://habr.com/ru/post/1664946/


All Articles