Dbimpexp.exe with Lync Enterprise Pool - Default SQL Instance caveat

  • Article

Dbimpexp.exe is an invaluable tool for backing up and restoring user data.  However, when running the command to target the default SQL server instance, specifying \Default as seen in the Lync Topology will result in an error. 

Here's an example that will fail:

C:\Program Files\Common Files\Microsoft Lync Server 2010\Support>DBImpExp.exe /user:first.last@domain.com /sqlserver:"lyncsqlsrv.domain.local\Default" /hrxmlfile:"C:\Temp\export.xml"

This will result in the following error:

Error: Failed to connect to SQL Server with a connection string: [Data Source =lyncsqlsrv.domain.local\Default; Database = rtc; Integrated Security = true; Pooling = true; Max Pool Size = 3; Connect Timeout = 45; Connection Reset = false; Enlist = false]

Here's the simple solution, remove \Default from the command:

C:\Program Files\Common Files\Microsoft Lync Server 2010\Support>DBImpExp.exe /user:first.last@domain.com /sqlserver:"lyncsqlsrv.domain.local" /hrxmlfile:"C:\Temp\export.xml"