Run the following query to find out if the connections to SQL server are using NTLM or Kerberos:
Articles Tagged: SQL
SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]
Error 1 Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] Error 2 SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010] To work […]
Get the extensive status of all databases on MS SQL server
Setup: Microsoft SQL server installed Problem: You need a list of databases and all their important properties. Solution: Source: Internet
Add BUILTIN\Administrators group in SQL and add sysadmin role
Setup: SQL 2008, SQL 2008 R2 or SQL 2012 fresh install Problem: After default installation of SQL, the BUILTIN\Administrators group is not granted any permissions on SQL Solution: Open the SQL Management Studio and run the following commands: