Post reply

Can''t Connect when using (local) Server

  • December 5, 2005 at 2:37 pm

    #67664

    Using Windows 2003 on a test server that has SQL 2000 SP-3 and 2005 installed. When I try to make a connection to the (local) server in a a 2000 DTS package I get DBNETLib ConnectionOpen (Connect()).]SQL SErver does not exist or access denied message. If I change the server to the actual name it works. How come this is happening?

  • December 6, 2005 at 9:28 am

    #607974

    Found my own solution, SQL Server 2005 had been installed as the default (local) instance so I had to change my connection to point to the fully named instance for SQL 2000.

Viewing 2 posts - 1 through 1 (of 1 total)

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