 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / May 2006Error 18456, Severity 14, State 16
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  SignatureRon McLay IT Services Manager Human Rights and Equal Opportunity Commission 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== [quoted text clipped - 30 lines] >> 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 >> [quoted text clipped - 7 lines] >>several databases to move across to this NEW SQL 2005 Cluster, any assistance >>would be great 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()). SignatureRon McLay IT Services Manager Human Rights and Equal Opportunity Commission > Hi, > [quoted text clipped - 76 lines] > assistance > >>would be great Hi, I'll try to perform research. Now, please refer to following article to see if they help. 888228 You receive a "SQL Server does not exist or access denied" error message when you try to connect to a SQL Server named instance in a cluster by using TCP/IP sockets http://support.microsoft.com/default.aspx?scid=kb;EN-US;888228 839269 You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2 http://support.microsoft.com/default.aspx?scid=kb;EN-US;839269 328306 Potential causes of the "SQL Server does not exist or access denied" error message http://support.microsoft.com/default.aspx?scid=kb;EN-US;328306 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: 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 [quoted text clipped - 20 lines] >>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, >> [quoted text clipped - 66 lines] >>> >>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 [quoted text clipped - 11 lines] >>> assistance >>> >>would be great |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.