[DBNETLIB][ConnectionOpen

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi

I was wondering if anybody has seen this problem come on there system.

We are running Windows 2003 R2 64 bit with SQL 2005 64.

Remote SQL server cannot be accessed on the client machine when trying to
use the Import and Export wizard. The database engine is accessible though.
These are the steps I follow:



1.. Connect to the SQL server 2005 Database engine using SQL server
Management Studio
2.. Expand the Database folder and right click on the database
3.. Select Import Data under All Tasks
4.. Select Source
5.. Select Destination (this the sever in question) , click next, it gives
the following error:


TITLE: SQL Server Import and Export Wizard

------------------------------



The operation could not be completed.



------------------------------

ADDITIONAL INFORMATION:



[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. (Microsoft OLE DB Provider for SQL Server)



using Windows Authentication for both connecting to Database Engine as well
as Import Export Wizard.




.

Relevant Pages

  • Re: How to Connect to SQL Server 2005 enterprise version
    ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... > that the client computer will have SQL Server 2005 component installed. ... >> Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... that the client computer will have SQL Server 2005 component installed. ... > Welcome to the Getting Started with the Database Engine tutorial. ... see Running Setup to Install AdventureWorks Sample Databases ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem connectin SQL Server 2005
    ... Have you configured the SQL Server 2005 to allow remote connections? ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Configuring a Fixed Port ...
    (microsoft.public.sqlserver.connect)