|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Renaming A ServerI have created a Database Instance. However the Server Instance is now
called RMUK7\RMUK7. I would ideally like this Server Registration \ Instance to be called RMUK7. Is there any way of renaming this as it could prove problematic with our installed Apps. Thanks in advance Mark You cannot rename an instance. You can install a new instance with desired name and move over the
data. Or you can specify a client alias (specify version and where client app is executed for details). -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "MarkS" <Ma***@discussions.microsoft.com> wrote in message news:A2D7F5E7-20D6-4416-A070-D90E7A76BC98@microsoft.com... >I have created a Database Instance. However the Server Instance is now > called RMUK7\RMUK7. I would ideally like this Server Registration \ Instance > to be called RMUK7. Is there any way of renaming this as it could prove > problematic with our installed Apps. > > Thanks in advance > Mark Hi
"MarkS" wrote: It sounds like you are wanting to install a default instance on the server? > I have created a Database Instance. However the Server Instance is now > called RMUK7\RMUK7. I would ideally like this Server Registration \ Instance > to be called RMUK7. Is there any way of renaming this as it could prove > problematic with our installed Apps. > > Thanks in advance > Mark Does a defauilt instance exist? This will have the same name as the server or (local) or . If you are using SQL Express you can only install a named instance! John
RE: Problem - Accounting Professional Database on SQL Server
How to Diagnose IO Performance On A SAN TOP 10 problem on inner join Login failed for user DTS package version deletion sp_spaceused - need help interpreting SQL server 2005 standart load, but view odbc sql version 2000, why ? Facing problem storing Japanese chars in SQL Server 2000 Ent edn Online Backup Database Mirroring |
|||||||||||||||||||||||