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

Posted: August 21, 2015 in Systems Administration
Tags:

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

Lync2010BPA

  1.  I connect to the Active Directory Server

Lync2010BPA1

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:
Lync2010BPA2
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”
Enjoy!
Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s