Twitter

Thursday, January 17, 2013

Cannot open database "xds" requested by the login. The login failed.Login failed for user

When something went wrong during any Lync Installation, e.g. Topology was published with Errors and you tried to install a Lync Server, e.g. SBS, STD Edt, ...

You might see the following Error:
Cannot open database "xds" requested by the login.
The login failed.Login failed for user DOMAIN\ADMINUSER


If this is happened,

you fully need to uninstall:

1.) All Lync Server Components, beside:
- Administrative Tools, Core Components, Resources Kit (if ist installed)

2.) The entire local SQL Instance, including Client Tools !
- Ensure, also the local Folder: C:\Program Files\Microsoft SQL Server\MSSQL10.RTCLOCAL is entirely deleted!


3.) Restart your Server now.

If you are now going to reinstall Lync Server,

4.) make sure the Registry Key is clean:
Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
PendingFileRenameOperations


NOTE:
should the Lync Server Replica Replicator Agent should not have been proper uninstalled.
You Need to uninstall all Lync components including the exemptions listed above.
(RegKey: Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Service\REPLICA)
The Replica Replicator Service is part from Lync Core Components!


and delete the following Folder:
C:\Program Files\Microsoft Lync Server
C:\Program Files\Common Files\Microsoft Lync Server 2010



Here you go and the Server can be reinstalled...!

6 comments:

  1. Thanks for explanation, it is pretty much simple.

    ReplyDelete
  2. Thanks, we had to do this today. Lync 2013 FE Enterprise install with SQL 2008 R2 latest SP back end. Hope Microsoft will look into these repeated failures -- lots of people finding the same issue it seems.

    ReplyDelete
  3. I am getting same error on edge server, edge is domain joined. Any help on that?

    ReplyDelete
    Replies
    1. Hi Ahmad,
      you have several issues.
      1. Edge MUST NOT a domain joined computer.

      So you need fully uninstall EDGE with all Lync components!
      Than reinstall after you disjoined the computer.
      make sure you fully follow the recommendations for Edge server.

      Delete
  4. Hi,
    I came across the same situation when installing Skype for Business 2015 and I believe I fixed it more easily - I think reinstall is not necessary.

    Have a look at the SQL management studio and the SQL's data directory.You will possibly not see the xds DB in the management stufio, but find a xds.mdf in the SQL's data directory. For some reason it got detached in my case, preventing the Skype4B installer to create a new one (but still presenting me the message above).

    The existing mdf file can be re-attached easily, or possibly also removed together with the ldf file to fix this issue.

    ReplyDelete
    Replies
    1. Hi Stefan,

      thank you for posting this. Would you mind dropping me a contact request through this blog, so I can contact you. I'm very interested in this case !!
      Just also would like report this to the PG for Skype for Business.
      Tnx

      Delete