DTS Import/Export Wizard in Microsoft SQL Server 2000 displays error
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.