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
1条答案
按热度按时间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")
.