Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use IP to access yourself through SQL Server Authentication on other people's machines. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Use IP on someone else's machine to access your own through SQL Server Authentication

The company needs to use sa on someone else's machine to access my database, but there are a lot of problems, what 233, 18456, etc., very painful, but finally solved, here are the general steps. (take sa as an example)

Log in via Windows Authentication using "." or "computer name" or "IP". Do not log in with ("." or "computer name" or "IP")\ SQLEXPRESS. SQLEXRESS is a free version of Microsoft.

After logging in, find Security > Logins, find the sa user, and change the password; select status,Permission to connect to database engine:Grant;Login: Enabled.

Object Explorer right-click property, select Security, and confirm that SQL Server and Windows Authentication mode is selected.

Open SQL Server Configuration Manager (SQL Server configuration Manager) and select the protocol of SQL Server network configuration > MSSQLSERVER (the protocol of SQLEXPRESS corresponds to the free version of SQL)

Enable both Named Pipes and Tcp/IP (if you are using the via protocol, enable the corresponding protocol).

How to open SQL Server Configuration Manager: start > all programs > Microsoft SQL Server 2008 > configuration tools > SQL Server Configuration Manager

At this point you need to restart the service, in SQL Server Configration Manager, select SQL Server service, select SQLSERVER (MSSQLSERVER) right-click to restart.

As a server, the SQL Server Browser service is generally turned on.

You can log in below, by the way, don't forget to turn off the firewall.

On how to use IP on other people's machines to access their own through SQL Server Authentication to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.