View Complete Post
I can't get R2 Express (x64) installed from the command line... x86 using this same command line works fine, just x64 is broken.
/q /ACTION=Install /SECURITYMODE=SQL /SAPWD="MyStrongPassword" /INSTANCENAME="SQLEXPRESS" /FEATURES=SQLEngine,Replication,SDK /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="MyComputerName\MyUserName"
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
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.
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,
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
'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 ?
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.
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.
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
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
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 ?
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?
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 : 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!