/build/static/layout/Breadcrumb_cap_w.png

MS SQL Question

Hey All,

I need some help.  I have a 2 servers one called IRdata and cone called IRapp.  The IRData has MS SQL 2008 r2 installed on it.  With a database called IR5.

IRapp has the MS SQL 2008 R2 Management studio installed on it.

I can not seem to get the IRapp Management studio to see the IR5 database.  they can see each on on the network, the can ping  each other just fine.

Being this is the first Time I am setting up an SQL server i need some help.

What am i missing?

Thanks

Sam


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Trinity 12 years ago
Brown Belt
1

Enable Named Pipes Client Protocols on the IRdata server in the SQL Server Configuration Manager.


Comments:
  • yes it is enabled. - spless 12 years ago
  • After enabling Named Pipes restart the SQL Server. Management Studio should now be able to connect to your database server. Lastly, what is the error you are getting when trying to connect to your SQL server using the Management Studio - Trinity 12 years ago
Posted by: adilrathore 12 years ago
4th Degree Black Belt
0

Is TCP/1433 database port open on IRapp.

You can check this by telnetting to 1433 port from IRData.

telnet IRapp 1433

Before running the telnet command check if the telnet client is enabled on IRData.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ