DTS Import/Export Wizard in Microsoft SQL Server 2000 displays error

Asked By June R Boyd 50 points N/A Posted on - 05/26/2014

Hello,

While working with DTS Import/Export to copy data from one the data source I ended up with an error message. When I select the Microsoft OLE DB Provider for SQL server, I got this error message pop up. I stuck here not able to move forward from this step. Please guide me. Thanks a lot.

 

DTS Import/Export Wizard Error

Error Source: Microsoft OLE DB Provider for SQL Server.

Error Description: [DBNETLTB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Context: Error during initialization of the provider.

• Status: Open
• Question Views: 909
• Answer Count: 1
• Vote Up 2 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By points N/A #169962

DTS Import/Export Wizard in Microsoft SQL Server 2000 displays error

Hello,

Microsoft is very concerned about this error. In order to fix this issue, you have to run a Microsoft Fixit. Download and run it, and then your problem will be fixed.

Also, check the date and time of your PC. It is also very important for making everything perfect.

You may also try running 32-bit providers along 64-bit SQL Server.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 05/26/2014
• Question Category: MS SQL Server