I am srikaanth. In my office we have 20 systems working on sql server & .net applications.
Till now the user was having administrator rights as the systems were just workgroup.
Now i have connected all systems to windows server 2008 r2 domain controller.
Made users login with only rights not with administrator rights but sql server database could not be connected which they were connecting when login as administrator rights. give me a solution in this.
If you have joined all machines and user to a domain, then all users get's new Windowas accounts (with new SID's). So you have to add all the new accounts to SQL Server security as login and you have to grant access permissions for all users to the used