SQL Server, convert a named instance to default instance?

by

I also wanted to convert a named instance to default – my reason was to access it with just the machine name from various applications.

If you want to access a named instance from any connection string without using the instance name, and using only the server name and/or IP address, then you can do the following:

  • Open SQL Server Configuration Manager
  • Click SQL Server Network Configuration
  • Click Protocols for INSTANCENAME you want to make available (i.e. SQLExpress)
  • Right-click TCP/IP and click Enabled
  • Right-click TCP/IP and go to Properties
    • Go to the IP Addresses tab
    • Scroll down to the IPAll section
    • Clear the field TCP Dynamic Ports (i.e. empty/blank)
    • Set TCP Port to 1433
    • Click Ok
  • Go to SQL Server Services
  • Right-click your SQL Server (INSTANCENAME) and click Restart

SQL Server Configuration Manager

This will make the named instance listen on the default port. Note : You can have only one instance configured like this – no two instances can have same port on the IP All section unless the instance is a failover cluster.

More Related Contents:

  1. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  2. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  3. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  4. Parameter Sniffing (or Spoofing) in SQL Server
  5. What are the main performance differences between varchar and nvarchar SQL Server data types?
  6. SQL Server String or binary data would be truncated
  7. Datatype for storing ip address in SQL Server
  8. How to change identity column values programmatically?
  9. best way to convert and validate a date string
  10. Why use the INCLUDE clause when creating an index?
  11. Why is it considered bad practice to use cursors in SQL Server?
  12. CAST and IsNumeric
  13. SQL Server pivot vs. multiple join
  14. SQL Query to find the last day of the month
  15. SQL Server GUID sort algorithm. Why?
  16. WHERE clause on SQL Server “Text” data type
  17. SQL Server error on update command – “A severe error occurred on the current command”
  18. Unable to begin a distributed transaction
  19. Parse XML in SQL Server
  20. SQL server schema and default schema
  21. SQL Server ON DELETE Trigger
  22. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  23. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  24. FOR XML PATH(”): Escaping “special” characters
  25. How to store directory / hierarchy / tree structure in the database?
  26. INFORMATION_SCHEMA vs sysobjects
  27. Why is casting from float to varchar being rounded in SQL Server?
  28. Does query plan optimizer works well with joined/filtered table-valued functions?
  29. What are row, page and table locks? And when they are acquired?
  30. Cross Domain SQL Server Logins Using Windows Authentication

Leave a Comment