{"id":76,"date":"2011-12-14T06:28:52","date_gmt":"2011-12-14T06:28:52","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/12\/14\/sql-server-error-26\/"},"modified":"2011-12-14T06:28:52","modified_gmt":"2011-12-14T06:28:52","slug":"sql-server-error-26","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/12\/14\/sql-server-error-26\/","title":{"rendered":"sql server error 26"},"content":{"rendered":"<p><strong>microsoft sql server error 26 &#8211; Error Locating Server\/Instance Specified<\/strong><\/p>\n<p>This is an instance specific error.This error does not Occur for default instances.This occurs mainly as a result of missing responce from the sql server browser service.<\/p>\n<p>When you try to connect to an instance of SQL Server then you get the following error:<\/p>\n<p><strong>Cannot connect to SERVERINSTANCE.<\/strong><\/p>\n<p><font color='red'><br \/>\nA network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 &#8211; Error Locating Server\/Instance Specified) (.Net SqlClient Data Provider)<br \/>\n<\/font><\/p>\n<p><strong>Additional information would be as follows:<\/strong><br \/>\nError Number: -1<br \/>\nSeverity: 20<br \/>\nState: 0<\/p>\n<p>The following post helps you understand the basic reasons for network related errors in sql server <a href=\"http:\/\/sqlserverlearner.com\/2012\/causes-for-network-related-errors-in-sql-server\">Causes For Network Related Errors in SQL Server<\/a><\/p>\n<p><strong>Fix for this error:<\/strong><\/p>\n<ul>\n<li>Check and confirm if the server name is correct, Contact the server admin to validate this<\/li>\n<li>Check and confirm  if the instance name is correct, Contact the server admin to validate this<\/li>\n<li>Add port number to the sql server instance name, Contact admin for the prot number of the instance<\/li>\n<li>Ping the server and check if the server is up and running<\/li>\n<li>Contact the admin of the server for additional help on this error<\/li>\n<\/ul>\n<p>If you are the admin of the server on which the instance is running then<\/p>\n<ul>\n<li>Check if the SQL Browser service is running on the server.<\/li>\n<li>Give the browser service necessary permissions by giving it a logon account for running the service.<br \/>\nFollowing are the minimum necessary permissions for the account:<br \/>\n&#8211; Should have permission to log on as a service<br \/>\n&#8211; Should have permissions to read and write the SQL Server registry keys, in order to fetch the port details etc.<br \/>\nAlso this security context of this account should be of a low privileged user, this minimizes exposure to attacks through the network.\n<\/li>\n<li>Check if the instance is not hidden<\/li>\n<li>Add exception to the sql browser service and sql server service in the firewall<\/li>\n<li>Try connecting to the instance from the server using SSMS, if it is connecting then try connecting to the same instance from some other machine in the same doman<\/li>\n<li>If you have portqry in the system then you can use the following command to query the port of the server.<br \/>\n<em><strong>portqry -n SERVERNAME -p UDP -e 1434<\/strong><\/em><br \/>\nportqry can be downloaded from <a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=17148\" title=\"PortQry\"><br \/>\nPortQry Command Line Port Scanner Version 2.0<\/a>\n<\/li>\n<\/ul>\n<p><strong>Complete error in SQL Server Management Studio &#8211; SSMS:<\/strong><\/p>\n<p>[xml]<br \/>\n===================================<\/p>\n<p>Cannot connect to SERVERNAMEINSTANCENAME.<\/p>\n<p>===================================<\/p>\n<p>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 &#8211; Error Locating Server\/Instance Specified) (.Net SqlClient Data Provider)<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nFor help, click: http:\/\/go.microsoft.com\/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=-1&amp;LinkId=20476<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nError Number: -1<br \/>\nSeverity: 20<br \/>\nState: 0<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nProgram Location:<\/p>\n<p>   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)<br \/>\n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)<br \/>\n   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)<br \/>\n   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)<br \/>\n   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)<br \/>\n   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)<br \/>\n   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)<br \/>\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)<br \/>\n   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)<br \/>\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)<br \/>\n   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)<br \/>\n   at System.Data.SqlClient.SqlConnection.Open()<br \/>\n   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()<\/p>\n<p>[\/xml]<\/p>\n<p>References: MSDN<\/p>\n<p>search references:<br \/>\nsql error 26<br \/>\nsql server error 26 error locating server instance specified<br \/>\nsql server 2008 error 26 error locating server instance specified<br \/>\nsql server 2005 error 26 error locating server instance specified<br \/>\nsql network interfaces error 26 error locating server instance specified<br \/>\nsharepoint 2010 provider sql network interfaces error 26 error locating server instance specified<br \/>\nsharepoint provider sql network interfaces error 26 error locating server instance specified<br \/>\nerror 26 sql server express<br \/>\nsql error 26 connection<br \/>\nsql error 26 cannot connect<br \/>\nsql error 26 install<br \/>\nsql network interfaces error 26<br \/>\nhost error 26<br \/>\nerror 26 connecting sql server 2005<br \/>\nerror 26 error locating server<br \/>\nerror 26 locating server instance<br \/>\nsql server error 26<br \/>\nsql server error 26 firewall<br \/>\nsql server error 26 2008<\/p>\n","protected":false},"excerpt":{"rendered":"<p>microsoft sql server error 26 &#8211; Error Locating Server\/Instance Specified This is an instance specific error.This error does not Occur for default instances.This occurs mainly as a result of missing responce from the sql server browser service. When you try to connect to an instance of SQL Server then you get the following error: Cannot&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/76"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/76\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}