Within the local area network (LAN), how to establish a connection to other database server-CodePudding

Within the local area network (LAN), how to establish a connection to other server database, I remember is set up under the server object - link to the server, if you can, please screenshot inform specific Settings, thank you very much!

CodePudding user response:

What kind of links to other database?

CodePudding user response:

The

reference 1/f, February 16 response:

what kind of links to other database?

is SQL, use IP address to connect

CodePudding user response:

The

reference 1/f, February 16 response:

what kind of links to other database?

I want to achieve in my native through the SELECT * from 192... Query database, dbo. This way

CodePudding user response:

Connected to the LAN/wan other database instance
Conventional set inside the IP
User name password security inside the last category Settings
The database name specified in the script

CodePudding user response:

In the server object - link to the server, right click the new...
If it is other is essentially, service type, I'd choose SQL sever other database, choose the corresponding data source,
Safety in the left column, fill out the for the user password on the server (if not simulation, generally choose the last item)

CodePudding user response:

Post address: https://www.cnblogs.com/gered/p/9223569.html
See [3] in my blog, changing linkservername also to IP, the diagram below:

Then you can use this form: you said the select * from 192.168 [...] Database. [] [dbo]. [table name]

CodePudding user response:

 data between different server database operations 

Create links - server 
The exec sp_addlinkedserver 'ITSV', ' 'and' SQLOLEDB ', 'remote server name or IP address' 
Exec sp_addlinkedsrvlogin 'ITSV', 'false', null, 'user name' and 'password' 

- query example 
Select * from ITSV. Database name. The dbo. Table name

CodePudding user response:

The most convenient link server:
https://blog.csdn.net/yenange/article/details/9456145