MSSQL+CRM2011 FUD: The instance name must be the same as computer name

while installing MS CRM 2011 or 2013 you get this stupid message and all activtiy grinds to a halt:

"The instance name must be the same as computer name"

it happened because you took a virtual machine template and cloned it, and renamed it, and then started to use it immediately without any consideration of the SQL server within.

You have to rename the MSSQL server.

use these commands one by one: in the master database

to query the binds 
SELECT @@Servername

to drop the invalid name 
Sp_dropserver 'OLD_SERVERNAME'

to add the correct machine name 
Sp_addserver 'ACTUAL_MACHINE_NAME',local 

These command are case sensitive, so be careful.  Finally, restart the MSSQL services, and close and reopen the MSSQL studio.
This KB tidbit applies to MSSQL 2008 R2 Enterprise, Windows Server 2008, MS CRM 2011



Comments

Post a Comment

Popular posts from this blog

Microsoft Visio 2010 Premium Product Keys

Image
Visio KMS client key from Microsoft You can use these with AutoKMS tool such as Office Toolkit 2.4.9 (office 2010/2013) which will re-arm them once every 180 days. So you are always in the grace period.  At the bottom of this page are keys for Visio 2019.  If you are here to figure out how to get a free copy of Visio activated on your computer, without paying Microsoft for it, then God or Allah will judge you later for your sins. Your soul will be sent to the underworld to be tormented by Satan for these sins. Please pay for your software! Visio Standard 2010 767HD-QGMWX-8QTDB-9G3R2-KHFGJ Visio Professional 2010 7MCW8-VRQVK-G677T-PDJCM-Q8TCP Visio Premium 2010 D9DWC-HPYVV-JGF4P-BTWQB-WX8BJ Keys from our Russian friends. you can only install with these keys, you cannot activate. ========================================================================= Visio Premium 2010: ========================================================================= C383V-HPHMC-Y6KWM-B
Read more

Mercedes Benz Diesel CDI EGR Emulator Circuit Diagrams

Image
Mercedes EGR Emulator Circuits for Electric Wahler EGR on Diesel Engine For any car fitted with a MAF you can't just block the  EGR valve  as the MAF detects the reduced airflow when the valve operates. If it fails to report this reduction the ECU throws a code, turns on the MIL light and engages Limp Home mode. The  EGR valve  is operated in varying degrees whenever the engine is in cruise mode. A circuit has to be designed that reduces the MAF output voltage whenever the  EGR valve  is called to actuate. Having seen a mod on another forum I decided to give it a go and installed it last night. The circuit is really simple. The  EGR valve  transducer is fed with constant 12v which is proportionately shunted to Gnd to create the potential to activate the transducer, to engage the EGR solenoid and allow hot gasses into the intage via the  EGR valve  in varying degrees. The MAF is in the cold air intake. the EGR gasses enter further downstream. the MAF then monitors the red
Read more

Fix: The Diagnostic Service Host service failed to start due to the following error. [ solved, no kidding ]

Image
Lots of these Messages about the Diagnostic Service Host in the System Log On Windows 7/10 Machines Attached to A Domain The Diagnostic Service Host service failed to start due to the following error: A privilege that the service requires to function properly does not exist in the service account configuration. You may use the Services Microsoft Management Console (MMC) snap-in (services.msc) and the Local Security Settings MMC snap-in (secpol.msc) to view the service configuration and the account configuration.  The good news is that you can fix it using active directory group policy or the Local Security Policy and just adding a few things to the Local Policies.  Same fix applies to both Windows 7 and Windows 10.  To Fix this using any Policy, you must be running a Professional or Enterprise version of Windows. If you have Home Edition, sorry. Here's How to Fix It You see this in your system logs repeatedly, and its dragging down your computer and making it run slow. 
Read more