2008 R2 Management Studio

Discussion in 'Databases' started by albanello, Jul 8, 2011.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. albanello

    albanello

    Hi

    Can I connect using my local computer using SQL Server 2008 R2 Management Studio to my DASP SQL Server 2000 ?

    I am in the process of upgrading locally my Application and SQL Server but have NOT made the switch yet at DASP. I would like to do some testing locally before upgrading at DASP.

    Albanello
     
    albanello, Jul 8, 2011
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Yes. You should be able to connect using any SQL client as long as your network allows the necessary ports.
     
    Bruce, Jul 8, 2011
    #2
  3. albanello

    albanello

    bruce

    When you say "SQL Client" what does that mean ? Is that another why of saying SQL Management Studio or does Client refer to the Application connection? I am trying to test a SQL Buisiness Intelligent Development package, I have written to download some tables from DASP to my local computer.

    Thanks for your responce
    albanello
     
    albanello, Jul 8, 2011
    #3
  4. Michael Ossou

    Michael Ossou

    Yes. SQL Client could mean SQL Management Studio 2008, 2005, 2000, or your application.
     
    Michael Ossou, Jul 8, 2011
    #4
  5. albanello

    albanello

    Thanks

    I will have to try it from home to see if my connection will work. Doing it from work could be the problem, they could be blocking my connection. I am doing the "Test Connection" button in the Connection Manager........Not sure where the problem is.

    albanello
     
    albanello, Jul 8, 2011
    #5
  6. Bruce

    Bruce DiscountASP.NET Staff

    Your network probably block port 1433.

    You can connect over the alternative port of 14330 as well.

    Check w/ you network admin to see if either of these ports are opened.
     
    Bruce, Jul 8, 2011
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page