RE: Error 18456, Severity 14, State 16

When connecting from a remote machine I get the following issues.

As I have been having the issue for a while, I have tried to connect
directly to the master database using the ospl connector, This also returns
that the “SQL server does not exist or access is denied”

Below is the command that I used to get this answer, could you please assist,


C:\Program Files\Microsoft SQL Server\80\Tools\Binn>osql -S sql-vm\master -U
sa -P password
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

--
Ron McLay
IT Services Manager
Human Rights and Equal Opportunity Commission


"Vincent Xu [MSFT]" wrote:

Hi,

Would you please check if you can remotely login to the SQL server by using
SQL Server Management Stuidio? If successed, I think it is a third-party
software issue. I'd like to recommend you work with the third-party vendor
for assistance.Please understand that we don¡¯t have environment to
reproduce and troubleshoot your issue, but please feel free to involve me
during the process of contacting the vendor support, I am glad to provide
any information.

Thanks for understanding.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: Error 18456, Severity 14, State 16
thread-index: AcaAR4zcbqBI8G0TR4O9r4kSNX6DCw==
X-WBNR-Posting-Host: 210.185.64.58
From: =?Utf-8?B?Um9uIE1jTGF5?= <ronmclay@xxxxxxxxxxxxxx>
Subject: Error 18456, Severity 14, State 16
Date: Thu, 25 May 2006 15:07:02 -0700
Lines: 30
Message-ID: <A995CA7F-47CE-4969-B418-692291D7E1DC@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.clustering:19929
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Scenario:
2 x Windows 2003 Servers Clustered,
Running SQL 2005 Clustered (Active/Passive)
All Service Packs and Patched are up to date,

Problem:
When you try to log in to an SQL Database remotely it does
not
allow you and informs you that the SQL Server is not available or User
Does
not have sufficient rights,
When you look in the SQL Logs the error is listed as �Error
18456, Severity 14, State 16�
Remote access to the SQL servers has been enabled thru “SQL
Server Surface Area Manager�
If you establish an ODBC connection thru windows using the same
user account it works, and can see the SQL Database

The User account we are trying to login with is
1. Domain User Account, Included in the SQL Cluster Group, Local
Administrator of the SQL Server
2. IN SQL the Domain Account has been activated and given db_creator
rights,

The Problem occours when you are using a third party piece of software to
access an SQL Database, that is when I get the error above, as we have
several databases to move across to this NEW SQL 2005 Cluster, any
assistance
would be great

--
Ron McLay
IT Services Manager
Human Rights and Equal Opportunity Commission



.

Relevant Pages

  • Re: Port 1433 access
    ... your next best option is to use a VPN and access the SQL server ... than using RWW. ... You may have a slow workstation that you are using for remote desktop. ...
    (microsoft.public.windows.server.sbs)
  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: Fail to remotely connect to SQL 2005 named instance
    ... Microsoft Online Partner Support ... SQL Browser doesn't work. ... Microsoft SQL Server MVP ... I am able to connect to SQL2005 from within the remote machine itself ...
    (microsoft.public.sqlserver.connect)
  • RE: connect to remote sql server in business Intelligence Developm
    ... try some other remote SQL Server instances. ... I installed visual studio 2005 and sql ...
    (microsoft.public.vsnet.general)
  • Re: DTS error
    ... between SQL Servers which is the option it seems like you ... to write your own package to handle qualifying object owners ... >>>remote SQL Database. ...
    (microsoft.public.sqlserver.dts)