Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Instance Rename

Author  Topic 

kappa02
Yak Posting Veteran

65 Posts

Posted - 2008-11-04 : 15:21:39
I have an instance name testserver\test1, when I had created the instance I had name it "test1" but the system give it this full name
"testserver\test1". Is it because I already have a default instance of SQL 2005? And Can I rename testserver\test1 to just "test1"?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-11-04 : 15:24:18
The instance is named test1. Your hostname is testserver. The full server/instance name is testserver\test1.

If you want to refer to it as test1 only, then you'll need to setup an alias for that in SQL Server Configuration Manager.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -