HomeTroubleshooting@RISK for Excel: LibraryLibrary Can't Find Any Servers on My Computer

7.1. Library Can't Find Any Servers on My Computer

Applies to: @RISK for Excel 5.x–7.x

I try the Connect or Create button in @RISK Library, but it can't find any servers except my own machine.

It may be a firewall or permissions issues. Please follow this procedure to check that possibility:

  1. Click Start » Programs » Microsoft SQL Server 2005 » SQL Server Management Studio Express. (If it's not there, please visit http://www.microsoft.com/downloads/en/default.aspx and enter

    management studio express

    in the search window. You want Microsoft SQL Server Management Studio Express, which should be the first hit. Download and install it, then run it.)

  2. The server name should be pre-populated with the local server. Click the down arrow and select Browse for more.

  3. In the Browse for Servers dialog, select the Network Servers tab. You will see "Retrieving", then eventually "Database Engine". Click the + sign to expand it, and you should see all the networked machines.

If you do see the networked machines, please let us know and we will assist you. If you don't see the networked machines, this is an issue in your local network and you should get your IT department to establish the necessary permissions and adjust the firewall if appropriate.

Last edited: 2015-10-15

This page was: Helpful | Not Helpful