Viewing 15 posts - 106 through 120 (of 2,647 total)
So... I set this up and now I keep getting an error on the step:
Executed as user: new_user. The server principal "new_user"
is not able to access the database "userdatabase1" under...
September 26, 2013 at 12:18 pm
Ha! Thanks! I missed that parameter.
Things to note:
1. The user has to be explicitly added as a user to master (or whatever database the step is executing under), even if...
September 25, 2013 at 12:43 pm
Jack Corbett (9/25/2013)
You can specifiy the user the job step should run as, http://technet.microsoft.com/en-us/library/ms187358(v=sql.105).aspx
I thought that this can only be a proxy, which has to be a Windows...
September 25, 2013 at 9:39 am
Thanks Gail and Jeffrey. I'm more interested now in the article by Jonathan. Good stuff Gail!
August 13, 2013 at 2:43 pm
Well... First off, if won't let you failover from active before upgrade, so the msdn doc is wrong there... Working on upgrading active instance1 now.
August 2, 2013 at 7:45 pm
At this point, I have often used:
IF (SELECT DATEPART(HOUR,GETDATE())) BETWEEN 5 AND 17
BEGIN
EXEC database.dbo.storedProcedure
END
July 19, 2013 at 9:18 am
Worth trying man.. Thanks. Anyone else? MVPs? Doesn't it seem strange that you upgrade and can't use the other instance? There has to be a way around... Just as I've...
July 9, 2013 at 3:06 pm
I know this is an old discussion, but it came up when I was googling the interwebs for info on this.
1. You need to understand DNS.
2. You need to...
July 9, 2013 at 2:33 pm
Looks like this question would be much better for a .NET forum. Ultimately, it is not a SQL question, but a windows service question.
June 28, 2013 at 10:45 am
Perry Whittle (6/13/2013)
SQLKnowItAll (6/12/2013)
And what if the reason for this is to upgrade OS
Highly unlikely don't know of many shops that upgrade to datacenter from enterprise
SQLKnowItAll (6/12/2013)
or SQL?
you don't...
June 13, 2013 at 8:22 am
Perry Whittle (6/12/2013)
hydbadrose (6/11/2013)
I have to rebuild the clusters so the plan is i have to move the sql databases to a new temporary server and rebuild...
June 12, 2013 at 7:27 am
Are you reinstalling the OS? Formatting/switching drives? Do you already have a cluster? If so, why are you rebuilding it? I don't mean to be rude, but without a full...
June 11, 2013 at 5:22 pm
What exactly are you rebuilding? Just the cluster, or both servers and then the cluster?
June 11, 2013 at 1:07 pm
I suggest placing your statement in the form of a question with a lot more information 🙂
June 11, 2013 at 11:39 am
Viewing 15 posts - 106 through 120 (of 2,647 total)