Problems connecting to Microsoft SSAS 2008
February 24, 2010 – 4:47 pmOne of our workstations at the office developed issues connecting to Microsoft SQL Server Analysis Services 2008 on one specific server. No users on the workstation could connect to AS on one server, though they could connect to other AS servers. The same users could connect to the server from a different workstation. The issue appeared to be specifically between one workstation and one server. The client was Windows 7, and the server Windows 2003.
When connecting with SQL Server Management Studio, an error would pop up almost immediately stating “An existing connection was forcibly closed by the remote host.” If we tried connecting through Excel 2007’s external data wizard, we got the error “The following system error occurred: The security database on the server does not have a computer account for this workstation trust relationship.”
After a good deal of searching, I finally found a suggestion for a solution at the following link:
About 2/3 of the way down the page, user hesmith posts a comment with the solution. He suggests three different options, all of which should work, from what I’ve read. However, the one I tried was option 2, which suggested uninstalling the Windows Live Sign-in Assistant (if it’s installed, it will be listed under Programs and Features). Uninstalling it and rebooting the computer resolved the problem immediately, and connecting to Analysis Services once again worked.