March 18, 2018 at 11:08 pm
Dear Forum,
I installed SQL Server 2012 first and then SQL Server 2017.
The SQL Server 2017 install is thus referenced and named as per ASUS_NOTEBOOK\MSSQLSERVER01
and the SQL Server 2012 is named ASUS_NOTEBOOK
It seems that the SSIS install does not like / allow instance names ..
I am thus seeking to rename ASUS_NOTEBOOK\MSSQLSERVER01 so that it does not have the \ in the name.
ie, without instance ..
maybe it is possible to have alias names ?
I guess I could uninstall both SQL Server 2012 and SQL Server 2017 and start again with just SQL Server 2017 ..
Any suggested steps on renaming this would be much appreciated !
kind regards
Allan.
March 19, 2018 at 6:14 am
allan.ford17 - Sunday, March 18, 2018 11:08 PMDear Forum,
I installed SQL Server 2012 first and then SQL Server 2017.
The SQL Server 2017 install is thus referenced and named as per ASUS_NOTEBOOK\MSSQLSERVER01
and the SQL Server 2012 is named ASUS_NOTEBOOK
It seems that the SSIS install does not like / allow instance names ..
I am thus seeking to rename ASUS_NOTEBOOK\MSSQLSERVER01 so that it does not have the \ in the name.
ie, without instance ..
maybe it is possible to have alias names ?
I guess I could uninstall both SQL Server 2012 and SQL Server 2017 and start again with just SQL Server 2017 ..
Any suggested steps on renaming this would be much appreciated !
kind regards
Allan.
You could try an alias but it sounds like altering the config file might be what you are looking for.
If you are trying to manage packages on the named instance, you would want to the config file to point to the named instance. There is an example of this in the Integration Services documentation - check the Example of a Modified Configuration File for a Named Instance of SQL Server section in the following:
Integration Services Service (SSIS Service)
Sue
March 19, 2018 at 6:49 am
One can usually get around this by using Square brackets.
eg [ASUS_NOTEBOOK\MSSQLSERVER01]
March 22, 2018 at 10:19 am
After having one default instance every SQL installation after that will be a named instance which will have a ' \ ' in the instance name. As suggested by Ken McKelvey above you use the square brackets.
Changing the system name can change only one part of the instance name but if instance name needs to be changed, you need to run the installer.
March 22, 2018 at 10:29 am
AFAIK, you cannot convert the named instance to a default instance. You'd have to install as a default instance.
March 27, 2018 at 5:40 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply