I have created a Windows login for user on SQL server. He had read, write access to a database. All of a sudden he is unable to open the tables in his database. He can expand the structures but cannot open tables in Management Studio. Also he can query tables in a database I asked him to try to different...

is microsoft script usefu lfor windows login transfers too when i move database from one machine to another, as the window SID's on the new machine would be different, and i have huge number of windows logins in my database.

I'm considering changing a .NET application from using SQL Authentication to Windows Authentication. I have thought about using Application Role but decided not to use it since the application I'm changing is using multiple SQL databases and Application Role is limited to one database. I want...

IN order to avoid such mishaps you should practice to create the logins between the servers where the primary & secondary server relation is established, I do agree with Tom in this case to go that way. A database user for which the corresponding SQL Server login is undefined or is incorrectly defined...