MDS Database and Web Application are using same user account which is Administrator on t
Adding More Info -
Authentication for web site: Windows Authentication is enabled, everything else is disabled.
Authentication for the server: Windows Authentication is enabled, everything else is disabled.
I am an admin on both the server and the SQL instance.
I am the only record in [mdm].[tblUser]
Any suggestions would be appreciated.
This issue is resolved with below steps which i found in one forum:
The root cause is, in the user active directory environment, there is a machine is using the same name as user. So the MDS is resolve the user to be SID of the machine. In the tblUser table, the name is showing as Domain\UserName$. The $ means it is a machine not a user account.
To workaround the issue, user need get the SID of the user and update the tblUser table, SID and UserName column.
It is a bug in the SQL Server and has been fixed in the SQL 2016.