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.
| Author |
Topic |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2008-07-17 : 19:37:40
|
| While installing sql server I gave the server instance name as: sqlexpress. Installing went fine but the server name looks like:SS-31D163E9F756\SQL2005. The code is appended infront. How can I change the sql server name to whatever name I want. sometimes I also see some servers are accessed using ip address. How would I be able to do that too.Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-17 : 20:18:57
|
| You can't get rid of SS-31D163E9F756 as that's the hostname (or virtual name on clusters) and is required for the name.But I'm confused. You said you installed it as sqlexpress, however you show it as sql2005. Could you check the services applet or SQL Server configuration manager for the instance name(s)?You could just create an alias in Config Manager so that you can refer to it as simple as SQL.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-07-17 : 20:34:33
|
| sorry my bad...I used "sql2005" as instance name. I created new alias using configuration manager. while doing that I left port number as blank. Is it ok? Leaving it as blank worked fine. Just curious where would it affect if I leave it blank.If I want to use an ip address for sql server name instead of specifying a name. can I give any ip number randomly or the ip address of my computer? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-17 : 20:41:07
|
| A random IP address will error. You shouldn't use IP addresses though. Just use aliases if you don't like your hostname.The port only matters if you get an error.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2008-07-17 : 20:41:48
|
| ok. thanks. |
|
|
|
|
|
|
changing sql server name