.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server Network Interfaces Error 26 - while failing over SQL Server 2008 R2

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Before I explain the issue I am facing, I would like to say that I did read the post at  http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx but in my case the problem is transient (lasts for approximately two minutes after a failover) so items 1-3 in the list of troubleshooting steps do not seem to make sense. As to 4 and 5, the named instances use non-default ports (2433 and 3433 respectively), so I do not know how to tailor the PortQry command for that. I tried  portqry.exe -n ServerA,2433-p UDP -e 1434 and  portqry.exe -n ServerA,2433 -p UDP -e 2434 and it failed both times with a "Failed to resolve name to IP address" while the server was up and serving database requests The same thing happened when I tried it with the failover server as well. ***The issue I am facing*** I am using Enterprise Library 4.1 to connect to a SQL Server 2008 R2 database with a mirror. My connection string itself is as below (with dummy values for all fields): "Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=DBName;User ID=uid;Password=pwd;Connect Timeout=5" Sample .NET code is as below (with modifications to instantiate all variables locally to provide context): SqlDatabase db = new SqlDatabase(ConnectionString); SqlConnection cn = (SqlConnection)db

View Complete Post

More Related Resource Links

SQL Server 2008 Installtion Error : A network error ... SQLE86D.tmp.msi

Hi all, I'm trying to install SQL server 2008 on a Windows Server 2008 SP2 64bit , but I'm facing this error message: "A network error occured while attempting to read from the file E:\9c......\x64\setup\x64\SQLE86D.tmp.msi" Have anyone faced the same message before? Regards, Waleed

Network error when installing SQL Server 2008 Enterprise

Hi guys, I'm trying to install an SQL Server 2008 Enterprise on Windows Server 2008 R2 Standard and I've got an network error:   TITLE: Microsoft SQL Server 2008 Setup ------------------------------ The following error has occurred: A network error occurred while attempting to read from the file: C:\Publico\en_sql_server_2008_enterprise_x86_x64_ia64_dvd_x14-89207\x64\setup\x64\SQL93C3.tmp.msi For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401 ------------------------------ BUTTONS: OK ------------------------------   I don't know why a network error, because I'm intalling from an local .ISO file. Thanks, Luciano

Damn this (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)



Well my problem is this error message Message="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 - Error Locating Server/Instance Specified)"


but :


-can't connect to SqlServer Express 2005 on my network server from my application while ITS RUNNING. What I mean is that when I use Server Explorer Window on VS2008 every thing is fine (I can even insert and modify data from server explorer), in fact, when I use Datatables and I choose to preview data through TableAdapters (Design Time) I get data, and also can run the queries from there directly to the data base, but when I'm debbugin the application I get this error.


-when I run Sql Server Management Studio, its also fine, even though I can't see the Sql instance on the server (or any of my partners machine) when I try to browse them. But if I type the server path (servername\instancename) everything is OK.


-I know the problem is not the connection string 'cause mya partners nd I use the sa

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified



I am receiving an intermittent error as described in the thread title. I have checked several other threads and the commons solutions seem to be...

check the SQL browser service is running

check the spelling of the instance name

check that the correct UDP port is open on the firewall

All of the above are ok in my case but where my case differs is that the error is intermittent - restarting the server solves the problem but sooner or later, it reocurrs. This specificaly relates to an asp.net application - even when I start getting the error, the web app runs fine over the network but running it in debug or testing / creating connection strings gives error 26. I am all out of ideas with this and it's really not convenient to shut down the server in the middle of a working day. I intended to include the full error text at the end of this question but in the time it has taken me to type this, it has started working again (what the ____!!??!). I am running SQL Server 2008 Express with Visual Studio 2010. Any help would be greatly appreciated.



 Update: full error text below...

Server Error in '/' Application.

Error " cannot generate SSPI Context Sql Server Network interfaces"


Hi all,

I am getting an error while creating OLEDB connection in SSIS Package as following

test connection failed because of an error in initializing provider.Cannot generate SSPI context Sql server network interfaces: the local security authority cannot be contacted.

I have SQL server 2008 R2 version running on local server. I am able to connect to the SQL server using Windows authentication. But when i try to create OLEDB connection in SSIS package i am getting above error.

SQL Browser is running.

I have even checked SQL server configuration and Named pipes are enabled. But still i am getting the same error.

Any idea where to look would be of great help?



Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Server 2008 R2 -> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error mess


So I am using the aspnet_regiis.exe tool to encrypt sections of the web.config in my asp.net applications and services.  I have done this for years successfully on Windows Server 2003 (IIS 6).  However I just moved some apps over to Windows Server 2008 R2 (with IIS 7.5) and I am now receiving the following error at runtime:

"Server was unable to process request. ---> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: Bad Data."

Now I am quite familiar with this process and am stumped at what I have missed this time around.  I have done ALL of the following which typically suffices for the process on the server. PLEASE READ ALL AND DO NOT PROVIDE RESPONSES OR LINKS FOR THINGS I HAVE ALREADY DONE Thanks!!  Wink

  1. Imported the keys to the server using aspnet_regiis -pi  Result: Success
  2. Given FULL permission (using -full switch) using aspnet_regiis -pa to ALL of the following accounts  Result: Success
    1. [SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

      Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

SQL Server 2008 - Job Activity Monitor Failing

I recently began migrating to Windows 2008. One of the first servers is a server which we install our tools on. This is a new server which currently is only running the SQL Server management tools. On this server I installed the SQL Server 2008 R2 management tools, prior to this install there were no other SQL Server tools installed on this server. The majority of the functionality works and I can connect and manage multiple databases servers from SQL Server version 2000 through 2008. But when I try to bring up the Job Activity monitor I get an error ==> Can not show requested dialog. From Windows XP Windows Server 2003 SP2 this functionality works. I get this error if I connect to a SQL Server 2005 or 2008 database instance. I have tried re-installing the client tools but I still get this error..... any ideas?

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

error while installing sql server 2008 r2 on win7

what can i do? i had .net framework 3.5 sp1 details is: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\seven\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. File name: 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'    at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)    at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)    at System.Configuration.RuntimeC

BootstrapExtension.ExecuteWorkflowAction error while installing SQL Server 2008 R2

After installing Visual Studio 2010, I found that I could no longer open SQL Management Studio.  I could not even uninstall them because the uninstall was dying.   So I manually removed sql server from my system and now I am trying to install SQL Server 2008 R2 Express. However, the install is failing silently.  Here is the Detail_LandingPage log file:   2010-08-27 13:42:44 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered 2010-08-27 13:42:44 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered 2010-08-27 13:42:44 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' 2010-08-27 13:42:44 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd' 2010-08-27 13:42:44 Slp: Document 'Microsoft.SQL.Chainer.PackageData.Package.xml' validated with schema 'Microsoft.SQL.Chainer.Package.Package.xsd' has been successfuly loaded into datastore path '/Datastore/Package' 2010-08-27 13:42:49 Slp: ---------------------------------------------------------------------- 2010-08-27 13:42:49 Slp: Running Action: ReadProductXML 2010-08-27 13:42:49 Slp: Reading XML resource 'Microsoft.SQL.Chainer.Product.Product.xml' 2010-08-27 13:42:49 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Product.Product.xsd' 2010-08-27 13:42:49 Slp:

report viewer error / visual web developer 2008 / sql server 2008 / report viewer add on / win7 x64

hi, i decided to export my local site to iis today, the process wasn't smooth.   anyway. i was able to access my site, the db tables are working as i am able to create new records and retrieve them. my main problem now is with the report object. i've tried the work around found here : http://support.microsoft.com/kb/2002980.. it helped sort of. i used to have only a big page of error before i did the work around, now i am able to see half of the report (the report interface) but the contents, the field are filled with 404 errors. any idea how i can fix this??                  

SQL Server 2008 64-bit installation error 0x84B20001

Hello, I'm trying to install SQL server 64-bit and I'm getting the following error: SQL server 2008 setup100.exe and setuppatch.exe cannot be run in this mode. If tou are running setup100.exe, start setup.exe instead. I can't find setup.exe for the 64-bit installation. What can I do? Thanks.    

Error Editing Step in Job (SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64))

Hello I am working on SQL Server 2008 migration project. We have SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) on WS 2008 R2 Standard. 1) I am getting error when i try to change a step in job. The error information is given below. -- TITLE: Microsoft SQL Server Management Studio ------------------------------   Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)   ------------------------------ ADDITIONAL INFORMATION:   Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS) -- Any idea why i am getting this error. It goes away when i close SSMS and re-open SSMS. Comes back again later on. Thank You for the help V

Best practice for user defined error messages in SQL Server 2005/2008 --Need help

My requirement is to setup a standard practice for our team in handling DB erros and also  user defined messages. We are handling exceptions using Raiseerror method with in Try and Catch blocks.  For user defined message, we are using Sp_addmessage to add our application specific error/warning messages with error codess>80000.  Ex: 80001 | Company name already exists. please check. Here is the sample code ********************************************************************* CREATE PROCEDURE [dbo].[usp_CompanyProfile_insert]  -- Add the parameters for the stored procedure here  (@company_name VARCHAR(50),  @company_code VARCHAR(3),  @user_id INT  ) AS BEGIN  -- SET NOCOUNT ON added to prevent extra result sets from  -- interfering with SELECT statements.  SET NOCOUNT ON;  BEGIN TRY -- Begin Try Block      -- Validate company name   IF EXISTS (SELECT company_id FROM companyprofile WHERE company_name = @company_name)    RAISERROR(90021, 16, 1)      INSERT INTO companyprofile (company_name,       company_code,       createdby)   VALUES(@company_name,     @company_code,     @user_id)    END TRY  -- End Try Block &

SQL Server 2008 Internal error at ExecuteSqlCmd

On a version of SQL Server 2008 with Service Pack 1 applied (on Windows Server 2003), I am finding that when trying to run a bulk number of jobs using the sqlcmd command, one of the jobs will randomly fail to run with the following error thrown in the command window: Sqlcmd: Error: Internal error at ExecuteSqlCmd (Reason: Unspecified error). I've found that each time the batch of jobs is run, a different one will fail to run each time.  It seems to be completely random which one will fall over, but you can guarantee that at least one will fall over each time. I've tried numerous websites to find an answer and no luck so far.  There is a hotfix which has been released for this exact same problem (http://support.microsoft.com/kb/2121407/) but this is only for R2 and so cannot be applied to my installation and we're not in a position to move to R2 as yet. Is there a fix available for non R2 users for this?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend