Access issue

  • I added a group  called "Access" and provided access to the group on some of  the databases in primary replica which are in always on  , when user is tring to connect to the  primary server  he is getting

    Login failed for user 'Domain\Access'. Reason: Attempting to use an NT account name with SQL Server Authentication.

    When i checked login is enabled  and mode is mixed mode  and  authentiocation is windows

    How to slove the issue

  • It depends on what application they use to connect but you generally get that error if they have selected or use SQL Server Authentication and pass in their Windows login and password.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply