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
Change Notifcation service error with Windows Authentication
Re: Change Notifcation service error with Windows Authentication
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:
Code: Select all
SELECT name, default_schema_name FROM sys.database_principals
Code: Select all
ALTER USER [Domain_Name\User_Name] WITH DEFAULT_SCHEMA = dbo;
Re: Change Notifcation service error with Windows Authentication
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
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
Re: Change Notifcation service error with Windows Authentication
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.
Feel free to contact us if you have any further questions about our products.