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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

SQL Server 2008 Express Edition: What is the difference between R2 and SP2?

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

Hi,

  I received last week a notice about the expiration period of SQL Server 2008 R2.  I honestly got surprised considering that I installed the Express Edition.

  This week, I noticed an article announcing the coming out of SQL Server 2008 SP2.  This really caught my attention. 

A few questions:

1- Is R2 a release candidate version of SQL Server 2008 Express?

2- If so, how can I uninstall it from the moment SP2 is available for download.  Must I use the original setup program I used for install?

3- Actually I'm using SQL Server 2008 R2 Express Edition with Advanced Services.  What is the equivalent for the SP2 version.  Where can I find it for download?

Thanks for helping,

Stéphane




View Complete Post


More Related Resource Links

Probem after installing SQL server 2008 R2 express edition

  
Hi, I tried to install SQL server 2008 R2 express edition, but there were many error, So I can't now create sdf files in VS , here is the repporte that was created : Overall summary:   Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.   Exit code (Decimal):           -2068119551   Exit facility code:            1211   Exit error code:               1   Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.   Start time:                    2010-09-03 11:36:31   End time:                      2010-09-03 19:37:53   Requested actio

How to connect visual web developer 2008 express edition to SQL server 2008 ??

  
i know its a basic question guys! please help me . i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database ... How do i do it .....I can see some grt genius out there, i am sure some one is kind enough to help me with this question !!! thank you .....................................

Installation of sql server express edition-2008

  
Dear All, When i am installing sql server express edtion -2008  i choosed default instance to install bt at the window where we choose login account and password for reporting services and database engin it shows error ...........there i have got three account ..... i have tried all these three accounts but when i login through SSMS it doesnt allow and shows error  please suggest me which account i should select and password for that............   Thanks and Regards Shivesh

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

MOSS 2007 Standard installation with SQL Server 2008 EXPRESS Edition server

  
Hello I have installed MOSS 2007 with SQL Server 2008 Express edition. Can anyone tell me what all features will be missing when compared this setup to MOSS 2007 Stanadard with SQL server 2008 lisenced editon? Specifically will I not be getting forms services with "MOSS 2007 with SQL Server 2008 EXPRESS edition"? Thanks in advance.

Can't install SQL Server 2008 R2 Express Edition x64 from Command Line

  

I can't get R2 Express (x64) installed from the command line... x86 using this same command line works fine, just x64 is broken.

Using this:

/q /ACTION=Install /SECURITYMODE=SQL /SAPWD="MyStrongPassword" /INSTANCENAME="SQLEXPRESS" /FEATURES=SQLEngine,Replication,SDK /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="MyComputerName\MyUserName" /IAcceptSQLServerLicenseTerms=TRUE

Everytime it fails with:

2010-09-19 15:30:48 SQLEngine: : Checking Engine checkpoint 'ConfigureServiceBroker'
2010-09-19 15:30:48 Slp: --SafeSqlCommand: ALTER DATABASE tempdb SET NEW_BROKER ALTER DATABASE msdb SET NEW_BROKER
2010-09-19 15:30:48 Slp: Sco: SqlException: Message:The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Onlin

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.

 

Kevin

 


SQL 2008 SP1 - Log shipping solution with Logshipping monitor on SQL Server Express Edition SP1 (bad

  

Hello All !

I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS  as a monitor server:

'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance.  A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'

In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?


Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

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.

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

  

Hi

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.


Amit

INSTALLATION ERROR SQL SERVER 2008 SP2 EXPRESS EDITION ON WINDOW 7 PROFESSIONAL

  

Can anyone suggest what could be the reason of installation error- access is denied

while installing sql server 2008 sp2 express edition on my window 7 professional machine as a domain administrator.

I tried installing as a local administrator also but it gives the same errror.


Can't connect to local SQL Server 2008 Express edition

  

Hi. I'm on Win7 64 bit and have installed SQL 2008 Express 64 bit. The named instance is "sqlexpress" but when using the SQL Server Management Studio 2005, it won't let me connect. It doesn't see it. When I type in the name and try to connect via windows auth (having added myself as an admin account), it gives this error:

 

===================================

Cannot connect to sqlexpress.

===================================

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
Error Number: 53
Severity: 20
State: 0


------------------------------
Program Location:

 at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
 at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, S

INSTALLATION ERROR SQL SERVER 2008 SP2 EXPRESS EDITION ON WINDOW 7 PROFESSIONAL.

  
Window 7 allowed me to install the SQL Server 2008 express only as a "domain Administrator".

I could not installed it with any other admin account including Loacal Administrator. Is there any UAC problem with widow 7/SQL server 2008.

The same problem i faced when i was installing "Sql 2008 R2 standard" on window 2008 Server.

Can onyone respond to this ?

Randhir

Randhir

High Availability in SQL Server 2008 Express edition

  

Dear friends ,

I am using SQL Server 2008 Express edition in my laptop ,I would like to do high availability samples such as Replication,Mirroring,and Log shipping in my laptop , i have two instances .is it possible to do samples (replication,mirroring,log shipping) plz guid me how to do.

 

thanks in advance

 


Is SQL Server 2008 Express edition provide XMLA support?

  

Hi There,

Is SQL Server 2008 Express edition provide XMLA support? 

-Suriya


sunmoon_1411

Trouble importing .dbf file into SQL server 2008 express edition

  

Hey all,

I'm having trouble exporting my .dbf file into Microsoft SQL server 2008 express edition. I set up an ODBC using a couple different drivers and different versions of the drivers and still got the same error. Below is the error message I am receiving.

 

TITLE: SQL Server Import and Export Wizard
------------------------------

Could not connect source component.

Error 0xc02020ff: Source - HOSPSITE [1]: The component "Source - HOSPSITE" (1) was unable to retrieve column information for the SQL command. The following error occurred: ERROR [HYS12] [Microsoft][ODBC dBase Driver] Index file not found.


------------------------------
ADDITIONAL INFORMATION:

Pipeline component has returned HRESULT error code 0xC02020FF from a method call. (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
BUTTONS:

OK
------------------------------

If any one can help that would be greatly appreciated! Thanks!


Does Sync Center support for SQL Server 2008 R2 Express Edition pull merge subscription?

  

Hi,

I have create a subscription (pull, merge replication) on SQL Server 2008 R2 Express Edition to a publication on SQL Server 2008 R2 Enterprise Edition. I have seen that the subscription has been enabled for Windows Sychronization Manager as I can see in its property dialog. However, I cannot see it in the Sync Center of Windows 7 on the Subscriber.

Does Sync Center support in this scenario? From another thread, it seems we need to use Windows Task Manager. If so, how can I set it up?

Thanks in advance.


Please mark replies as helpful or answers if they are helful, doing so can help others encountering the similar issue.
Categories: 
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