.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 express 2008 r2 on windows server 2003

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."

View Complete Post

More Related Resource Links

Sharepoint 2003 + Windows Terminal Server 2008 + Office 2007 problem?

Hi, We have a customer where some users runs Windows Terminal Server 2008 with Office 2007. They open documents from a Sharepoint 2003 site. When they open an excel sheet they get a button in the document which says "Server workbook: Click edit workbook to edit this workbook" and there is a button: "edit workbook" The users clicks "edit workbook" but get an error message saying there is no connection to the server.  They are able to edit the document, but not save it back to the sharepoint site. Most other users work on their local computer with Office 2003. Here, everything works fine and there are no button/message stating its a server workbook.   Is this caused due to some compatability issues between Sharepoint 2003 and Office 2007?   Best regards, Thomas Hansen ErgoGroup AS

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

SQL Server 2008 R2 64 bit Installation on Windows 2003 64 Bit SP2---Installatio help..

Hi all I have SQLServer 2008 r2 binaries copied in my Server and I have do side by side installation. Server already has SQL Server 2000 64 bit on Windows 2003 64 bit SP2. Now  I have to install  SQL Server 2008 64 bit (Side by Side.). Is it ok...if I click on setup.exe it will take care of  Installation of 64 bit or I need to specify any thing to install 64 bit SQL Server 2008. Please guide me with link or advise me where I have take care while installation going on to install 64 bit SQL Server 2008 R2. Thanks in advance.  SNIVAS

Windows 7, SQL Server 2008 Express & VWD 2008 Express Setup Problems

Hi I have Windows 7 Home Premium, and Visual Web Developer Express 2008 (which came with SP1) installed. SQL Server 2008 Express never worked - Windows 7 won't allow the Management Studio to be installed and VWD was asking for SQL Server 2005.  Looking on the web, I found advice to try the 32 bit version of SQL Server instead.  This would work with VWD, apparently.  I referred to these instructions (http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm) and used the latest links and instructions, but I could not install SQL Server at all - apparently something to do with WOW64... This has been going on for a WHILE and I'm going nuts.  I am reluctant to uninstall VWD and start again, because I had to manually fix a few things, and now it's working...  PLEASE can someone tell me of a working configuration, I have read SO MUCH advice on this, and none works, including those release notes (unless I missed something) :(

Windows XP, Visual Studio Express 2010 and SQL Server 2008 Express - How can I save modified columns



I am using c# in VS 2010 Express. I have a MDF database that I connect to through "Database Explorer". Database Explorer will not let me SAVE columns that I have modified. As I know in SQL Server 2008 full edition you can change the setting "Prevent saving changes that require table recreation" in Management Console to prevent this. I haven't got Management Console and can't see it in install.

How do I change this setting if I haven't got management console? Is it in Registry or Config File.



Remove SQL Server 2008 R2 Express Edition from Windows 7 professional


Are there any good practices to follow in order to remove/uninstall SQL Server 2008 R2 Express Edition from Windows 7 professional laptop? Thanks for your comments.




Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.

SQL Server 2008 Express R2 on Windows Server 2008 R2 x64


I installed a SQL Server 2008 Express R2 on Windows Server 2008 R2 x64 machine on 15th february 2010.

Today I can't start the "SQL Server" windows service. I have tried manually, but the error is:

"Window could not start the Sql Server (SQLEXPRESS) on Local computer"

After trying to start the  the "SQL Server" windows service, I have read on the Event viewer the following error:

"SQL Server evaluation period has expired".

After trying to launch the SQL Management studio Express 2008 I have read this erroe on a pop-up windows:

"Evaluation period has expired."

I though that the express edition was free. I need only to register or to buy?

How can I buy?

I am in hurry. Please let me know! Thank you very much.



Visual Web Developer 2010 Express - installation on Windows Server 2008



We are trying to install VWD 2010 on a windows 2008 server. We already have installed the 2008 version as well as SQL 2005, 2008 and 2008 R2. The Web Platform installer is not installing VWD 2010 however.

At first it notified us that the OS does not allow it, after running tons of updates on the OS (some of which failed) it is still not doing it, not even donwloading it. The latest message simply asked us to post the error on the forum.

Has anybody had similar experiences? If so, how was it solved?



WSS 3.0 seach fail after migration from Windows Server 2003 with SQL 2000 to Windows Server 2008 wit


Hello we have a WSS 3.0 on a Windows Server 2003 with a single site, and we are trying to migrate it to another server with Windows Server 2008. All database are on a Microsoft SQL Server 2000.

We installed WSS 3.0 from scratch on the new server. We put the default databases on a server with Microsoft SQL Server 2008.

Then we made a backup in the production server with the following command: stsadm -o backup -url https://portal -filename musa.bak

After that we restored the backup in the new server with the following command:  stsadm -o restore -url https://uymvd18 -filename c:\sharepoint\portal-2010-10-05-21-00-06.dat -overwrite

(portal is the name of the old server and uymvd18 is the name of the new one)

Everything worked ok, but the when we try to do a search in the new se

SQL Server 2008 R2 Side by Side installation in Cluster(Active/passive on Windows 2003 SP2).


Hi all,

I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).

1.I have already have SQL Server 2000 SP4 Installation.
2.Can I start Installation(Side by Side) from Passive node ?

3.you want me give New SQL Server Netwrok name (Instance Configuration  Screen)?.

4.you want me give New Instance ID  name (Instance Configuration  Screen)?

5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?


Thanks in advance


Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.


Hot fixes for Windows 2003 SP2 for Installing SQL Server 2008 R2 In Cluster environment


Hello all

Please some body help me to  find Hot fixes  for Windows 2003 SP2 to install SQL Server 2008 R2 In Cluster environment.




Thanks in Advance  


SQL 2008 R2 Cluster unattended setup on Windows Server 2003

All the Docs on setup parameters state that the default for FILESTREAMLEVEL is 0 (filestream disabled) however whether it is defaulted or supplied as 0 the setup fails during installation because KB937444 is not applied to W2K3. Presumably this is because even if the filestream is disabled the software is still installed. But if this is a Pre Requisite why is this not validated at the start??

New Windows 7 compuer with SQL Server 2008 Express - permission issues


I avoided Vista because of the overbearing security issues but I put Windows 7 Ultimate on my new computer. I really like it so far except for 2 big issues. I won’t go into VPN nightmare I’m having here but the other is that for the first time ever I’m having lots of SQL Server permission issues. I’m running Windows 7 Ultimate, I run SSMS as an administrator how can I get full rights on my SQL Server as I had in XP where I could create files anywhere?

The first issue I had was that I couldn’t install the AdventureWorkLT DB because I didn’t have create permissions (that is bizarre default) but I got around that by granting Full Control to the Data folder.

Now I’m having another problem that I cannot solve. I cannot even export a SQL Query to a file. I get an “unrecoverable error” popup. Here is what is in event viewer but if click the link in event viewer the suggestions of how to fix it does not work.

Error 1935 When Installing SQL Server 2008 Express on Windows 7 64 bit

I need to install SQL Server 2008 Express on Windows 7 x64 but keep failing. I've searched and tried so many method listed on many forums to no avail. Please kindly help.

These are the error message that I was getting:

Error 1935. An error occurred during the installation of assembly
'Microsoft.VC90.ATL,version="9.0.21022.8",publicKey Token="1fc8b3b9a1e18e3b",processorArchitecture="x86", type="win32". Please refer to Help and Suppoer for more information. HRESULT: 0x8007054F.


An error occurred during the installation of assembly
'Microsoft.VC80.CRT,version="8.0.50727.1801",publicKey Token="1fc8b3b9a1e18e3b",processorArchitecture="amd64", type="win32". Please refer to Help and Suppoer for more information.

Additional information:
- OS: Microsoft Windows 7 Professional Edition 64bit
- I have no other SQL instances present on every install (I always uninstall it first and clean up the residue files on C:\Program files (and the x86 one)\Microsoft SQL Server\)
- I have Visual Studio Express 2010 installed
- I fundamentally require only SQL Server service and SQL Server Management Studio, but I've tried all installer on the Microsoft website just in case one is working.

This are the files that I'

sql server 2008 r2 express and windows features


For some of the ASP.NET features to work with SQL Server 2005 some "Windows Features" had to be turned on (list below). My question is this the same for SQL Server 2008 Express SP1 and SQL Server Express R2?

Features: ( Common HTTP Features) - Static Content; Default Document; Http redirection; Directory browsing. ( Application development) - ASP.NET; ISAPI Extension; ISAPI Filters. (Security) Windows Authentication. (IIS Management Tools) IIS Metabase; IIS 6 WMI.


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