Solved

Manage a SQL Server 2008 DB from anothe machine ?

Posted on 2011-03-17
2
179 Views
Last Modified: 2012-05-11
Hello gurus,

I have a Server that has SQL 2008 R1 (windows 2008 R2).
there is a database there and it is an ERP.

From my Station I can run the ERP Application so I have no connectivity issues with the server.
Now I would like to manage the SQL DB from my station.
How do I do that ?
I installed the SQL Management studio and tried to connect to the server DB...but it doesn't
detect it !!

Any step I am missing ?
Thanks
0
Comment
Question by:ammounpierre
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35162968
>but it doesn't detect it !!
it might not detect it (automatically), but you should be able to configure a (new) sql registration to the instance.
please refer to this article to start troubleshooting:
http://www.experts-exchange.com/A_1881.html
0
 
LVL 11

Expert Comment

by:louisreeves
ID: 35162976
YOu have to know how the instance connects. Does it used named pipes? What port, What  protocol? THe database may be propriatary so you may need to ask the vendor for connection specifics. (or list them here) :-)
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question