How do you connect to SQL server instance and disconnect from SQL server instance?

Experience Level: Junior
Tags: DatabasesQuality Assurance (QA)

Answer

There are two types of SQL server instances.

  • Default instance
  • Named instance

For connecting to Default instance, you specify only the server name. Example: SERVERNAME

For connecting to Named instance, you specify server name and instance name. Example: SERVERNAME\MYINSTANCE

Related Databases job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
MS SQL Server for Testers
MS SQL Server for Testers

Are you learning Databases ? Try our test we designed to help you progress faster.

Test yourself