locked
Cannot connect the SQL Server using Management Studio RRS feed

  • Question

  • I have build one new SQL Server for our development environment under sub domain (Created a subdomain in the primary domain forest).

    Configuration:
    Operating system: Windows 2008 R2 SP2
    SQL Server version: SQL Server 2008 Enterprize (NOT R2)
    Server Environment: VM Ware

    The installation was success and can create large databases as well. I can able to login the SQL Server through RDC (Remote desktop Connection) using both Windows Authentication and/Or SQL server user

    Problem:
    Though I can able to login using RDP. I CANNOT connect the serve from other PCc using SQL Server management studio. I tried giving all the combination of Database engine names, but no luck. I can able to ping or browse the server, but problem is in the SQL Server CONNECTION

    Please shed some light on this. What kind of settings I should check? Your help is highly appreciated

    Thanks,
    Raj


    Dreaming a world without any war in anywhere
    Thursday, June 16, 2011 4:01 PM

Answers

  • thanks for the help

    I fixed the problem. The firewall is the one was giving the problem and fixed that now

     

    Thanks


    Dreaming a world without any war in anywhere
    • Marked as answer by Rajeeshun Friday, June 17, 2011 6:14 PM
    Thursday, June 16, 2011 5:45 PM

All replies

  • Hello,

    Please configure Windows Firewall or disable it on Windows Server 2008.

    http://msdn.microsoft.com/en-us/library/ms175043(v=SQL.100).aspx

    Start SQL Server Browser Service if you installed a named instance. If you installed a default instance, are you able to get connected to the instance using the telnet command:

    telnet servername 1433

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Chirag Shah Thursday, June 16, 2011 6:21 PM
    Thursday, June 16, 2011 4:11 PM
  • thanks for the help

    I fixed the problem. The firewall is the one was giving the problem and fixed that now

     

    Thanks


    Dreaming a world without any war in anywhere
    • Marked as answer by Rajeeshun Friday, June 17, 2011 6:14 PM
    Thursday, June 16, 2011 5:45 PM