Lync 2010 Best Practices Analyzer “Cannot open database “xds”

Posted: August 21, 2015 in Systems Administration

I wanted to Check my Lync Server 2010 and I opened the Microsoft Lync Server 2010 Best Practices Analyzer.


  1.  I connect to the Active Directory Server


2.  I select “Start a new Best Practices Scan”

3.   I press on “Start Scanning”

after a couple of minutes I get:

“Error: An error occurred: “Microsoft.Rtc.Common.Data.SqlConnectionException” “Cannot open database “xds” request by… The login failed.”

First thing that comes to mind permissions!, but my user is a member of the CSAdministrators group and the local server administrator. Which takes me to SQL permissions.

  1. Open SQL Server Management Studios
  2. Connect to the your MS Lync Server SQL Server [I checked both RTC and RTC local instances]
  3. on Management Studio locate Security and then Login
  4. Create a new login with your user
  5. Add the appropriate role to the new login [in my case I selected sysadmin role]
  6. Closed the SQL Server Management studio
Now I open the Microsoft Lync Server 2010 Best Practices Analyzer, connect to Active Directory Service, Start a new Best Practices Scan, Start scanning and we are good to go:
If in any case you run to the same error again after performing these steps, just close the Lync 2010 BPA and “Run As Administrator”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s