Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Questions/comments about eventcreate, SQL auth account, ect. Expand / Collapse
Posted Friday, October 17, 2008 1:44 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 1, 2015 9:12 AM
Points: 55, Visits: 236
First, let me thank you profusely for the nice article that set my thinking wheels in motion. Great job on that solution!
I have a few questions to clerify why this works the way it does:

1. You're using eventcreate.exe in both SQL2000Blocking.vbs and SQL2005Blocking.vbs. My SQL 2000 is running on Win2K, and instead of eventcreate it has logevent utility. Do your Win2K boxes have eventcreate.exe?

2. Not sure why you're using sql auth to write to AnalysisDb on both SQL 2000 and SQL 2005?
I read that "Again, to avoid giving Local System elevated rights on the SQL instances, access to the central repository database in the vbs scripts had to be done through SQL authentication." But I didn't see DBCC inputbuffer () or fn_get_sql in the stored procedure. Am I missing something?

I think that NT AUTHORITY\SYSTEM account should have write access anyway, so you'd be ok there.

Thanks in advance
Post #587959
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse