Subscription management page not opening in Remote Database Server Deployment model

Question

Hi All,

We have used SQL NS Remote Database Server Deployment model and has three different servers for each DB, Notification WinService and Subscription Management page. However, Notification WinService working fine but Subscription Management page (ASP.NET) throwing exception as below:

[NSException: Notification Services failed to get the metadata for the specified instance.
Instance Name: NSInstance
SqlServerError:
  Source: .Net SqlClient Data Provider
  Number: 18452
  State: 1
  Class: 14
  Server: DBSERVER\DB
  Message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
  Procedure:
}

We have registered NS instance on Subscription Management machine as well as on Notification WinService machine also.

Please help

Regards,
Bharat

Answer 1

Hi,

From the description, it seems that your account cannot login to the SQLServer.

I'm not sure how you configure your database connection settings in your ASP.NET. Try to check if you are using SQL authentication or Windows Authentication. (From the error message you provided, I even can't see the login name.)

Please configure your login account and don't forget to enable Mix mode if you are using SQL accounts.

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.