Initialization Failed With Error 0x5

0x50 ★★★★★★★★★★★★★★★ SQL Server ConnectivityJanuary 31, 20073 Share 0 0 In this post, I want to talk about a special cause of this specific error message when you try to start SQL 2005 instance. The symptom here is: The NP and TCP protocol were disabled in your SQL 2005 default instance, and you tried to startit but failed. you went to Server ERRORLOG, and found following error message: Server local connection provider failed to listen on [ \.pipesqlquery ]. Error: 0x50Error: 17182, Severity: 16, https://blogs.msdn.microsoft.com/sql_protocols/2006/03/08/sql-server-fails-to-start-with-errorlog-reporting-tdssniclient-initialization-failed-with-error-0x5-status-code-0xxx/ State: 1.TDSSNIClient initialization failed with error 0x50, status code 0x50Error: 17182, Severity: 16, State: 1.TDSSNIClient initialization failed with error 0x50, status code 0x1. 0x50 stands for "The file has already exists". And the problem here is SQL 2005 was trying to listening on the default pipe name for legacy client locally connecting to the default instance under situation that server named https://blogs.msdn.microsoft.com/sql_protocols/2007/01/31/tdssniclient-initialization-failed-with-error-0x50-status-code-0x50/ pipe was disabled by default after fresh installation, however, the pipe name was occupied by another bogus server. In this case, I want to point out you might need to check whether there is a SQL 2K named instance on the same box, and it is running. You can verify that by running "osql.exe /Snp:. /E /Q"select @@version" " or "osql.exe /S\.pipesqlquery /E /Q"select @@version" " to see whether it is the SQL 2K instance took over the pipe. If so,you need to go to "SQL Server Network Utility", click the properties of Named Pipe, and check whether the pipe name was gone, or double check registry key "PipeName" under "HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server<2kinstancename>", make sure there is correct value, then restart the 2K named instance, and restart the 2K5 default instance. Note: You might hit another problem"0x5, ACCESS_DENIED" if you retry starting SQL 2k5 default instance after fixing the pipe name, whichmight due to ifyou shutdown the 2K instance and the handle of the pipe is still holdby kernel file system. Follow up the solution in the below blog:http://blogs.msdn.com/sql_

features please LoginorRegister. ForumActive TopicsSearchHelpLoginRegister provider failed to Search NotificationErrorOK Developer Forum » Login Login User Name or E-Mail Address: Password: Remember me | Login with Facebook Powered by YAF 1.9.6.1 | YAF © 2003-2016, Yet Another Forum.NETThis page was generated in 0.005 seconds.