How to make remote connection in database - Sql server

Explain how to make remote connection in database

The following is the process to make a remote connection in database:

1. Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database.
2. Click on Surface Area Configuration for Services and Connections.
3. Click on SQLEXPRESS/Database Engine/RemoteConnections
4. Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only’ under Local and Remote Connections.
5. Click on OK button / Apply button
Difference between cross join and Full outer join - Sql server
Cross join and Full outer join - Cross Join : No join conditions are specified. Full Outer Join: A combination of both left and right outer joins.........
Purposes of OPENXML clause sql server stored procedure - Sql server
OPENXML clause - OPENXML parses the XML data in SQL Server in an efficient manner. It’s primary ability is to insert XML data to the RDB.........
What is the order in which the SQL query is executed? - Sql server
The following is the order of executing SQL query: The query goes to the shared pool that has information like parse tree and execution plan for the corresponding statement.......
Post your comment