Devart Forums

Hi there

I want to change my application to use Windows Authentication in our server environment but when the ChangeNotification component attempts to create the service I am getting the error "The default schema does not exist. Code: (2797)"

I have traced it to this statement using SQL Server Profiler

IF NOT EXISTS (SELECT * FROM sys.service_queues WHERE name = 'SDAC_NS_53_QUEUE') CREATE QUEUE SDAC_NS_53_QUEUE
IF NOT EXISTS (SELECT * FROM sys.services WHERE name = 'SDAC_NS_53') CREATE SERVICE SDAC_NS_53 ON QUEUE SDAC_NS_53_QUEUE([http://schemas.microsoft.com/SQL/Notifi ... tification])

Can you please advise what SQL Server security settings I need to permit for the change notification service to be loaded?

Thanks
Bryn

Please check which default schema is set for the user. For this, execute the following SQL expression:
If the schema is not specified for the user, or schema is incorrect, please try modifying the default schema for the user. For example:

Thanks for your reply.

I have done a lot of investigation and learning over the last few days. I discovered the fact that somehow the owner of the default schema had changed, have put it right now and all appears ok.

I really appreciate your assistance. These are awesome components and I thoroughly enjoy working with them!!!

Thanks and kind regards

Bryn

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.