Tag Info

New answers tagged


You can use the following to list orphaned sql users: USE foo go EXEC sp_change_users_login 'Report'; and USE foo go EXEC sp_change_users_login 'update_one', 'foouser', 'foouser'; to fix each one.


You can review this MSSQLTip to get more information on what active/active and active/passive mean in regards to SQL Server Clusters: SQL Server Clustering Active vs Passive In your situation, and based on your comments, the only thing you need to do is configure the dependencies for your resources. So if I have a cluster resource for the the SQL Server ...


Please note that I'm refraining from offering licensing advice due to recent discussion indicating that this probably isn't wise. Based on your comments, you have the following groups defined within Cluster Administrator: Cluster Group File Server Group SQL Group Your "Cluster Group" probably includes a "Cluster IP Address", "Cluster Name", and ...

Top 50 recent answers are included