how i can access to other sql server at local network with my site?

carvr3hs  于 2023-06-21  发布在  SQL Server
关注(0)|答案(1)|浏览(141)

i design a web site in local network with visual studio. i use sql server in my site and when use it in current computer run success but when i try connect to other sql server in other computer in local network get this error:
SQL Server does not exist or access denied.

when i run with iis express in visual studio all is true but in iis get error i change many item in iis manager but cant correct this problem

jv4diomz

jv4diomz1#

Make sure you open TCP/IP protocal and open the sql port. You can reference how i can access to other sql server at local network with my site?.
Besides,the connection string is like UseSqlServer("Data Source=192.168.2.68;Initial Catalog=UserAuth;User ID=sa;Password=xxxx;TrustServerCertificate=True") .

相关问题