.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

problem setting instance configuration.

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

I'm trying to install SS 2008 Express with Advanced Services and am having a problem with the Instance Configuration.  

The default instance is preset with an InstanceID of SQLExpress.  This gives me an error that says:

"The instance of SQL Server already has an instanceID of '1' that is different than the specified Instance ID 'SQLExpress'.  Specifying more than one instance ID for the same SQL Server instance is not supported."

Then in the area that shows the installed instances it has: Instance="SQLEXPRESS", Version "9.2.3042.00", InstanceID="MSSQL.1".

I think the instance that's already installed is the SS 2005 express that was installed with VS 2008.  It looks like the Version of the SS 2008 I'm trying to install is 10.

I've tried different things but haven't been able to get this to work.  I also tried the Named Instance but got the same error.  

Can someone help me understand what I need to do to get this installed? 

View Complete Post

More Related Resource Links

SQL Server Express2008 R2 brings app down, instance problem


I have tried dozens of changes and modifications to many settings as I will outilne here and all to no avail.

The short answer here though is that I uninstalled SQL Sever Express 2008 R2 and went back to the "NON" 2008 R2 and got things working. But like the fool I am wanted to run on the more current rev and updated again, all problems returned....



Win Server 2003 R2 SP2


VWD2008 Express (removed)




XP Sp3

VWD2008 Express

SQL Server Express 2008


I was orginally getting this message after updating to SQL Sever Express 2008 R2, I removed VWD 2008 Express from the web server, no good, then uninstalled SQL Server 2008 Express R2 and reinstalled SQL Server 2008 Express. worked but had issues, couldn't install MGTM Studio. Then I removed SQL 2008, cleaned folders and reg. Reloaded SQL Server 2008 Express, still flaky, couldn't get the Management Studio to install. So I removed it again and used the Web Platform Installer, which worked but loaded 2008 R2 again. Which brought back the message.

Failed to genera

Membership.ValidateUser "The serviceUri configuration setting was not found."


Hello everybody!

I use Membership.ValidateUser to check user credentials, but when I do so, I get the following ArgumentException: "The serviceUri configuration setting was not found." I just can't understand what is the problem here.

Here is a part from my Web.config:

      <membership defaultProvider="MembershipProvider">
            description="ASP.NET Membership database services."


problem on Page_PreRender with RangeValidator control and programmatically setting Maximum and Minim

I am new to the ASP.NET /C# dev. I run into a weird bug when using the RangeValidator Control inside a Formview. I have my DateTime field with validator and it work fine until I submit the page, it actually insert the row into the database but then when the page reload I get the following exception.Server Error in '/Budget' Application. The value '' of the MaximumValue property of 'RV_AjoutUtilisateurDate' cannot be converted to type 'Date'. 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.Web.HttpException: The value '' of the MaximumValue property of 'RV_AjoutUtilisateurDate' cannot be converted to type 'Date'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [HttpException (0x80004005): The value '' of the MaximumValue property of 'RV_AjoutUtilisateurDate' cannot be converted to type 'Date'.] System.Web.UI.WebControls.RangeValidator.ValidateValues() +1077011 System.Web.UI.WebControls.RangeValidator.ControlPropertiesValid() +12

Configuration problem?

Hi All, I created one config for all of my pcakges.I tested in my system its working fine. In my system sqlserver is windows authentication. I modified the configfile which system has sqlserver authentication its working fine. Same config file I am trying to execute in QA box I got error related to authentication. How to modify current confige file related to sqlserver authentication? Thanks CMK...

Problem with MOM using DMO to connect to SQL 2000 instance

Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

Problem With Using Trigger for Setting Label Content

Basically, I have a label and depending on the Object type of the current data source item I want to control what the content of the label is. The trigger I am trying is: <Label Margin="222,21,242,134" Name="MyLabel"> <Label.Resources> <DataTrigger Binding="{Binding Path=/EntryType}" Value="Object.Type1" x:Key="myTrigger"> <Setter TargetName="MyLabel" Property="Content" Value="{Binding Path=/Object.Property1}"/> </DataTrigger> </Label.Resources> </Label> The problem is that I am getting this error: 'Content' member is not valid because it does not have a qualifying type.   Do I need to use some sort of converter or something? Or am I aproaching this worng?

Problem setting Foreground with Visual State Manager (WPF - .Net v4.0

0 down vote favorite I have a WPF application, and I am attempting to style a TextBox using the .Net v4 Visual State Manager. Specifically, I am attempting to set the colors of the Foreground and Background for the MouseOver state. What is happening is that, while the background and border are changing perfectly, the foreground is not. If the brushes that I am using get their color via a StaticResource, then the foreground does not change at all. If the brushes that I am using get their color via a DynamicResource, then when I mouse over a TextBox, the foreground of all TextBoxes change. Clearly, either I'm doing something wrong, or what I want to do is simply not possible with VSM (which would be rather disappointing). Here are the resources that I am using:   <Color x:Key="ControlBackgroundColor" R="178" G="178" B="178" A="255" />  <Color x:Key="ControlForegroundColor" R="0" G="0" B="0" A="255" />  <Color x:Key="BorderColor" R="127" G="127" B="127" A="255" />  <Color x:Key="MouseOverControlBackgroundColor" R="0" G="0" B="0" A="255" />  <Color x:Key="MouseOverControlForegroundColor" R="255" G="2

Problem in setting up Windows Authentication in Windows 2008 RC2

Hi,We have a working version of application (Intranet) with uses Windows Authentication deployed in Windows 2003. The application uses HttpContext.Current.User.Identity.Name to get the logged-in user. Here impersonate is turned off.Right now, we are move to Windows 2008 RC2 where this Windows Authentication problem arised. I have Digest Authentication and Windows Authentication enabled. And also I have enabled Anonymous Authentication enabled to avoid the Login dialog of IIS in the end-user IE. Now I am getting HttpContext.Current.User.Identity.Name as Empty. When I impersonate using username and password, I am used to login using that user but all the users uses the same user to login.Does any has solution for this?Deployment Server - Windows 2008 RC2 (IIS 7.5)Development - Windows 7 (IIS 7.5)I am new to IIS 7.5. Please give me a solution

Problem setting up approve/reject settings in Absence Request and Vacation Management Template

Hi I have recently installed and set up the absence request and vacation management template in SharePoint Services 3.0 and all seems to be going reasonably well apart from one hitch. I have edited the setup workflow so that manager is sent an email on request, employee is sent an email on approval/rejection and payroll are sent an email on approval for their records. However, even though the Personal Vacation option in the Absence Type list is set to Yes for Approval Required, the workflow is automatically sending out the email to say their annual leave has been approved as soon as they request it. Has anyone come across this before or know where I may be going wrong? Thanks for any help you can give. Jo

Laptop configuration for setting up SharePoint 2010 development environment

guys, i see a lot of new intel processors out there like I5\ I7, my question is which one is good to set up a complete hosting environment while taking it for travels. i would like to have SP 2010\ Sqlserver 2008 in VM environments. Also what kind of RAM?   thanks in advance sameer

Problem setting variable/param in XSLT for XML control in .NET 4.0

I am using an XML control in VS2010 with .NET 4.0.I am trying to sort XML data into a table. I have a drop list with the sort key, and a button that is supposed to display the table with a new sort.Here is the code the button calls:</p><p></p><p style="text-align: left;" mce_style="text-align: left;"><font class="Apple-style-span" face="Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace"><span class="Apple-style-span" style="border-collapse: collapse; line-height: 13px;" mce_style="border-collapse: collapse; line-height: 13px;" mce_fixed="1"></span></font></p><p><font class="Apple-style-span" face="Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace"></font></p><p><font class="Apple-style-span" face="Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace"><div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">private void PopulateXML( Xml MyXML)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: h

problem with attaching a db instance to app_data

hey,i've problem with attaching an existing db instance to app_data folder (need to work with ado.net). once i do so, an error message crops up alerting that the db instance is in use by another process that i guess is sql server 2008. i detach the instance from sql management studio and again attach it to my app_data and it works this time and i see my instance ready under the folder but when i double click it another message comes up indicating some problems about not having found such instance or something! i even connect my instance via data connection in server explorer but nothing happens. please help me cause noway i get to get around the problem!any help is welcomed.

Setting Auto-Rules in Cube Security Roles configuration




Our client's requirements for some Charts are simply:

1. Users with no access to specific Business Units (A Dimension with Parent-Child Hierarchy, refereed as BU from now) shall see the total amount (Revenues for example) of All Top Parent BUs but should not be able to drill down on any of the children BUs of the Top Parent BUs they don't have access to.

2. Users with full access to specific BUs shall be able to see the whole value of All Top  Parent BUs and their children BUs as well.



1. User with No Access to  BU 'A' shall see the total Value for this BU A, but cannot drill down to A1,A2,Ax.. which are children of A.

2. User with Full Access to  BU 'A' shall see the total Value for this BU A, and can drill down to A1,A2,Ax..


For disabling access to specific BUs with the ability to see their total values, I did the following in the cube security roles configuration (Consider the latter Example #1):

1. In the Dimension Data Page, I chose the radio box Select all members, And checked the box beside the BU A, unchecked all

change configuration setting to allow more than 30 mb in sharepoint


I nee to know where / how to change the .config file to allow more than 30 mb ona sharepoint installation on w2K8 R2

Microsoft - 30 MB is wayyyyy too small and this could be a good OPTION for admins to be able to control without touching thre xml!!!!

Problem with Configuration of Message Inspector

I'm hoping someone might know what I am doing wrong. I'm trying to setup message interceptors and am trying to apply them to all of my services via the web.config. I've been working on it for hours but keep getting the following error:

Parser Error Message: The type 'AdventureWorksService.
Interceptor.ListenerServiceBehavior, AdventureWorksService.Interceptor, Version=,
        Culture=neutral, PublicKeyToken=null' registered for extension 'TestInterceptor' could not be loaded.

I have the classes under a the 'AdventureWorksService.Interceptor namespace in my web project.

Here my web config:

<?xml version="1.0"?>
    <serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true">
        <add relativeAddress="~/DataService.svc" service="AdventureWorksDataService"/>
    <!--For REST-->

Doubt on WorkingSetMinimum setting in SSRS 2008 configuration file


Hello All,

I have been reading about memory settings for SSRS 2008 for better performance in this link.                                                          http://msdn.microsoft.com/en-us/library/ms159206.aspx  WorkingSetMinimum definition here says that "Specifies a lower limit for resource consumption; the report server will not release memory if overall memory use is below this limit."

Now, I have set the WorkingSetMinimum value as 2.4GB and when I am executing a report with 300K records, I observed in Perfmon that it has consumed around 1GB of available memory during report run time but the report server has not acquired the designated memory of 2.4GB in WorkingSetMinimum as I can see more memory as available MB than the value supposed to be after dedicating minimum memory of 2.4 GB to report server.

  1. My first question, has report server not acquired the minimum memory configured in WorkingSetMinimum because it didn't required that much memory to construct the report? &nb

problem with connecting to local SQL Server 2008 default instance using windows authentication




I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.


2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:]



This us

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