July 9, 2012 at 2:53 pm
I did a stupid trick..... My server had to have a disk drive replaced which meant I needed to reinstall sql server. Well when doing so, I created my default instance with a name sql01\sql01, and I don't want that as my default instance, I want it to be what it was when I had a head on my shoulders, mssqlserver.
All my instance services are present as they were before the crash, but now I have this new stupid name for my default instance as well.......
How can I accomplish this?
July 10, 2012 at 1:47 am
if you want to rename a named instance, read the below link.
i havent tried it but got through google.
Regards
Durai Nagarajan
July 10, 2012 at 1:53 am
For clarity sql01\sql01 is a named instance, not a default instance.
You cannot rename a named instance, and similarly you cannot make a named instance the default instance, or change a default instance into a named instance.
If all you are interested in accomplishing is allowing users to connect to the instance using only the server name then you can change the port that instance sql01\sql01 listens on to 1433, the default port for SQL Server. If you do that then users will be able to access the instance as sql01, and even though it will be a named instance they'll be accessing it will have no effect on functionality or connectivity for users.
If you truly require there be a default instance on the server then you will need to install one, and optionally uninstall named instance sql01\sql01.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 10, 2012 at 5:58 am
opc.three (7/10/2012)
you can change the port that instance sql01\sql01 listens on to 1433, the default port for SQL Server. If you do that then users will be able to access the instance as sql01
I never knew that.
Thanks 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply