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

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

SQL Browser Services does not start - 64bit, Entp edition Clustered Envt

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

We have a 4 node active-active cluster catering to 8 instances of SQL. Recenly we had a issue when we tried to connect to the Management Studio, we were pointed with error stating that the instnace does not exist error -26 etc. The same was the scenario on all the 4 nodes and we observed that the browser serves was not starting and his was causing the connection to the server to fail.

On refering to the blogs we found that his was being caused by some 32bit registry entries in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.9. We renamed this to .9x on all the nodes and are now able to start the borwser service.

The issue here is the above is only a temporary workaround. Each time the node restarts, these entries are created again.

Could anyone guide us on how to get this fixed andwhat programs is responsible for this as though browser srevice has started, i see many errors in the eventlogs which look as below. These entries are because of the change in the registry value but we need to fix them too..

Cluster service could not write to a file (C:\DOCUME~1\SRV-EA~1\LOCALS~1\Temp\CLS887.tmp). The disk may be low on disk space, or some other serious condition exists.


View Complete Post

More Related Resource Links

SQL 2008 eval expired, ran maintenance Edition upgrade but still can't start services


We unknowingly installed a MSDN evaluation copy of SQL 2008 on a production server.  The evaluation period expired and we're no longer able to access the database.  We have purchased SQL 2008 and have run the Maintenence Edition Upgrade, it completed successfully but the SQL services will not start, event logs for the various SQL services reference 'evaluation period has expired'.  We have modified the CommonFiles DWORD value to 3 in the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfiguratioState key as noted in other posts and tried rerunning the the upgrade. We've also tried running the install on just the shared tools as referenced on another post, the install ran successfully but still not allowing the SQL services to start.

We don't want to lose our database if at all possible.  Any assistance is greatly appreciated.

Reporting Services in SharePoint integration - configurtion errors in 64bit version



We have build an MOSS 2007 environment on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. Initially configuration looks fine with reporting services integration with green indicators.


After creating a web application and accessing the web site from the report servor, i have found the following errors:


Server Error in '/' Application.

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi

Cannot start SQL Server Browser

Hello, I use SQL Server 2005 for multi-user access.  In the Surface Area Configuration, I changed the protocol from TCP/IP to Named Pipes and restarted the service.  Then I went to SQL Server Browser, stopped it and clicked on Start to restart.  I am getting a message "An error occurred while performing this operation".  I am not able to get the Browser started.  Any help would be greatly appreciated.

sql server 2008 - sqlserver(mssqlserver) services can't start

Sorry i need help, i have instal and reinstal sql 2008 over and over but always failed the problem is the services can't start and when i cek error log this written: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

SQL 2008 R2 clustered instance does not start in single user mode

Hi I am testing the startup of a SQL 2008 R2 clustered instance (Windows 2008 R2) using single user mode but it fails with : Error: 17058, Severity: 16, State: 1. initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.) - I am running the following command from the default sql installation : C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL01\MSSQL\Binn>sqlservr.exe -c -m -s SQL01 - The cluster service on the passive node has been shutdown. - The SQL Server and SQL Agent services have been set to offline in Failover Cluster Manager. Any assistance greatly appreciated. Regards, PK    

"The Database Engine instance you selected is not valid for this edition of Reporting Services" erro

Hi there, I have developed some reports using Visual Studio and everything worked fine in the office. Now I'm trying to deploy them on my customer PCs but this process keeps failing. These reports can be built and even previewed within Visual Studio but they cannot be deployed. Here is the error message I get: ----------------------------------------- The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database." is not supported in this edition of reporting services. ---------------------------------------- The versions of the software on my customer machines are: SQL Server Enterprise 9.0.3282 SQL Server 2005 Management Studio 9.00.4035 SQL Server 2005 Reporting Services Designers 9.00.4035.00 Visual Studio 2005 8.0.50727.42 I believe that changing the edition of the Reporting Services from Designers to Enterprise should fix the deployment error but I did not find a way or setup files to do so. Many thanks in advance for your help!

SQL 2005 Express Edition with Advanced Services - Upgrade SP3

Hi On my Windows 2003 server, I have SQL 2005 Express Edition with Advanced Services -  2005.90.3042.0 I need to upgrade to SP3. I downloaded the  SQL 2005 Express Edition with Advanced Services with SP3 and ran it. It has an error: UpgradeAdvisor returned -1 Please help

Cannot start Analysis Services 2008 service

Hi! I have Sql Server 2008 R2 and Analysis Services 2008. I could use it without problems for few days, but today, when I stop analysis service with Sql Server Configuration Manager and tried to start it again, it gives me error message: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". The msmdsrv.log file doesnt have any entries related to this error. Both Sql Server and AS are installed on my local machine and log on as LocalSystem. My system is XP sp3 professional.

How to start/stop SharePoint 2010 Services manually?



I am new to SP 2010.  Recently, I installed SharePoint 2010 on Windows 7 (4GB RAM), which is taking up most of my system RAM and I am unable to run any New Virtual PC within my Host.  I would like to start/stop SharePoint 2010 manually on this PC.

What are the steps (in proper sequence) involved to start/stop all SharePoint 2010 related services manually? 

Thanks & Regards,
Kamlesh | Blog | Twitter 
Posting is provided "AS IS" with no warranties, and confers no rights.

Unable to connect to local host service when a splash screen is show before start the services

Hi all:

I want to show a splash screen before start the local host services, the host can be open without error, however the client (Form1) is not able to connect to the service. Without the splash screen, every thing work fine. Any idea why ?

Here is the code.

Imports System.ServiceModel

<ServiceContract()> _
Public Interface IHelloWorldService
   <OperationContract()> _
   Function SayHello(ByVal name As String) As String
End Interface

Public Class HelloWorldService
   Implements IHelloWorldService

   Public Function SayHello(ByVal name As String) As String Implements IHelloWorldService.SayHello
      Return String.Format("Hello, {0}", name)
   End Function
End Class

Module Module1
   Private host As ServiceHost
   Private frmSplash As Form

   Sub Main()
      AddHandler AppDomain.CurrentDomain.AssemblyLoad, Addres

Upgraded SQLServer 2008 Enterprise Evaluation after 180 day period expired...Services start but stil



I have a SQLServer 2008 Enterprise (180 day eval) installation that had expired.

I downloaded and intalled SQLServer 2008 Enterprise (Full version) from Technet

and ran the "Version Upgrade" tool.

The Upgrade tool correctly identified the expired instance and reported that it

had successfully upgraded the expired instance.

The OS processes will start but when I attempt a connect, I get a "Evaluation Period Expired"

error message.

Is it possible to do an "upgrade in place" after the 180 day evaluation has expired or do

you have to uninstall then re-install ?

Many Thanks in Advance,

Hobson Black

Workflow will only auto start with browser forms


I am using an out of the box feedback workflow and have selected 'start this workflow when a new item is created'.

The workflow will only start when I manually kick it off

Developing Windows Services using Express Edition of C#


I've been trying to create a windows service using the express edition of C#. Unfortunately, there are no in-built templates for doing this (like in Pro, and all of the other editions).

Is there a way to download the templates? Or is it possible to program the service without using the helpers in the IDE. For example, I have managed to create a service by referencing the relevant DLL and inheriting the correct class, but I cannot create the installer class.

Has anyone else tried to create a service without using the IDE?

Also, just to clarify here, I do mean Windows Services and not webservices.


InfoPath Forms Services has detected a mismatch between the user's data in the browser and on the s


Hi All,

I am getting following error message in my SharePoint Logs,

InfoPath Forms Services has detected a mismatch between the user's data in the browser and on the server. This may indicate the SESSION_STATE_PASCAL_CASED is not configured properly on a multiple front end farm or that a malicious user is trying to tamper with client data.

Any idea how to solve this issue ?


Muhammad Tariq khan

Can I install Sql Server 2000 PERSONAL EDITION on 64bit macine


I have a 64 bit Windows 7 machine. Can I load Sql Server 2000 PERSONAL EDITION on my machine?

If not what can I do?

Thank You


How to get reporting services to recognise the logged on user to the browser instead of the PC

We are running reports on a sharepoint site using windows authentication. If we change the sign in to a diiferent user in sharepoint we would like the report to run as this user. At the moment it will still pick up the credentials of the logged on user. Does anyone know of a way to get reporting services to pick up the credentials of the user logged onto the browser instead of the pc user?

SQL 2005 Express Edition with Advanced Services - Backup



I cannot backup the DB via Task Scheduler


F:\RD_Sources>SQLCMD.EXE -S Server -i "F:\RD_Sources\SQLQuery1.sql"

HResult 0x2, Level 16, State 1

Named Pipes Provider: Could not open a connection to SQL Server [2].

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi

shing a connection to the server. When connecting to SQL Server 2005, this failu

re may be caused by the fact that under the default settings SQL Server does not

 allow remote conne

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