Xpert Knowledge Database

Articles Tagged: SQL

List the SQL connection authentication method. NTLM vs Kerberos

Run the following query to find out if the connections to SQL server are using NTLM or Kerberos:

Read More →

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 […]

Read More →

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

Read More →

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:

Read More →

Categories

  • Scripting 8
  • Security 2
  • System Administration 42

Latest Articles

  • How to clear the CCM Cache
  • Setting Moodle to work over SSL
  • Copy file permissions with PowerShell
  • SCCM – System discovery of an untrusted forest fails with 0x8007052E

Popular Articles

  • How to clear the CCM Cache
  • IBM IMM (Integrated Management Module) Defult Username and Password
  • Query HP server Storage Array details remotely via WMI and WBEM
  • Compute a hash from a string in PowerShell

Tags

.NET Active Directory ActiveRoles ADFS CCM Certificate Cluster Firewall Firmware HP HTTPS Hyper-V IBM IIS IMM LastLogon LDAP Linux Moodle MSSQL MySQL Password PowerShell RaidController root SAN SCCM SCVMM Secure string Sharepoint Sharepoint Search SQL SSL Storage Array sysadmin System Center System Center Configuration Manager System information Trust provider User Profile Service Application Virtual Machine Manager WBEM WCF WMI

Archives

  • December 2014
  • November 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
© Copyright 2016 - XpertKB.com