Configure sql server without instance

Asked

Viewed 1,265 times

0

Use SQL Management Studio to execute queries and the installation has been configured to use with INSTANCE.

How do I remove this instance from the configuration or use a pattern? The instance I have configured is SQLEXPRESS.

sql-server

1 answer

2


This does not exist. SQL Server works with instances, at all times.

To connect to the database without having to use the instance name, you can define an instance to fulfill the requests directly in the machine’s IP.

  1. Open the SQL Server Configuration Manager

  2. Expand the node SQL Server Network Settings

  3. Click on Protocols for [instance name] (SQL Express, in this case)

  4. In the right pane, click TCP/IP and activate it.

  5. Then open up Estates and enter the tab IP addresses

  6. Go to the section IP AII

  7. Define TCP portal as the port that SQL Server is using (default 1433)

  8. Make sure the field Dynamic TCP ports is blank

  9. Restart SQL Server.

Now the instance SQL Express SQL Server will fulfill requests made to your machine’s IP, even if the instance name is not specified.

Then, it will be possible to connect using only localhost, 127.0.0.1, . or Nomecomputer.

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.