Default instance of SQL Server uses port # 1433. In other words each SQL Server service is a different process which is attached to a unique port number. Key concept: Each instance of Microsoft SQL Server service installed on a machine uses a different port to listen for incoming SQL connection requests. I had followed this configuration on my server when I faced this issue. SQL Server setup does not mandates the installation of default instance if you wish to. Combination of two or more named instances only i.e.Combination of default instance and one or more named instances.When you have two or more than two SQL Server instances running on the same box then there are two possible configurations: So, if you have more than one instance of SQL Server service running on a given machine then this problem can occur. To understand the naming convention of SQL Server service instances, please refer to the corollary section in the end of the answer. Text in parenthesis (MSSQLSERVER) is the name of the service instance. I have only one service instance and it is the default service instance of SQL Server:įor each new instance that you setup via SQL Server installer, there will be a new row in this service console window with same SQL Server prefix in the Name column. Have a look at my machine (Refer screenshot). To differentiate between multiple instances on the same machine, you must give a unique name to each service instance. unavailability of more physical servers in your estate, isolating SQL Server instance failures, load balancing, etc. There can be variety of reasons due to which you may want to run multiple SQL Server service instances on the same box e.g. Why it asks for it? The reason is that the SQL Server setup provides a facility through which you can install and run multiple instances of SQL Server service on the same machine. Whenever we run SQL Server setup on a machine then it asks us to input the name of the service instance. Force the SQL Server service to use static port # 1433 to get it working.ĭetailed Explanation: Before starting with the details, let us first understand the scenario in which this issue can occur. TL DR: Your SQL Server instance is using dynamic ports due to which it is not working.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |