Issue in Integration in MS SQL Server 2005-Suggest?

[DeepanshuSood1]

Hi,

I tried to integrate mssql 2005 with rsa sa but facing the issues related to the certificate creation. while logging in the sql 2005 the user is having the administrator privileges and the folder in which *.dll file is placed also having everyone can access privileges. But still at the time of running the query getting the error, attaching the screen shots for your reference.

  

Please suggest if someone can suggest a workaround about the same. TIA.

Regards,

Deepanshu Sood.

[DavidWaugh1]

Hi I would try logging in with the Database sa account and trying then steps there. It sounds like a permissions issue.

[DavidPoirier]

Hi,

How did the first steps work for you?

Note: The CLR is disabled by default in SQL Server

2005 and later. You must enable CLR on a server-wide

basis. You only need to enable CLR once for each

server.

EXEC sp_configure 'show advanced options' ,

'1';

go

reconfigure;

go

EXEC sp_configure 'clr enabled' , '1'

go

reconfigure;

go

d. Click Execute

[DavidPoirier]

To install the audit procedures:

1. The following steps are only for Microsoft SQL Server 2005 and later. If you

are using Microsoft SQL Server 2000, proceed to step 2:

a. Create a directory C:\MyDBApp, and place the RSA_

MSSQLAuditStoredProcedures.dll file inside.

b. Launch the SQL Server Management Studio.

c. To enable the Common Language Runtime (CLR), click New

Query, and type: