Post reply

Remote connection to server from Surface Area tool

  • September 12, 2006 at 2:19 pm

    #113571

    Hi,

     I have SQL 2005 ,Sp1 Ent edition installation and when I try to connect it from my local workstation using surface are tool, I'm getting below error message:

    "Computer LAB00TST02 does not exist on the network, or the computer cannot be configured remotely.

    Verify that the remote computer has the required Windows Management Instrumentation components and try again."

     

    I have sysadmin right on the database server and server is enabled for remore connections.I can connect to the server using Management studio but don't know why not vis Surface Area Tool.

    Any help?

    Thanks

  • September 13, 2006 at 7:20 am

    #660083

    Start the SQL Server Browser service on the database server.

  • September 13, 2006 at 8:39 am

    #660110

    Thanks..I tried that too but no success.Got the same error message.

    -Jp

  • September 13, 2006 at 2:16 pm

    #660239

    When you click Read More in the Surface Area Configuration Tool it shows a page on the tool that refers to this Books Online Article. I wonder if it helps:

    SQL Server 2005 Books Online 
    How to: Configure WMI to Show Server Status in SQL Server Tools 

    When connecting to servers, both the Registered Servers and Object Explorer components of SQL Server Management Studio, as well as SQL Server Configuration Manager, use Windows Management Instrumentation (WMI) to obtain the status of the SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER) services. To display the status of the service, the user must have rights to remotely access the WMI object. The server must have WMI installed to configure this permission.

    <script type=text/Javascript>var ExpCollDivStr=ExpCollDivStr;ExpCollDivStr = ExpCollDivStr + "ctl00_LibFrame_ctl025e191b6,";var ExpCollImgStr = ExpCollImgStr; ExpCollImgStr = ExpCollImgStr + "ctl00_LibFrame_ctl02img,";</script>To configure WMI permission

    1. On the Start menu on the remote server, click Run.

    2. In the Open box type wmimgmt.msc, and then click OK.

    3. In the Windows Management Infrastructure program, right-click WMI Control (Local), and then click Properties.

    4. In the WMI Control (Local) Properties dialog box, on the Security tab, expand Root, and then click CIMV2.

    5. Click Security to open the Security for ROOT\CIMV2 dialog box.

    6. Add a group or user to the Group or user names box and select it.

    7. In the Permissions for <group or user> box, select the Allow column, for the Remote Enable permission, for users whom you wish to remotely detect the service status.

    Regards,Yelena Varsha

  • September 13, 2006 at 2:34 pm

    #660242

    Additionally:

    I was able to use Change Computer link in the Surface Area Configuration Tool to connect to SQL Server 2005 from my workstation.

    I was getting the same error message when I tried to connect to SQL Server 2000 from the Surface Area Configuration Tool  for 2005.

    If you are the server admin and you follow steps in the above article you will see that Administrators are already given WMI remote access permissions.

    See if your SQL SErver 2005 was installed as an instance and if you should use the instance name.

    Regards,Yelena Varsha

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply