ms sql server 2012; sp_addrolemember crashes

[UdoLehmann]

Executing statement

exec sp_addrolemember 'db_ddladmin', 'DBG_USER_RW'

with TUniQuery crashes with

Die Metadaten konnten nicht bestimmt werden, weil die EXEC %%Owner(Name = @membername).Lock(Exclusive = 1) -- may fail

-- ATTEMPT ADDING IMPLICIT-Anweisung in der sp_addrolemember-Prozedur keine Metadatenermittlung unterstützt.

Error Code: 11528

Environment:

Windows Server 2008 R2 Standard SP1 64 Bit
Server: MS SQL-Server 2012 Express SP 2 64bit (Microsoft SQL Server 11.00.5058)

OS Client: Windows 7 Version 6.1 Service Pack 1 Build 7601 Platform: 2
UniDAC 5.3.8, 5.3.9

On other client os it works.

Any recommendations?

[azyk]

To solve the problem, try using SQL Native Client provider. For this, in connection settings set the option TUniConnection.SpecificOptions.Values['OLEDBProvider'] to 'prNativeClient'.

[UdoLehmann]

I have set the option. Although SQL Native Client is installed I get the message
"Required provider is not installed"
How UniDAC checks the provider?

[azyk]

The "Required provider is not installed" error occurs when SQL Server Native Client provider is not installed on the computer where UniDAC is used. To avoid the error, install SQL Server Native Client provider.