Post reply

connection

  • December 4, 2007 at 10:17 am

    #127219

    Hi all

    Can anyone please tell me whether we can connect to sql server 2005 express from sql server 2000 enterprise.

    Thanks in Advance

    Ratheesh.K.Nair

  • December 4, 2007 at 10:23 am

    #757053

    You should be able to as long as you have the client drivers installed.

  • December 4, 2007 at 10:28 am

    #757057

    am having sql server 2000 enterprise when i tried to connect to sql server 2005 express its showing access denied..

  • December 4, 2007 at 10:35 am

    #757062

    How are you trying to make the connection? And have you tried using VBScript to confirm you are able to connect to 2k5 Express?

  • December 4, 2007 at 10:37 am

    #757064

    am using sql server 2000 enterprise and am trying to connect to a remote sql server 2005 express server....am getting the error "the server doesnt exists or access denied"..

  • December 4, 2007 at 11:06 am

    #757084

    I may just be misunderstanding you, do you mean SQL 2000 Enterprise Manager? If so then no you cannot connect.

    If you mean you are running a query using OPENROWSET or OPENQUERY then again you need to write a small vbscript app to verify you can make a connection outside of SQL Server.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply