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 |
|
wardsan
Starting Member
48 Posts |
 Posted - 2011-08-29 : 04:16:41
|
| Folks,is it possible to access a default instance on sql server 2005 installation by that host's dns alias? For example, if I have a sql sql server headsql007s and its dns alias is dbshprd02, is it possible to refer to that default instance as dbshprd02 rather than headsql007s?TIASandra |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-08-29 : 05:40:13
|
| Yes , that shouldn't be a problem. You're talking about the server reference .Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
|
|
|
Referring to sql server default instance by alias