|
|
|
SSC Eights!
 
Group: General Forum Members
Last Login: Monday, October 12, 2009 9:18 AM
Points: 976,
Visits: 33
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, November 12, 2009 5:03 AM
Points: 3,
Visits: 9
|
|
How about authentication issue?
I had tried Multiserver adm. in mixed mode authentication, it was worked, but in win authentication it wasn't work and i saw my security authentication change from win mode to mixed mode.
After I restart SQl Service, it was work.
Any Comment?
TIA
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Monday, October 12, 2009 9:18 AM
Points: 976,
Visits: 33
|
|
It never occured to me to test for Windows only authentication. I've always used mixed authentication mode with the SQL Servers I've managed. I'll have to look into this the first chance I get. Unless someone else has experience with multi server administration and Windows authentication only.
Robert Marda
Robert W. Marda
SQL Programmer
Ipreo
|
|
|
|
|
Keeper of the Duck
Group: Moderators
Last Login: Yesterday @ 8:53 AM
Points: 6,266,
Visits: 1,358
|
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Monday, October 12, 2009 9:18 AM
Points: 976,
Visits: 33
|
|
Thanks Brian!
Robert Marda
Robert W. Marda
SQL Programmer
Ipreo
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Yesterday @ 5:04 PM
Points: 203,
Visits: 226
|
|
Hi All
What's the stability on the multi server setup, I'm think of making one of my cluster instances as a master and letting all other 2005 servers being slaves. For now that's 6 slaves, but in the future that will probably grow to 15-25.
Has anyone got experience with a setup of such size and even bigger ones? What's the performance impact for the master server, CPU, msdb and network wise?
Any best practice guidelines out there for setting this up?
Thanks in advance for any hints.
//SUN
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, March 10, 2010 6:29 AM
Points: 8,
Visits: 39
|
|
Hi,
I'm having some difficulty with a multi-server maintenance plan. I was able to get multi-server admin configured and the resultant job propogated to the other servers, but when I Execute the plan, it only runs locally. I tried starting the multi-server Job for the plan and it looks like it attempted to run the target server jobs, but they failed with:
Could not load package "Maintenance Plans\Nightly Index Maintenance" because of error 0xC001000A. Description: The specified package could not be loaded from the SQL Server database.
What's going on?
Konrad Willmert
Indiana Wesleyan University
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, February 10, 2010 3:21 AM
Points: 134,
Visits: 319
|
|
Hi,
I am experiencing the same problem right now. I configured multiserver environment and all worked out. The job was propagated and available both on master and target server. However, when I run the job it runs only locally. When I run it from the target server, I am getting the same problem you are getting.
I was really wondering if you could share your experience if you solved the problem.
I appreciate your comments.
Regards
Niyala
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, March 10, 2010 6:29 AM
Points: 8,
Visits: 39
|
|
| Sorry, no. We gave up on it. Regular multi-server jobs using T-SQL propagate just fine, so we'll probably be using those to perform maintenance.
|
|
|
|
