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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-04-06 : 13:24:09
|
| Hi,We have migrated our databass to new server during disaster recovery (cluster to standalone). Now we have different physical server name so our instances (default and named) will change. We have many applications connecting to these databases/server. One option is on application side connection string should be changed to point to new servers. I am thinking about server alias. So If I setup server alias on server level, then I just want to make sure that all applications will connect to this server with old name. So there will be no need to change connection string on application side.Please let me know how this work. I want to save time.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-04-06 : 13:45:49
|
| Thanks Tara for reply.So it is DBA job to create DNS alias on application side or Application group should do this? whoe is responsible? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-04-06 : 13:56:12
|
| Thanks Tara for your prompt reply, really appreciate your help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Server Alias