Viewing 15 posts - 31 through 45 (of 85 total)
Okay completed those tasks.
Restarted SQLAgent
Checked the job; and nope. Still the same (Unknown Security Error)
January 28, 2009 at 3:56 pm
noeld (1/28/2009)
Next step is to make sure SQL Agent has the permissions it need to impersonate the account.
Can you temporarily make SQL Agent Service account member of the local admins...
January 28, 2009 at 3:31 pm
noeld (1/28/2009)That means that the "Account Running the Job" Permissions are NOT right to run LogReader.exe.
To troubleshoot this:
1. Make sure you can log in the SQL Server instance using that...
January 28, 2009 at 2:36 pm
Hmm okay well I put those bits and peices into the job step and tried to start the job, but the "unknown security error" jumps up and the job doesn't...
January 28, 2009 at 1:23 pm
Hi,
Thanks for the response; one dumb question though ---> how do I get the log reader doing it's thing in verbose mode?
That whitepaper is about the only thing...
January 27, 2009 at 11:55 pm
Okay, so it looks like I have been sadly fooling myself in thinking that this LinkedServer might work with a windows account....it looks as though these only work with SQL...
November 30, 2008 at 7:21 pm
Interestingly I am in this exact same scenario; needing to reduce the initial size of the mdf file *sigh*
If anyone has any further feedback/ideas in this respect it would be...
August 18, 2008 at 3:21 pm
Righto; okay all sorted now. In the interests of keeping this post complete in case someone else has the same/similar problem I figured I should post my result 🙂
Anyhow my...
June 23, 2008 at 9:41 pm
Give me strength; now it is giving me the same error!!! *argh*
Anyhow have any ideas or seen this before?
June 23, 2008 at 6:19 pm
Hmm it would appear that this could have been caused by the destination database not being a restore of the source.
It was just a blank database; not specifically a...
June 23, 2008 at 4:57 pm
beauty thanks for the response!
(and sorry for the late reply on my behalf)
April 30, 2008 at 12:53 am
no one else has any comments on which factors to consider in order to drive some specifications for an OLAP server?
April 16, 2008 at 10:22 pm
I havn't had a chance to read any of their white papers on previous implementations; but will have a dredge.
Our current OLAP environment is on the same server as...
April 15, 2008 at 4:23 pm
Thanks for the response and the links! I had a look at them, plugged in the numbers and was amazed at how different the results were!
Hp rekoned we need a...
April 15, 2008 at 3:11 pm
This is great! Thanks for the thoughts, links and tips. I had just been cautioned about the impact of rebuilding the index as per my above posts; hence my hesitance....
March 26, 2008 at 1:39 pm
Viewing 15 posts - 31 through 45 (of 85 total)