I fixed a Sqllib error from the OLE DB provider by enabling TCP/IP in SQL Server Configuration Manager. Error received:
Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: [DBNETLIB]SQL Server does not exist or access denied
The simple fix:
Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server 2005 Network Configuration >> Enable TCP-IP.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
Discover more from SQL Authority with Pinal Dave
Subscribe to get the latest posts sent to your email.
11 Comments. Leave new
I have (Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server 2005 Network Configuration >> Enable TCP-IP) already enabled and I’m getting this error:
Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Then this error:
An error occurred while attempting to log in to the following server: “HFPDEXCH”.
SQL error number: “0011”.
SQL error message: “[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I must be missing something.
“.
Hi,
I have the same problem with creating DSN but on my local machine! I did as your comments but no result yet :(
Could you help me resolve my problem?
Thanx!!!!
Your article solved a problem I was fighting with for days!
Hi…
I also have the same problem..
Can you help how to resolve this problem?
TQ
Hi
I run in the same problem…the BOXI3.1 was working smoothly with all the products with SAP integration installed.
Yesterday I installed another application called SAP Business One 8.8 and it ruined everything on my machine. When I log on in Designer/WEBI I do not see Enterprise authentication.
Configuration of my machine: XP SP2.
Need help…
Regards
Arvind
@all,
I had the same problem, i notised that the sql instance off Sharepoint didn’t work well, Becouse I don’t use this instance I dicide to disbled it.
Repair would be nice, but I don’t use it and just disabled the services.
Good Day!
I have a WIndows Server 2008 and a MSQL 2008 also the problem is i cant connect the database to another units in the offce but in the server the program runs, Btw im using MS Access. Everyitme i try to conncet the Units to the server i’m getting this error.
Connection Failed
SQL State ,’0100′
SQL Server Error: 5
[Microsoft][ODBC SQL Server Driver][DBNETLIB] Connection Open
(Connect())
Connection Failed:
SQL State ‘08001’
SQL Server Error: 17
[Microsoft][ODBCSQL Server Driver][BDNETLIB]SQL Server does not
exist or access denied.
Btw the network is ok we could share files.
Hope you could help me with this one!
Hi
What can do if same proplem happen in SQL server 2008
what do you mean sir by that same trouble as mine?
I have a WIndows Server 2000 and a MSQL 2000 also the problem is i cant connect the database my some user (pcs).
Connection Failed
SQL State ,’0100′
SQL Server Error: 71
[Microsoft][ODBC SQL Server Driver][DBNETLIB] Connection Open
(Connect())
Connection Failed:
SQL State ’08001′
SQL Server Error: 17
[Microsoft][ODBCSQL Server Driver][BDNETLIB]SQL Server does not
exist or access denied.
Btw the network is ok we could share files.
Hope you could help me with this one!
Hi all,
dbnetlib connectionopen (connect()). sql server does not exist or access denied. sql server 2008 R2