Dynamics CRM 2011 Cannot go offline due to wrong local SQL name

  • Article

CRM 2011 Outlook Client - Go Offline

Result:

It is not possible to go offline.

The error was raised in CRM Client Trace:

“Exception occurred in dbInstaller.Install. Detaching and removing indeterminate database files. The network path was not found.”

ProcMon shows:

“BAD NETWORK PATH”

/C$/Users//AppData/Local/Microsoft/MSCRM/Data/MSCRM_MSDE.mdf">\\<UnknownMachineName>\C$\Users\<user>\AppData\Local\Microsoft\MSCRM\Data\MSCRM_MSDE.mdf

Cause:

SQL Local Name is not equivalent to machine name

Resolution:

1. Start the CRM SQL instance on the client machine.

a. Start | Run | Services.msc

b. Start SQL Server (CRM)

2. Start a command prompt in Administrative mode.

a. Start | All Programs | Accessories | Command Prompt | Right-click and select Run As Administrator

3. Type the following commands.

a. Log into the SQL instance:

sqlcmd –S .\crm –E

b. Check the current SQL Servername Property (You will hit enter after the command, type go, and then hit enter again).

select @@servername

go

c. The servername should come back in the format of machineName\CRM. If it does not match the current machine name, we will need to update it with the following commands.

sp_dropserver ‘oldName\CRM’

go

sp_addserver ‘currentMachineName\CRM’, local

go

d. Type Exit twice to exit from SQL command and to close the command prompt window.

e. Restart the machine and run the CRM configuration again

Best Regards

Dynamics CRM Team