Very Computer

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

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