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 |
|
sybase08
Starting Member
3 Posts |
 Posted - 2008-10-23 : 14:42:39
|
| Hi everyone,I need to modify the "source data"->"connection string" in MP in a clusted machine but anytime I make any changes it goes back to what it was. from SQL Server Agent, right click on the plan and then edit->"source data"->"connection string"From Management node I don't get this option to change.can anyone help me on this please?I'm useing sqlserver 2005.Thanks for your comments! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-23 : 17:52:02
|
| I hope you have applied recent service packs to your SQL Server 2005 and client machine as well.1) Right click Maintenance plan-modify-manage connections -change connections and save and execute2)or Recreate same maintenance plan by dropping old one. |
 |
|
|
sybase08
Starting Member
3 Posts |
Posted - 2008-10-24 : 10:08:53
|
| Hi Sodeep,Thanks a lot for your response!This is a clustered env. I just tried to chnage the server_name (which the problem is) but it's not highlighed and doesn't let me to modify.I also created a new connection with the right server_name but can't delete the old connection. what could be the problem?on the first part of your comment, 1)By client machine, you mean the machine which the server is sitting on? I get connected to the machine through remote connection and after that it's Windows Authentication.2)how to check if the SP2 is installed on client machine? 3)how do you install SP2 on the client?Thanks a lot, |
|
|
|
sybase08
Starting Member
3 Posts |
Posted - 2008-10-28 : 08:59:05
|
| Any thoughts on this please? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 14:02:31
|
| http://www.sqlservercentral.com/Forums/Topic463441-357-1.aspx |
|
|
|
|
|
|
changing Maintenance Plan in a clustered env.