SQL Server Upgradation is done in 2 ways Attended Installation/Upgrade Un Attended Installation/Upgrade (Silent Installation) Attended Installation/Upgrade is a basic method of installation . in which we interact with the GUI Screens in SQL Server Un Attended Installation/Upgrade (Silent Installation) is which sql server is upgraded from the command Prompt.
Every one knows that by default any version of SQL Server Uses 1433. how to check the port used by SQL Server. 1: execute use master go xp_readerrorlog 0,1,N’Server is listening on’,’any’,NULL,NULL,N’asc’ in the management studio Option 2 OPtion 3 run this query in the SQL Server Management Studio select distinct local_net_address, local_tcp_port from sys.dm_exec_connections […]
SQL Server Configuration Manager:Cannot connect to WMI Provider-Invalid class[0x80041010] This error occurs then .mof(Managed Object Format) dont get installed and registered correctlly. To resolve this error we have to re-register the *.mof files command mofcomp.exe “C:Program Files (x86)Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof”