November 5, 2003 at 5:25 am
When we installed SQL2000 with SQL7 already there we very creatively named in with computer\SQL2000. SQL7 was the default instance.
Later we removed SQL7 and have no default instance.
Lots of connections lots of places refer to computer\SQL2000, so I do not want to rename that (and I assume that requires a remove/reinstall, right?).
But is there any way to have it ALSO answer as the default instance, to someone who connects without the "\SQL2000" on the name?
November 5, 2003 at 6:44 am
Setup server alias in your client machine using client network utility.
November 5, 2003 at 10:22 am
Thanks, but to some extent client side changes sort of defeats the point, since what I'm trying to fix are all the people out there who might not know to put in the \SQL2000. If they know enough to not only remember it but to change their client side setup, I think they just know enough to use the right name.
November 7, 2003 at 3:38 pm
If you are using full SQL Server the setup program should allow you to install as the default instance. If you are using MSDE try setting the InstanceName in setup.ini to MSSQL.
Hope this helps.
Don
November 7, 2003 at 5:10 pm
Either I don't understand, or I am not being clear.
We have a computer named SRV-DW running an instance named \SQL2000.
I want to be able to connect to that server by using SRV-DW\SQL2000, and that is how it is set up and it works.
I would like to be able to also connect to it via SRV-DW (no instance name), and have it be exactly the same instance, same databases, same everything. The reason for this is all the people who remember the computer name and forget that there is an instance name after it.
I do not want to change names, since we have dozens of people and applications already using SRV-DW\SQL2000.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply