Monday, September 9, 2013

[MS SQL Server] SQL Agent job log in to Windows as?

[MS SQL Server] SQL Agent job log in to Windows as?

SQL Agent job log in to Windows as?

Posted: 09 Sep 2013 01:20 AM PDT

So my employer has an application which scans the Windows event logs for things to alert on. They're working on setting this up to alert when admins log in during off-hours. Well, this weekend it triggered on my log in...I suspect it's an Agent job I have scheduled to run on Sundays @ 1:00am (the time agrees with their report,) but I want to confirm that what I'm thinking is correct.The job has my account as the owner of the accout. When this job fires, is that the account that will be used by Windows? I'm suspecting it is, but I'd like to confirm that.Thanks,Jason

Adding a Node to a cluster SQL Server 2008 R2

Posted: 08 Sep 2013 10:08 PM PDT

Hi All,Just looking for a bit of clarification on the steps i need to take to add a node to a 2-node sql server 2008 cluster.2-node cluster with three instances (instance1 , instance2 & instance3) installedThe steps i was considering are :1. Infrastructure team build new server and add the new node to the failover cluster at a windows level.2. Run the Add node to the failover cluster option and select instance13. Apply Service Pack 2 to instance14. Check instance1 can failover to the new node5. Repeat steps 2,3 & 4 for instance2 and instance3Does that seem like a o.k plan ?Many thanks
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog