Im a beginner: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied.

Hot Topic

Help with DTSInstall.exe
bug installing SQL Server 2005 Express Edition with Advanced Services
dynamic SQL function for string (or value) combining from relational table into a flat view
A question on Conversation timer persistence
Accessing Custom Assemblies
Search with %t%y% => Error, %ty% => ok...
How to format leave detail into tabular/pivot format?
Determining the most appropriate conversion for a string
TOP 100 ordering of Data Question
How to copy & past variables

SQL Server

Script to add groups and register servers in those groups
Microsoft OLE DB Provider for DB2
Row height issue on export to Excel
SQL Server 2005 Standard on 2 nodes of a 4 node cluster
Meta Data Management / Dependancy Analysis
Can't uninstall Reporting Services
string to int????
To find all pairs in table that fits to given criteria.
xp_sendmail does not send the mail
Upgrading a cube from Analysis Services 2000 to SQL 2005

Im a beginner: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied.

Hi!

when i try to import data from Microsot Access to Microsoft OLDB DB Provider in the "DTS Import/Export wizard", an error occurs: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied. I'm using windows autentication and the data base of destination is <default>.

Could you help me out

Tank you




Answer this question

Im a beginner: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied.

  • Gunwant Walbe

    Please check if SQL Server is running.

    Thanks.



  • fburns

    Make sure that TCP/IP is enabled and the port is 1433.

    http://support.microsoft.com/default.aspx kbid=328306

    Thanks



  • pbarnsley

    Yes it is runnig. I'm using sql server 2000 and the OP is WinXP-Home (should i use another one ). The error mantains...

     



  • Im a beginner: Error Description: [DBNETLIB][ConectionOpen (Connect()).] SQL Server doesnt exist or the access was denied.
Answer this question