Failed To Reinstall SQL 2005 Express After Removing It Manually
Nov 30, 2007
got problem with uninstallin sql so i ended both sql exe files in Services and Progresses
then removed c:program filsmicrosoft sql server manually and some keys about sql in registry
when i reinstall,
no problem with
SQL setup support files
SQL Native Client
SQL VVS writer
couldnt pass thru the "SQL Server Database Services" Installation
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server æœ?åŠ¡æ— æ³•å?¯åŠ¨ã€‚有关详细信æ?¯ï¼Œè¯·å?‚阅 SQL Server è?”机丛书ä¸çš„主题€œå¦‚何查看 SQL Server 2005 安装日志文件€?å’Œ€œæ‰‹åŠ¨å?¯åŠ¨ SQL Server€?。
( SQL server services fail to start. For more information ... blah blah blah and Start SQL server manually )
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlShutDownRANUInstance%40sqls%3a%3aService%3a%3aStart%40x422
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
when i goto SQL server Configuration Manager, it says:
MMC could not create the snap-in
CLSID: {CA9F8727-31DF-41D2-975C-887D84903967}
Since there is not a method to uninstall SP2 for SQL Server 2005 Express, it is recommended to completely uninstall and then reinstall. I have backed up all databases as well as generated a script to recover username/passwords, is there anything else I should be taking into consideration?
I had SQL Server 2005 Express installed on my computer, but was having problems with it interacting with Visual c++ 2005 Express Edition. I uninstalled both items, but now cannot get SQL Server to reinstall. Everything works fine until the installation gets to the "SQL Server Database Services" portion. At that point, I get a failure stating, "The SQL Server service failed to start. For more information see the SQL Server Books Online topics, 'How To: View SQL Server 2005 Setup Log Files' and 'Starting SQL Server Manually'." Behind this modal dialog box, in the install window, it seems to have stopped at "Running action to shutdown instance(Run As Normal User) RANU instance shutdown in progress: MSSQL$SQLEXPRESS"I have tried everything I can find online about this, including use of the Windows Install Clean Up, Aaron Stebner's blog about how to remove a beta version (http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx), Ttools, and the Visual Studio Uninstall program. I have manually deleted the folder for SQL Server from my Program Files folder, I have deleted all mention of the program from my registry, and yet I still cannot get the darned thing to reinstall. My computer is a Pentium Duo-Core 2 6600, running at 2.4 GHz, with 2GB RAM, 129GB of 279GB hard drive space free , with an NVIDIA GeForce 7600 GS video card. As I say, I had the program running, it just won't reinstall. I am logged on as the one and only user, and I have Administrator priveleges. There have been no changes to the PC aside from removing and trying to reinstall the C++ and SQL Server programs. Can anyone give guidance as to what the heck is going on and what to do?? The haed and tail of my error log is below. I am stuck. Thank you.
Regards,
Andy
=== Verbose logging started: 11/1/2007 11:16:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (1C:1C) [11:16:13:234]: Resetting cached policy values MSI (c) (1C:1C) [11:16:13:234]: Machine policy value 'Debug' is 0 MSI (c) (1C:1C) [11:16:13:234]: ******* RunEngine: ******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (c) (1C:1C) [11:16:13:234]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (1C:1C) [11:16:13:234]: Grabbed execution mutex. MSI (c) (1C:1C) [11:16:13:250]: Cloaking enabled. MSI (c) (1C:1C) [11:16:13:250]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (1C:1C) [11:16:13:250]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (DC:EC) [11:16:13:250]: Grabbed execution mutex. MSI (s) (DC:F0) [11:16:13:250]: Resetting cached policy values MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'Debug' is 0 MSI (s) (DC:F0) [11:16:13:250]: ******* RunEngine: ******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'TransformsSecure' is 0 MSI (s) (DC:F0) [11:16:13:250]: User policy value 'TransformsAtSource' is 0 MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (DC:F0) [11:16:13:250]: File will have security applied from OpCode. MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:e02e41a11dc741be12SetupSqlRun_SQL.msi' against software restriction policy MSI (s) (DC:F0) [11:16:15:781]: Note: 1: 2262 2: DigitalSignature 3: -2147287038 MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is not digitally signed MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (DC:F0) [11:16:15:781]: End dialog not enabled MSI (s) (DC:F0) [11:16:15:781]: Original package ==> c:e02e41a11dc741be12SetupSqlRun_SQL.msi MSI (s) (DC:F0) [11:16:15:781]: Package we're running from ==> c:WINDOWSInstaller46c82d.msi MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2B2EF9D0-3876-4021-8F44-FA294E6D3C36}'. MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (DC:F0) [11:16:15:828]: Detected that this product uses a multiple instance transform. MSI (s) (DC:F0) [11:16:15:828]: MSCOREE already loaded, using loaded copy MSI (s) (DC:F0) [11:16:15:828]: Applying multiple instance transform 'qlRun01.mst'... MSI (s) (DC:F0) [11:16:15:828]: Looking for storage transform: SqlRun01.mst MSI (s) (DC:F0) [11:16:15:828]: Validating transform 'SqlRun01.mst' with validation bits 0x809 MSI (s) (DC:F0) [11:16:15:828]: Transform 'SqlRun01.mst' is valid. . . . Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = c:Program FilesMicrosoft SQL Server90COMResources1033 Property(S): SqlInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): SqlTarget.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server Property(S): SqlInstanceBin.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn Property(S): Data.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server Property(S): DataInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C Property(S): SqlFullTextDefaultPath = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = ANDYSSQLServer2005MSFTEUser$ANDYS$SQLEXPRESS Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1 Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSearch Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1MSSQL Property(S): FTEStartupType = 0 Property(S): FTEStatus = 3 Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.1 Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQLEXPRESS Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90COM Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90 Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1 Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90 Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90 Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program Files Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS:c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLEXPRESS Property(S): CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYNetworkService Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1 Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0 Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0 Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0 Property(S): CostingComplete = 1 Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1 Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C} Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C} Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030} Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030} Property(S): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS Property(S): OutOfDiskSpace = 0 Property(S): OutOfNoRbDiskSpace = 0 Property(S): PrimaryVolumeSpaceAvailable = 0 Property(S): PrimaryVolumeSpaceRequired = 0 Property(S): PrimaryVolumeSpaceRemaining = 0 Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS Property(S): SqlActionManaged = 3 Property(S): SqlNamedInstance = 1 Property(S): SqlStateManaged = 2 Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS Property(S): SOURCEDIR = c:e02e41a11dc741be12Setup Property(S): SourcedirProduct = {B0F9497C-52B4-4686-8E73-74D866BBDF59} Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {04F4B2AC-58A6-4ADD-98ED-84973C96062A} Property(S): ProductToBeRegistered = 1 MSI (s) (DC:F0) [11:19:42:109]: Note: 1: 1708 MSI (s) (DC:F0) [11:19:42:109]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (DC:F0) [11:19:42:125]: Cleaning up uninstalled install packages, if any exist MSI (s) (DC:F0) [11:19:42:125]: MainEngineThread is returning 1603 MSI (s) (DC:EC) [11:19:42:125]: Destroying RemoteAPI object. MSI (s) (DC:38) [11:19:42:140]: Custom Action Manager thread ending. === Logging stopped: 11/1/2007 11:19:42 === MSI (c) (1C:1C) [11:19:42:140]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (1C:1C) [11:19:42:140]: MainEngineThread is returning 1603 === Verbose logging stopped: 11/1/2007 11:19:42 ===
Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express?
I read on MSDN how to manually uninstall the instance of SQL server 2005 express, however i am not sure that it will remove the service. The reason i need to do this is that an application i have installed SQL Server 2005, and also QPulse5 SQL Server. I have two instances and it is giving me compile issues which i believe is related to having both services. I did add/remove programs and reinstalled just SQL Server 2005 and recieved error message saying that the service failed to start. The whole problem of this occured when we ran DCPromo with SQL installed. After we did we relized you could not promote with SQL Server. I understand that it is not recommended running SQL Server on a DC, however we did not have a choice. I am hoping someone here may have a solution for this. If there is any other information you need just let me know. Thanks
Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.
Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.
Any ideas on how to break the chain here are welcome.
Hi,I just unistalled Sql Management Express and now I want to install it again but the installer says the product is already installed,Can somebody help me with this
hi guys, i am very happy that i found this forum which discuss ASP.net.i am new to ASP.net 2.0 and some need serious help. when i debug my application and try to insert data an error occur saying:"Cannot open database "ecb" requested by the login. The login failed. Login failed for user 'HOME-USERuser'."the code that i have used to submit data is as follow:Imports System.Data.SqlClient... Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim objConn As SqlConnection Dim objCmd As SqlCommand objconn = New SqlConnection("data source= localhostsqlexpress; initial catalog =ecb; persist security info =true; trusted_connection=true") objCmd = New SqlCommand("INSERT INTO staff (firstname, surname) VALUES (@firstname, @surname,)", objConn)objCmd.Parameters.Add("@FirstName", Data.SqlDbType.VarChar).Value = txtFirstName.TextobjCmd.Parameters.Add("@Surname", Data.SqlDbType.VarChar).Value = txtSurname.TextobjConn.Open()objCmd.ExecuteNonQuery()objConn.Close() i also used this data connection but didn't help: objconn = New SqlConnection("Server=localhost; Database=ecb;user ID=' ';Password=' ' ") when i use this data connection i get this message: Login failed for user ''. The user is not associated with a trusted SQL Server connection. as far as i can remember i have used windows authentication when creating my database in sql server 200 express edition. the funny thing is that when i use datagrid wizard or dataform the connection is fine ( i mean is automatically done for me but i don't know when i like to do it manually does not work).can anyone help? thank you in advanced
We are deploying an application using SQL Server Express to a wide variety of desktop and laptop machines. We are currently trying to decide whether we should install the SQL Server instance service to start automatically at startup or not. In the latter case, our application would start and stop the service.
Starting automatically will make our app load more quickly, which is important to our users. However, our support team is concerned that leaving the service running will leave our databases vulnerable to becoming "suspect" if, for example, a laptop user's battery dies suddenly. Of course this will always be a problem if the app is running, but our support team believes that having the service running all the time will increase the chances of this happening. One reason for their concern is that an older version of the software used MSDE which was running all the time, and they saw a good number of suspect database issues.
What is the best practice for leaving the service running, especially when there are a lot of laptop users?
I am moving my data base from one computer to a new one. I placed the .bak file in the backup folder on the new computer (Windows Vista). I keep getting these errors I have checked the security settings and my user account has full privledges. I added my windows login to the SQL Administrators as well.
Here is the error msg.: TITLE: Microsoft SQL Server Management Studio Express ------------------------------
Restore failed for Server 'laptopsqlexpress'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLPRM - 6009757.mdf'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------ What am I missing?
I have installed a sample from the web and put it in my localhost inetpub folder, then i open up my SQL Server 2005 Express to attach the database from the App_Data directory, it throws an error below:
errors occur in both window and sql authentication login. Error: Attach database failed for Server '...SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) Additional Information An exception occcured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) Directory lookup for the file "C:Documents and SettingsmirtariqMy DocumentsWorksStarterKitVSI smallbusiness_csApp_DataSmallCompanyDB_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).(Microsoft SQL Server, Error:5133)
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
i get the above error when attepting to install reporting services
When i try to install, the filed are extracted and then i get this error message:
SQL Server Setup unexpectedly failed. For more information, review the Setup summery log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
I open the file and this is all i get:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional
Service Pack 2 (Build 2600) Time : Mon Apr 02 15:31:10 2007
I looked in this forum at others peoples threads and it seems as if they all have a lot larger Summary.txt file. I never had any other verson of SQL Server installed on this computer and i just uninstalled .net 2.0 framework and reinstalled it.
My computer runs Windows XP Pro with SP 2, AMD Athlon 64 Processor 3500+ 2.20 GHz, 1.00GB of RAM.
Anyone have any clue why the installation wont even start?
This is my 10th attempt. I've uninstalled all the .net components and then reinstalled .net 2.0 and then various versions of SQL Server 2005 Express. Here's what all 10 error logs said:
Microsoft SQL Server 2005 Setup beginning at Sun Mar 16 18:26:46 2008 Process ID : 3808 c:fc0a616bb7e15d80b498fce92asetup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2008/2/16 18:26:45 Complete: LoadResourcesAction at: 2008/2/16 18:26:45, returned true Running: ParseBootstrapOptionsAction at: 2008/2/16 18:26:45 Loaded DLL:c:fc0a616bb7e15d80b498fce92axmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2008/2/16 18:26:46, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Wed Jun 14 16:28:04 2006 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50 2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3808"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2008/2/16 18:26:46 Complete: ValidateWinNTAction at: 2008/2/16 18:26:46, returned true Running: ValidateMinOSAction at: 2008/2/16 18:26:46 Complete: ValidateMinOSAction at: 2008/2/16 18:26:46, returned true Running: PerformSCCAction at: 2008/2/16 18:26:46 Complete: PerformSCCAction at: 2008/2/16 18:26:46, returned true Running: ActivateLoggingAction at: 2008/2/16 18:26:46 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00DFCFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "3808"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
I'm a student and need this to work for projects. Any help will be greatly appreciated.
I followed the steps outlined in a blog I found to setup SS2005 express for remote connections. Everything appeared to go smooth until I actually tried to logon ;)
I have Sql Server 2005 Express installed on my WinXP PRO machine at home (no domain). I have opened the ports on the firewall, etc.
When I try and login from the SQLCMD command line tool I get a Login Failed error. Here is the connection string that I'm trying to use: SQLCMD -S **.***.**.*SQLEXPRESS -U Steve -P MyPassword
The error: Login failed for user 'Steve'.
When I use Management Studio Express on the same machine running Sql Server, it shows the User name: NEVERSTILLSteve
'NEVERSTILL' is the name of my computer.
If I try and use that same username with a remote connection I get the same error.
I have googled for the error and msg code, but nothing fitting my situation is coming up.
Hi, I am trying to install Outlook 2007 and business contact manager which requiers SQL Server 2005 Express Edition. I did install the Outlook but When it want to install the SQL server for business contact manager it fails to install. It installs the SQL native after that when it wants to install the SQL 2005 it fails here is the error:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information.
I have .NET Framework 2.0 and Visual studio 2005 installed on my machine. I also have SQL Server 2000 Developer Edition installed with Service Pack 4.
When I try to install SQL Server 2005 express, I get an error when the setup tries to install SQL Native Client. I have read many forums, but couldnt find a resolution. I can not see SQL Native Client in my Add Remove Programs either.
I tried to unzip the SQLEXPR.exe into a temp folder and when I right click sqlncli.msi and say Repair or Uninstall. It says "This action is valid for products that are currently installed."
When i try to run the sqlncli.msi file ..i get an error message saying "Installation of Microsoft SQL Server Native Client failed because a higher version already exisits on the machine. To proceed uninstall the higher version and then run Microsoft SQL Server Native Client Setup"
Please help as I am unable to install SQL Server 2005 Express.... SQL Server Native Client -- Set up failed SQL VSS Writer -- Set up failed Database Services -- Set up failed
Thank you in advance
Log mesg -==
Verbose logging started: 12/17/2007 23:18:36 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (74:B4) [23:18:36:828]: Resetting cached policy values MSI (c) (74:B4) [23:18:36:828]: Machine policy value 'Debug' is 0 MSI (c) (74:B4) [23:18:36:828]: ******* RunEngine: ******* Product: {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} ******* Action: ******* CommandLine: ********** MSI (c) (74:B4) [23:18:36:828]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (74:B4) [23:18:36:828]: Grabbed execution mutex. MSI (c) (74:B4) [23:18:36:828]: Cloaking enabled. MSI (c) (74:B4) [23:18:36:828]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (74:B4) [23:18:36:828]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (100) [23:18:36:828]: Grabbed execution mutex. MSI (s) (10:E0) [23:18:36:843]: Resetting cached policy values MSI (s) (10:E0) [23:18:36:843]: Machine policy value 'Debug' is 0 MSI (s) (10:E0) [23:18:36:843]: ******* RunEngine: ******* Product: {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} ******* Action: ******* CommandLine: ********** MSI (s) (10:E0) [23:18:36:843]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (10:E0) [23:18:36:843]: User policy value 'SearchOrder' is 'nmu' MSI (s) (10:E0) [23:18:36:843]: User policy value 'DisableMedia' is 0 MSI (s) (10:E0) [23:18:36:843]: Machine policy value 'AllowLockdownMedia' is 0 MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Media enabled only if package is safe. MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Looking for sourcelist for product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Adding {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}; to potential sourcelist list (pcode;disk;relpath). MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Now checking product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Media is enabled for product. MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Attempting to use LastUsedSource from source list. MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Processing net source list. MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Processing media source list. MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Trying media source G:. MSI (s) (10:E0) [23:18:36:843]: Note: 1: 2203 2: G:sqlncli.msi 3: -2147287038 MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Source is invalid due to missing/inaccessible package. MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Processing URL source list. MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1402 2: UNKNOWNURL 3: 2 MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: 3: sqlncli.msi MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Failed to resolve source MSI (s) (10:E0) [23:18:36:843]: MainEngineThread is returning 1612 MSI (c) (74:B4) [23:18:36:859]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (74:B4) [23:18:36:859]: MainEngineThread is returning 1612 === Verbose logging stopped: 12/17/2007 23:18:36 ===
I get the following message after updating to sql server express 2005 advanced. Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I noticed that in my C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Data I have not databases? How do I get them back?
I also had to add back the aspnet to the permissions and the network and network service to the app_data folder.
After i reinstall SQL Server 2005 Express on my local machine, and then tried to attach AdventureWorks_Data.mdf into Database, it gives me the following error: Mark up:
I tried to reinstall the Adventureworks.msi installer and reattach again in SQL Server 2005 Express, it gave me the same error. I then deleted both SQL Server 2005 Express & Adventureworks, and then restart my pc and reinstall again, it still gave me the same error. Error: Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional Information: An Exception occurred while executing a Transact-SQL Statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL.1DataAdventureWorks_Data.mdf' (Microsoft SQL Server, Error:5123)
Previously, I have installed SQL 2005 developer edition simplyfied chinese successfully. But yesterday, I tried to install mobile client software factory. The installation process create a database as following: Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY ( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) ( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory. My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem. The OS of my notebook is XP professional, which is upgraded from XP home edition. I login it using a domain user such as: "my company's domainmyaccount". I found it curiously that although I assign myaccount as an Administrator, it will automaticly changed to "SQL$...." account. I don't know why and when the account property is changed. But everytime, when I found, I will assign myaccount as an Administrator back.
3, Performance Monitor Counter registry key problem. To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed. When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly. I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib, the result is: "Last Counter"=dword:0000149c (11128) "Last Help"=dword:0000149d (11129) Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09 and 004, the result is confusing. I can find counter and help key,but both keys contains really a lot of stuff as: (1) first page of Counter key: 1 1847 2 System 4 Memory 6 % Processor Time 10 File Read Operations/sec 12 (2) first page of Help key: 3 The System performance object consists of counters that apply to more than one instance of a component processors on the computer. 5 The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes. 7 % Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%. 9 % Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time. 11 File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as: "Last Counter"=dword:0000149c (5276) "Last Help"=dword:0000149d (5277) But it also doesn't work.
I had to do a system restore to solve some other issues now my SQL Server 2005 doesnt work (SQL Server 2000 on the same machine [diffrent instance] does). I have tried to uninstall with add/remove programs but the instance doesnt appear there. I have tried to use the 'ARPWrapper.exe /Remove' command as described in KB909967 wich also fails. I have also tried to reinstall with no sucess. I also tried uninstalling SQL2000 and removing as many references as I could find, again now joy.
Is there a script somewhere to remove everything (although I would like to try and keep the SQL2000 instance)?
Previously, I have installed SQL 2005 developer edition simplyfied chinese successfully. But yesterday, I tried to install mobile client software factory. The installation process create a database as following: Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY ( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) ( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) But today, when I start my notebook, SQL server could not be started.
Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch error occures. I tried to fix it but failed. The problem is as following:
1, The installation process report a warning of low memory. My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that time, the warning also shows, but it seems that this warning does not affect installation.
2, User type problem. The OS of my notebook is XP professional, which is upgraded from XP home edition. I login it using a domain user such as: "my company's domainmyaccount". I found it curiously that although I assign myaccount as an Administrator, it will automaticly changed to "SQL$...." account. I don't know why and when the account property is changed. But everytime, when I found, I will assign myaccount as an Administrator back.
3, Performance Monitor Counter registry key problem. To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed. When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly. I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib, the result is: "Last Counter"=dword:0000149c (11128) "Last Help"=dword:0000149d (11129) Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09 and 004, the result is confusing. I can find counter and help key,but both keys contains really a lot of stuff as: (1) first page of Counter key: 1 1847 2 System 4 Memory 6 % Processor Time 10 File Read Operations/sec 12 (2) first page of Help key: 3 The System performance object consists of counters that apply to more than one instance of a component processors on the computer. 5 The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes. 7 % Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%. 9 % Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time. 11 File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
I could not find the maximum value of the Counter key and help key, so I could not repair Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to maximum value of the Counter key and help key?
I tried to correct Last Counter and Help key as: "Last Counter"=dword:0000149c (5276) "Last Help"=dword:0000149d (5277) But it also doesn't work.
Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should.
Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0.
Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either.
I installed, uninstalled, deleted, editted my registry etc and I finally goto to this error while trying to install VS2005 (released) on a Windows 2000 PC (that had Beta2 and RC1 installed & uninstalled):
I have tried to install Outlook 2007 with BCM and recieve the error listed above. I have also included a copy of my log file. Any suggestions?
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Thu Aug 23 14:22:59 2007
Machine : MACBOOK Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MACBOOK Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : MACBOOK Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MACBOOK Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_MSXML6_1.log Error Number : 1603 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I've got a Windows Server 2003 for Small Business Server. It had got SQL installed. But then SQL was uninstalled. Now I need to put SQL back in, but I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?
Unfortunately I recived an error stating the "Installation package for the product SQL Server 2005 (64bit) cannto be found. Please locate a valid SQLRUN_SQL.MSI". Which I couldn't find anywhere., so....
I created a fresh instance on my 2005 server, held back on installing SP1, and ran the command line again. This time it worked.
My best guess is that the installation scripts check the version header on the MSI file during install and display a compatibilty error thus halting the install.
My question is, has anyone seen, overcome this problem. I can't believe that this is a bug like error as there would be posts about it all over the interweb.... which there isn't.
Any thoughts.
Mike.
(p.s) I know that I shouldn't really try to amend the collation on a sql server, but I have little choice at the moment :-(
I built an app, works fine. Had the development environment working fine (VS2005 (SP0) and SQL Server Express). It had been stable for months, no problem.
Then I had to reinstall XP Pro...(finally threw too many conflicting programs into it, I guess...)
I managed to get VS2005 reinstalled ok. However, when I opened and compiled my existing app in VS2005, using Cassini, I got the dreaded error:
An attempt to attach an auto-named database for file <file string> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I also get this error for the compiled copy of the app on the same machine, running on IIS. (Where it also previously worked fine).
I appreciate that there are zillions of posts on this issue. I'm hoping that someone might know why this should happen in this particular case.
The thing that's different about this case is that the app was working fine; I have the app deployed on a demo machine and also on a remote server as well as on the development machine.
The only thing that changed is that there was this fresh install of SQL Server Express.
I tried using >> sp_configure user instances enabled','1';RECONFIGURE <<< in SSMSEE, which took, but didn't help.
So something is different in SSE. Since the app is stable everywhere else, I REALLY don't want to go through and adjust the connection strings...MUCH better to figure out what SSE needs to be happy with the existing connection strings...as it was before.
Any suggestions would be appreciated.
Thanks!
EDIT----TRIED SOME THINGS:
Changed folder and file permissions to allow ASPNET full access to the .mdf's and log files (though never had to do this before on the development machine.) No change...
Can see the table contents within the .mdf through SSMSE, and also through Server Explorer in VS2005.
So because the problem happens with both IIS and Cassini, I'm assuming it's got to be an issue between ASPNET and SSE.
EDIT --- TRIED SOME MORE THINGS:
I dimly remember that when I had this problem before, it was that the error message was too "dumb". It wasn't my file that had the permissions problems, it was that the SSE System Databases had to have permissions with respect to ASPNET.
I tried to set that up but I'm a complete newb on this area, so I don't know if I did it right. In SSMSE I created a Login for MyComputer/ASPNET, and gave it all permissions and roles, and then made it an owner for the four system databases...but no joy.
Any pointers on this last piece would be helpful.
EDIT - MORE INFO
The error details
[SqlException (0x80131904): An attempt to attach an auto-named database for file <filestring>.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
Using SQL Express, UNDER COMPUTER management, SQL Server Configuraqtion Manager, SQL Server 2005 Network configuration Ihave the following listed instances
CSOLUTION - not listed under services
MSSQLSERVER - Disabled
SQLEXPRESS - Diaabled
SQLTEST - Disabled
SQLEXPRESSDATA - used by VB05 program
Questions
a) how do I delete all the instancces I do not use. In MSDE, each instance could be removed via the add/remove programs, but I don't see how to remove it under express
b) since SQLEXPRESS is the default for an SQL Express installation, I would like for the VBB05 program to use that instance; how do I do that?
I installed SQL Server Express trail for 3 times each with new instance. Now I came to know that I need to have a default instance. I un-installed the SQL Server Express and tried to install it again. It still says I have installed instances and if I select default instance the option buttons are un-checked and disabled. I tried to delete all the folders related to the SQL Server installationa dn tried but still I see the same thing. Please help me in istalling the default instance.
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqlservicetart Source Line Number: 301
Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqlservicetart Source Line Number: 301