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

This article introduces the configuration of Sql Server2012 using IP address to log in to the server, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Recently, when using NFineBase framework + c # to do a system, I encountered several problems when using sql server 2012 to connect to the database.

one。

It is always an error to log in to the database by using ip address as the server name and SQL Server authentication (that is, entering the login name and password) when connecting to someone else's database locally or remotely.

For example, it will prompt for an error:

Login failed for user 'sa', who is not associated with a trusted SQL Server connection.

But you can log in using the computer name\ instance name.

\

Finally, it is found that there is still a problem with the configuration of the database. The solution is as follows:

I use the win10 system. The database is sql server 2012.

Move the mouse over the win button and click the left mouse button to find the installed sql server 2012 as shown in the following figure:

There is another problem here, that is, you cannot directly find the configuration tool folder of the sqlserver database here. For the win7 system, you can directly see a configuration tool folder with SQL SERVER configuration manager in it. In this case, you can find it directly under the startup folder of win10. Select SQL Server Data Tools and right-click under the open sqlserver 2012 folder. As shown in the following figure:

The location of the open file is shown in the following figure:

Or you can directly open the folder C:\ ProgramData\ Microsoft\ Windows\ Start Menu\ Programs\ Microsoft SQL Server 2012 and operate according to the structure of your own computer.

Then click configuration tool-> SQL Server configuration Manager, as shown below:

Click TCP/IP under the protocol of SQLEXPRESS, and click enable. Mine has been enabled here, as shown below:

Then click on the IP address

Enter your local ip address into IP3 my local IP address is 192.168.17.199 set the TCP dynamic port to empty, the TCP port to 1433 active and the enabled option to be

Then click apply OK and restart the SQLEXPRESS service, and then you can log in to the database using the IP address.

two。

When logging in to the database using the IP address as the server name, the user 'sa' login failed. Errors such as the user is not associated with a trusted SQL Server connection, that is, an error occurs when using the IP address as the server name to log in to the database with a login name and password.

Solution:

Log in with windows authentication and then set the

Select your connection instance and right-click the properties, as shown in the following figure:

Then click Security-- > sa--- > status under the connection instance, as shown in the following figure:

Finally, it is found that for each connection, such as:

This is a connection, and for each connection, the above permissions need to be set to ensure that the server name is IP address locally or remotely, and the database is logged in with login name and password.

If you change to another connection or user, you need to reconfigure it, and when you log in with a custom user, remember to set the connection configuration information for that user.

About the configuration of Sql Server2012 using IP address to log in to the server is shared here, I hope 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.