June 14, 2011 at 7:02 am
I configured mirroring on windows 2008 and sql 2008.I have local administrator domain administrator as logins.My problem is I want to deny connections to windows logins but when i do that the SQL Server Agent stops and my jobs will not run and my mirroring stops.
The administrator password is shared,i do not like this.What happens if i changed the administrator passwords for local administrator and domain administrator.What is your advice?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
June 14, 2011 at 1:56 pm
kapfundestanley
I configured mirroring on windows 2008 and sql 2008.I have local administrator domain administrator as logins.My problem is I want to deny connections to windows logins but when i do that the SQL Server Agent stops and my jobs will not run and my mirroring stops.
The administrator password is shared,i do not like this.What happens if i changed the administrator passwords for local administrator and domain administrator.What is your advice?
What is the purpose of not using the domain account? if it for sql server then try and set up a sql server login account. http://msdn.microsoft.com/en-us/library/aa337562.aspx
Or give us a little more information as to what you're trying to accomplish by doing this?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply