Configure sql server without instance

Question

Navigation

#1 by (2 votes)

0

I use SQL Management Studio to run queries and the installation has been configured to use with INSTANCE.

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

sql-server

asked by anonymous 03.08.2017 / 16:24

1 answer

score 2 · Accepted Answer

This does not exist. SQL Server works with instances, always .

To connect to the database without having to use the instance name, you can define an instance to respond directly to requests on the machine's IP.

Open the SQL Server configuration manager

Expand the SQL Server Network Settings

Click Protocols for [instance name] (SQL Express in this case)

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

Then open Properties and enter the IP Address tab

Go to the IP AII

Set TCP Portal as the port that SQL Server is using (default 1433)

Make sure the Dynamic TCP Ports field is blank

Restart SQL Server.

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

Then you can connect using only localhost , 127.0.0.1 , . or p>