Very Computer

Dear Friends,
  I am having troubles in registering sql servers running on different
machines with my SQL enterprise manager using Named pipes. It works with
TCP/IP client configuration though. I need to use Named pipes because of
some restrictions with the SQL 6.5 replication. Any help is greatly
appreciated. Does the version of ODBC driver matter here? Please help.

  Thanks
    Shashi Shankar

Sent via Deja.com http://www.deja.com/
Before you buy.

Shashi - no, it shouldn't matter.  Can you NET VIEW \\servername the server ok
from the machine with SQL EM on?

Quote:>   I am having troubles in registering sql servers running on different
> machines with my SQL enterprise manager using Named pipes. It works with
> TCP/IP client configuration though. I need to use Named pipes because of
> some restrictions with the SQL 6.5 replication. Any help is greatly
> appreciated. Does the version of ODBC driver matter here? Please help.

>   Thanks
>     Shashi Shankar

> Sent via Deja.com http://www.deja.com/
> Before you buy.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (365 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk

Hi Neil,
  Thanks a lot for your reply. I tried doing net view on the machine
with SQL enterprise manager on and it FAILED. Please suggest how I
should proceed. Its kind of a very urgent matter for me. Thanks a lot.

  Bye,
    Shashi Shankar

Sent via Deja.com http://www.deja.com/
Before you buy.

Shashi - what did it fail with?  Access denied?

Quote:>   Thanks a lot for your reply. I tried doing net view on the machine
> with SQL enterprise manager on and it FAILED. Please suggest how I
> should proceed. Its kind of a very urgent matter for me. Thanks a lot.

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 with 6.5 or
below and any net-lib with 7.0 - 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 reply only to newsgroups)
 SQL FAQ (365 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk