Do you know how to make remote connection in database?
Submitted by: AdministratorThe following is the process to make a remote connection in database:
Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database.
Click on Surface Area Configuration for Services and Connections.
Click on SQLEXPRESS/Database Engine/RemoteConnections
Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only' under Local and Remote Connections.
Click on OK button / Apply button
Submitted by: Administrator
Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database.
Click on Surface Area Configuration for Services and Connections.
Click on SQLEXPRESS/Database Engine/RemoteConnections
Select the radio button: Local and Remote Connections and select ‘Using TCP/IP only' under Local and Remote Connections.
Click on OK button / Apply button
Submitted by: Administrator
Read Online SQL Database Concepts Job Interview Questions And Answers
Top SQL Database Concepts Questions
| ☺ | Explain what are Magic tables in SQL Server? |
| ☺ | Do you know how to send email from database? |
| ☺ | How to search for a string in all stored procedure in SQL Server? |
| ☺ | Explain how to use Linked Server? |
| ☺ | Explain difference between cross join and Full outer join? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
