Error Creating Credential - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Error Creating Credential

Author

Topic

rmobley
Starting Member

2 Posts

Posted - 2007-04-03 : 12:43:53

We upgraded from SQL Server 2000 to 2005 recently. I'm attempting to create a credential for the first time and I keep getting the error shown below. Can anyone tell me what to do to resolve it? Thank You

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for Credential 'schjob'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Credential&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An error occurred during decryption. (Microsoft SQL Server, Error: 15466)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15466&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

rm

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2007-04-03 : 14:08:57

when you say a credential, you mean a login, right?

Regards
Paresh Motiwala
Boston, USA

rmobley
Starting Member

2 Posts

Posted - 2007-04-03 : 14:25:53

I'm attempting to create a credential (Security - Credential) to be used by a proxy account that will be used to run a SSIS job via SQL Server Agent. The SSIS job will need to access a file outside SQL Server and I understand you have to setup a proxy to do that. Thanks

rm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources