May 31, 2007 at 10:50 am
I want to create a sqlserver 2005 multiple instance test environment. After installing the default instance, I tried installing 2nd instance, gave this a name. I would like to specify:
1. The port number also, but there is no way I can define the port number. I remember installing multiple sqlserver 2000, I could put in a port number.
2. Installation path, I do not want this in c:\\Program files\.....
Where can I change this.
Thanks,
June 1, 2007 at 3:55 am
To answer your questions:
1. By default a named instance uses dynamic ports. If you still want to use a fixed port you have to set it after installation in SQL Server Configuration Manager.
2. You can change the path during installation by selecting advanced option on the page there you select the features you want to install. But be aware that some program files will still be placed under C:\Program Files\..
Markus
[font="Verdana"]Markus Bohse[/font]
June 1, 2007 at 3:57 am
You have to specify the port number after installation completes, using SAC or other tools.
You can change the file location on the Feature screen. Highlight a component and click Browse.
Every major component of SQL Server 2005 is automatically placed in a new set of folders. The folder name includes a portion MSSQL.n, where is a number that increments by 1 for each major component. The installer keeps track of this in the registry, so even if you specify a different install location for each instance, you will still get a new value of MSSQL.n for each of them.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply