Help!!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied 
Author Message
 Help!!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

Hi everybody:
i' ve  developed HelpDesk application VB 6 and i used database SQL Server
6.5.
when i run this this application on Windows 98 and Window NT workstation
client machines. then
it gives me this error

Connection Failed
SQL Server Error 2:
ODBC SQL Server Driver(DBNMPNTW) Access Denied

Connection Failed
SQL Server Error 5:
ODBC SQL Server Driver(DBNMPNTW) Connection Open (Create File())

if anybody knows please let me know Thanks

Muhammad Qureshi




Thu, 06 Sep 2001 03:00:00 GMT
 Help!!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

Muhammed,

Quote:
> Subject: Help!!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

Q.     I'm getting an "access denied", "CreateFile" or 1326 message when connecting to
SQL Server.
(v1.1  1999.03.19)

A. The message may be one of the following

----------
Msg No 10004 Severity 9  State 0
Unable to connect: SQL Server is unavailable or does not exist.  Access denied

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][dbnmpntw]ConnectionOpen(CreateFile()).

MSG 10004, Severity 9.( sqlserver not available).  OS 1326
----------

This isn't a SQL issue, it's an NT one.  If you are using a net-lib that requires NT
authentication - e.g. named-pipes or multiprotocol - then you MUST be able to
authenticate to the copy of NT running SQL Server.  

You can test whether you can do this by doing a "NET VIEW \\servername" from a command
prompt on the client.  If you get an access denied message, or get prompted for a
password, then you aren't being authenticated.

If this happens then you need to setup a trust between the domains.  Or, you could use
a net-lib that does not need authentication - e.g. tcp-ip sockets.

If you can't have a trust (and really this IS the best method) then you can override
the NT details by doing a "net use \\<server>\ipc$ /user:<serverdomain>\<userid>
<password>" with an account that is in the domain.  But this is a manual process and
prone to fail when the password changes.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp



Fri, 07 Sep 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Help!!!!!!!!!!!!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

2. Help !!!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

3. Help!!!!SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

4. Help!!!!!!!!!SQL Server Error2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

5. Help!! SQL Server Error 2: ODBC SQL Server Driver(DBNMPNTW) Access Denied

6. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error

7. what is ODBC ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error 23

8. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

9. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

10. [ODBC SQL Server Driver][DBNMPNTW]Connection broken.

11. [ODBC SQL Server Driver][DBNMPNTW]Connection broken.

12. RAISERRO (14152,'08001[Microsoft][ODBC SQL Server Driver][dbnmpntw]ConnectionOpen (CreateFile()))


 
Powered by phpBB® Forum Software