April 25, 2008 at 10:18 am
hai,
i am trying to create a dts package using import/export wizard. but i am getting an error while selecting the data source.
i have selected the datasorurse: microsoft OLE DB provider for sql server.
the error i got is
error source: microsoft OLE DB provider for sql server
error description:[DBNETLIB][Connection open.(connect()].sql server does not
exist or access denied
my system details: windows vista
i have installed service pack 2 (Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 6.0 (Build 6000: )
can any body give the solution for me.
thanq
April 25, 2008 at 10:23 am
You have either not entered the name of the SQL Server correctly or the login does not have rights to the SQL Server.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply