Geek Answers Handbook

Changing a default instance of a SQL Server instance

This question is about instances . I asked this before. Can I change the default instance to SQL Server without uninstalling and reinstalling? How can we do this, if possible? If this is not possible, then why? Thanks for the help:).

+4
source share
4 answers

No.

If you want to change the name of your instance or make it the default instance, you will have to reinstall. Nothing like this.

+2
source

All objects are specified, but by default only one is used. Remove the port from the default instance and set the port of the named instance to 1433 in SQL Server Config Manager in the SQL Server network configuration

+11
source

This may solve your problem: https://kohera.be/blog/sql-server/make-named-instance-look-like-default-instance/ (Full credit to Stefan, but I will rephrase below if his blog disappears)

The idea is for your named instance to appear as the default instance.

  • Open SQL Server Configuration Manager.
  • Go to: SQL Server Network Configuration → "Protocols for XYZ" treenode.
  • Right-click the TCP / IP entry in the right pane.
  • Select the "Properties" menu item.
  • Protocol tab, verify that Enabled is set to Yes.
  • On the IP Addresses tab, scroll down and enter 1433 in the IPAll-> TCP Dynamic Ports field.
  • Then restart the named instance.
  • Now you can connect to your named instance via:
    • (local)
    • local
    • . (<- this point)
    • 127.0.0.1
    • instance name name (e.g. mymachine \ myinstance)

enter image description here enter image description here enter image description here

+1
source

"If you want to access a named instance from any connection string without using the instance name and use only the server name, you can do the following:

To access a named instance with only the host name, go to SQL Server Configuration Manager and enable TCP / IP for this named instance, right-click and go to the properties, and on the IP tab, go to the IP All section and make TCP Dynamic Ports empty and make TCP port 1433 (which is the default)

This will cause the named instance to listen on the default port. Note. You can only have one instance configured: none of the two instances can have the same port in the IP All section, unless the instance is a failover cluster. "

See Zaza's answer. He explains with a screenshot how you can set which server is listening on the default port.

fooobar.com/questions/43210 / ...

0
source

More articles:


All Articles