I received a SQL Server 2005 database backup (say Sales database) and after restoring it I found that it has "sys" and "sysadmin" as database users defined in it.
Now, that Application I received tries to connect to Sales database using "sysadmin" and it fails.
I tried to create a Login with the same name, it failed by saying "Server-principal 'sysadmin' already exists", so joining User and Login didn't happen.
I expanded the database tree and opened the properties of "sys" user it doesn't show me its link with sys login though sys login exists in my SQL server.
I will appreciate your assistance to resolve this issue at the earliest.