January 24, 2005 at 6:19 pm
Hello,
I have a secondary server that a friend of mine is lending me (FRET05). The current SQL Server 2000 setup on FRET05 reflects the server-name and a sub-directory?(something I am unfamiliar with):
'FRET05\JAN'
Whenever I refer to this server in my code, I have to specify this sub-directory. I would like to change the SQL Server setup to reflect just the server name:
'FRET05'
Can I do this without having to uninstall/reinstall MSSQL Server 2000?
Any help is greatly appreciated...
-Matt
January 24, 2005 at 8:08 pm
The name "FRET05\JAN" is a name instance of SQL Server. You cannot change this without re-installing.
However, you might be able to create an alias for this using the "Client Network Utility". The catch with this is you would need to do this on each and every client PC that is connecting to that server which may be a problem.
January 25, 2005 at 4:23 am
Hi,
You do have to reinstall but there is a nicer way of doing that. Read about rebuildm.exe in BOL.
BTW there isn't any othet SQL installed there, right?
Check if the defult name isn't used already.
yoav.
January 25, 2005 at 9:58 am
Hey gang,
Thank you very much for getting back to me on this. This is indeed the only instance of SQL Server running on there (default name not used).
I figured I'd probably have to re-install, but wanted to check with you guys first. Thank you very much for the suggestions.
I think having a better defined named instance is probably more of a standard anyway.
Thanks again,
-Matt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply