If it is a database directly in the same LAN, it will automatically search for the SQLServer database in the local area network, so if it is in different LAN, you need to pass the IP to access the steps as follows: 1, click Start - - Program - Microsoft SQL Server - Client Network Utility - Diven - Click Add --- Network Library Select TCP / IP; Server Alias: Database Server IP; Server Name: The IP of the Database Server; Port Default 1433 (What is the distant port!) - Determine
2, click Start - Program - Microsoft SQL Server - Enterprise Manager - Mouse Point Microsoft SQL Servers - Mouse Right-click SQL Server Group; Point New SQL Server Registration .... - Next - Add Host IP, the next --- "Select" System administrator to assign me SQL Server Login Information .... ". . . . . .
