Manage instances in another machine

Hot Topic

Using Transfer SQL Server Objects Task
i have installed sql server but not appeared in vb.net !!!
Relative date ---'Rolling 3 months' --help please
Exporting report to text files
Report Model Generating Out of Memory Error
hide my report toolbar
I need help with a SQL Query
Can't get Reporting Services working after reinstall
XML Performance Comparison - Why is OPENXML faster?
Upgrade MSDE1.0 SP4 To SQL 2005 Express Ed.

SQL Server

Lots of data/Performance Question
How to release large unused/allocated space
About the location of database file.
how to select the newest records for each project ?
Indexed view help needed
Inserting Values to Identity column.
Manipulating a text box in custom code.
Installing SQL Server 2005 Standard, Note: 1: 1708, Installation failed.
creating a SP that add columns into a table
filter detail section of matrix report

Manage instances in another machine

I'm trying to manage another SQL Server 2005 instance in another machine. I'm doing this by connecting to another computer thru Computer Management. When I go the SQL Server 2005 Services, the right pane is showing There are no items to show in this view. How can I view the services

Another problem that I have is that I have to turn off the Windows Firewall in the other machine. What exceptions are needed I have tried by adding the specific TCP used by the instance.

Answer this question

Manage instances in another machine

  • TA123

    Jens is right, you have to enable SQL Server remote access from the console of the server. Here's a couple relevant pages explaining how to enable remote access to SQL Server:

    http://support.microsoft.com/default.aspx scid=kb%3bEN-US%3b914277

    http://www.aspcode.net/articles/l_en-US/t_default/Databases/SQL-Server/SQL-Server-2005-Express---remote-connection_article_123.aspx

    Once you have remote access enabled, you can manage your server using SQL Server Management Studio from other machines.

    Hope this helps,
    Steve



  • Dan Cleveland

    As far as I know the Computer management console can only adminsiter the local instances fpr Sql Server 2005.


    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • jkushiner

    If you login is a part of local administrator group on that server then using Computer Management console can do the job as it relies on the user privileges, as explained above for the SQL Configuration manager you can only manage local instances.

  • The Buffer

    Hi Steven,

     I'm following this MS article: http://msdn2.microsoft.com/en-US/library/ms190622.aspx

     I can connect to the SQL Server Configuration Manager of the remote computer thru Computer Management.  I can enable and disable protocols under both SQL Server 2005 Network Configuration and SQL Native Client Configuration.  However, SQL Server 2005 Services will only show "There are no items to show in this view".  It does not make sense to me since I can control the services thru Services but not thru SQL Server 2005 Services under SQL Server Configuration Manager.

    I have disabled Windows Firewall and SQL Browser service is running.

     

    Peter

     

     

     

     

     
  • Manage instances in another machine
Answer this question