help me Sql Panditulu Ila Randi...i Need Help Resolving This

[sunnygm]

C:\Program Files\Microsoft System Center 2012 R2\Operations Manager\Server\Health Service State\Monitoring Host Temporary Files 1557\91345\JobStatus.vbs(1223, 2) Microsoft SQL Server Native Client 11.0: Invalid authorization specification

 

ippudu problem enti ante--

 

source ( scom 2012) has a job script which has stored proc details.& connection string details.  Job script get the connection details from the source SQL server database table and it connects to destination SQL Server database executing the sp. I am getting the error in red above looks like it is generic error.

 

Source SQL server:

 

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

 

Destination SQL server:

 

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
 

[Vankay]

i can solve it..

[mtkr]

anything changed?? any upgrades??

[Vankay]

sry i cant..query help ankuna..

[sunnygm]

anything changed?? any upgrades??

 

No upgrades...Just installed SCOM 2012 and SQL Server. Some of the custom management packs are moved from SCOM 2005 environment. No issues from them because job script is running fine and trying to connect the SOL server.
 

[mtkr]

No upgrades...Just installed SCOM 2012 and SQL Server. Some of the custom management packs are moved from SCOM 2005 environment. No issues from them because job script is running fine and trying to connect the SOL server.
 

 

 

nt sure bayya... just putting my guesses n waiting for some1 to throw some light...

 

 

05 nundi 12 ki moved antunav gaa... anni compatible e naa!!

n aa SP lo protection levels em aina unnayaa?

 

like mana SSIS packages lo protection levels laagaa!!!

[Pichkaari]

ltt

[pachimirchi]

database access issue anukunta.. 

[SBAG]

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4537aedb-a98f-4a4f-8d51-27ce77866b8c/microsoft-sql-server-native-client-100-invalid-authorization-specification?forum=sqldatabaseengine

 

Can you check this?looks like this DB authentication error.

[riashli]

Ltt

[sigsegv]

ento emi ardham kaavatam ledhu 

[sunnygm]

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4537aedb-a98f-4a4f-8d51-27ce77866b8c/microsoft-sql-server-native-client-100-invalid-authorization-specification?forum=sqldatabaseengine

 

Can you check this?looks like this DB authentication error.

 

All of this done..not resolved yet.