>>Thread-Topic: Error 18456, Severity 14, State 16
>>thread-index: AcaAevWBZB0Pl7YuTTyVXEx7T1HyXQ==
>>X-WBNR-Posting-Host: 210.185.64.58
>>From: =?Utf-8?B?Um9uIE1jTGF5?= <ronmclay@news.postalias>
>>References: <A995CA7F-47CE-4969-B418-692291D7E1DC@microsoft.com>
<4VXjrMHgGHA.5608@TK2MSFTNGXA01.phx.gbl>
>>Subject: RE: Error 18456, Severity 14, State 16
>>Date: Thu, 25 May 2006 21:15:02 -0700
>>Lines: 112
>>Message-ID: <F77303C5-0509-4E21-A498-34A7B1268D1F@microsoft.com>
>>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:19933
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.clustering
>>
>>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@news.postalias>
>>> >>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@microsoft.com>
>>> >>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
>>> >>
>>>
>>>
>>