Hi All,

I am trying to export contact list of a lync enabled user and having issues to do so. I have checked the RTC DB permission and all seems to be ok.Have ckecked the SQL server ports which are working fine.  I am using domain admin account which is a member of csadministrator group and also member of RTCUniversalServeradmin  group which has the "Connect" permission to RTC database 

C:\Program Files\Common Files\Microsoft Lync Server 2010\Support>dbimpexp.exe /user:lyncuser1@testdomain.com /sqlserver:"sqlsrv01.testdomain.com\rtc" /hrxmlfile:lyncuser1.xml"
Error: Failed to connect to SQL Server with a connection string: [Data Source ="sqlsrv01.testdomain.com\rtc"; Database = rtc; Integrated Security = true; Pooling= true; Max Pool Size = 3; Connect Timeout = 45; Connection Reset = false; Enlist = false]

Environment: Lync server 2010 (pool configuration)
SQL server 2008 SP1

Any help will be appreciated.

Regards,

Imrul

Did you try to replace rtc with the SQL instance name instead?

Hi Desmond,

Thanks for the reply. Yes, tried with SQL instance "default". Same error.

Regards,

Imrul

Remove /rtc from command, Try to using following command

dbimpexp.exe /user:<sip address> /sqlserver:<SQL Server FQDNinstance name> /hrxmlfile:<path that you want to write the xml file to>

Also you can refer below link

http://www.justin-morris.net/exporting-and-importing-contact-lists-in-lync-server-201

Hi Mai Ali,

Tried that one before but no  success.

C:\Users\lyncuser1>cd "C:\Program Files\Common Files\Microsoft Lync Server 2010\Support"

C:\Program Files\Common Files\Microsoft Lync Server 2010\Support>dbimpexp.exe /user:lyncuser1@testdomain.com /sqlserver:"sqlsrv01.testdomain.com" /hrxmlfile:C:\lyncuser1.xml"
Error: Failed to connect to SQL Server with a connection string: [Data Source = sqlsrv01.testdomain.com; Database = rtc; Integrated Security = true; Pooling = true; Max Pool Size = 3; Connect Timeout =
 45; Connection Reset = false; Enlist = false]

C:\Program Files\Common Files\Microsoft Lync Server 2010\Support>

Regards,

Imrul

Please use sqlserver:sqlsrv01.testdomain.com\rtc instead of sqlserver:"sqlsrv01.testdomain.com\rtc".

Hi Lisa,

No success. same error.

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

Regards,

Imrul