June 5, 2013 at 4:27 am
Hi
Today I've done my 2nd attempt to use dbWarden, unfortunatelly it gives following errors upon execution:
7 x EXECUTION ERRORS @ 5/June/2013:
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 197
The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).
DATA DICTIONARY: 13 tables & 146 fields added
My 1st attempt back in April was also unsucessfull but I understand it because the T-SQL did not support SQL Server 2012.
My platform details:
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Any idea abot the root-cause about above error ?
Cheers,
--
Paulo Nascimento
June 7, 2013 at 5:02 pm
Hello,
The SQL Agent Jobs are created under the login of "sa". You will need to change that if you do not use the "sa" account. Perform a Find/Replace for "@owner_login_name=N'sa'" and enter a valid login for your environment.
Regards,
Michael
June 7, 2013 at 5:20 pm
Thanks Michael, that was it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply