How can I install SQL Server 2000 Developer edition from the CD's of Visual Studio.Net 2000 Enterprise Architect ?
When I install VS.Net Enterprise Architect I do not see any install option for SQL Server 2000 Developer, though the MSDE option does appear during the installation. However, I was not interested in MSDE.
I am having some problems in the process of moving an Access back-endto an SQL Server back-end. Everything works but there are severeproblems of response times when the number of users builds up.At present we are using the Developer version before committing to theEnterprise version. BOL (quoted below) seems to suggest that, apartfrom licensing, they are the same.Can anyone please confirm that this is so. If not, what is thedifference?I may explain in another topic the problems I am facing but I firstwish to be clear on this particular question.---------------------------------------------------------------------------------------------------------------Quote from BOLMicrosoft® SQL Server™ 2000 is available in these editions:SQL Server 2000 Enterprise EditionUsed as a production database server. Supports all features availablein SQL Server 2000, and scales to the performance levels required tosupport the largest Web sites and enterprise online transactionprocessing (OLTP) and data warehousing systems.SQL Server 2000 Developer EditionUsed by programmers developing applications that use SQL Server 2000 astheir data store. Although the Developer Edition supports all thefeatures of the Enterprise Edition that allow developers to write andtest applications that can use the features, the Developer Edition islicensed for use only as a development and test system, not aproduction server.
View 5 Replies View RelatedI am currently using SQL Server Enterprise Evaluation which runs out after 6months. When this happens or even sooner I plan to install SQL Server Developer.
My questions is can I copy all the things I develop (databases, cubes, reports,) from enterprise evaluation & import/load them into SQL Developer with no problems? Will everything integrate? Is there any implications?
Hi,Is it possible to install Enterprise Manager without to install theserver ?Thanks !--J-L M. (Alphomega)ICQ: 149635116Pour m'écrire, cliquer le lien ci-dessoushttp://cerbermail.com/?G5iYdBb2Ce
View 3 Replies View RelatedI have read the system requirement readme file and found that we can install the SQL Server 2005 on Developer mode. I Have SQL Server 2005 Enterprise but inside the setup directory i found sqlrun_DTS.msi, is this installer for developer ? Well if so then here is the problem when i try to install.
View 2 Replies View RelatedI copied the error I received.
View 4 Replies View RelatedI successfully installed .NET framework v 3.5 and VWD 2008 on a new Vista laptop. When I want to add a Sql Server database to a website, errors tell me to install SS 2005 Express. MSDN SS 2005 Express download tells me I MUST first install .NET framework v 2.0 before SS 2005. When I try to install framework v 2.0, I'm sent to v. 3.5 and no way to download SS 2005.
How does one install a express sql server to run with Visual Web Developer 2008?
I'm trying to install SQL Server 2005 (Developer edition) on my Vista Ultimate machine.
I've got the IIS 7 features turned on; I've got the SP2 patch CD; and I've run every install as administrator. I've run the SQL Server setup before and after the SP2 patch
I'm doing a named instance using the built-in system account with windows authentication mode.
Is there any COMPLETE guide as to how to work through all these installation problems?
I've gotten same results after about six attempts.
These always install:
SQL Setup Support Files
SQL Native Client
SQL VSS Writer
SQL Server Backward Compatibility Files
SQLXML4
SQL Server Books Online
These always fail:
OCW11
SQL Server Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation Components; Books Online
I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation."
This is the bottom of the SQLSetup0001_<machine name>_SQL.log
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:33:07 2006
<Func Name='InstallMOF'>
Failed to compile file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text: Source File Name: sqlcasqlmofca.cpp
Compiler Timestamp: Tue Aug 9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
MSI (s) (40!00) [14:40:59:034]: Product: Microsoft SQL Server 2005 -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Fri Jan 27 14:40:59 2006
<Func Name='InstallMOF'>
Failed to compile file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof.
An error occured while processing item 1 defined on lines 16 - 18
Error occured in phase 3, Error number: 0x80041001
Compiler returned error 0x80041001
<EndFunc Name='InstallMOF' Return='-2147217407' GetLastError='183'>
Error Code: 0x80077349 (29513)
Windows Error Text: Source File Name: sqlcasqlmofca.cpp
Compiler Timestamp: Tue Aug 9 01:14:18 2005
Function Name: Do_sqlMofcomp
Source Line Number: 608
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29513
I'm at a complete loss, but I am sure the error is something about the configuration with this computer. I have fond a couple of posts on other web sites where people have similar errors, but no feedback on the error or even ideas on what to look at.
ANY recommendations would be helpful!!
Thank you,
Jay A. Moritz
I am working on a automated install (simulated with a batch file first) and I am having issues when I trying to install SQL2005dev, then SP1 and then the hotfixes. The main issue is SP1 returns to the batch file while it is still running.
Does anyone know how to silently run SP1 and make it wait until after it is installed to continue (on to the hotfixes)?
Example batch file:
"SQLDEVSELSQL Server x86Serverssetup.exe" LOGNAME=C:setupsetup.cab /settings %temp%sqldevsel_1.ini /qb
"sp1SQLServer2005SP1-KB913090-x86-ENU.exe" /quiet /allinstances /norestart
"HotfixesSQL Server x86sql2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86as2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86dts2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86s2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86
s2005-kb918222-x86-enu.exe" /quiet
"HotfixesSQL Server x86sqltools2005-kb918222-x86-enu.exe" /quiet
I have SQL Server 2005 Developer Edition installed on XP Pro sp2 and have not been able to get OLE DB Provider for DB2 Version 1.0 with Service Pack 1 to install. After getting a notice that the install has failed, I get these log files:
=== Logging started at: 2:12:35 PM Monday, August 20, 2007 Build: 7.0.3038.0 Calling process: H:SQL2005DB2OLEDB7Setup.exe === The current user is NORTHGRUMdinsest. Computer name: DICA2ESITE13005 OS Version: 5.1 Build: 2600 Service Pack: 2.0 Suite: 256 Product Type: 1
[2:12:35 PM Info] Command Line: H:SQL2005DB2OLEDB7Setup.exe
[2:12:35 PM Info] Language: 1033
[2:12:59 PM Info] Raw module path: H:SQL2005DB2OLEDB7Setup.exe
[2:12:59 PM Info] Universal module path: H:SQL2005DB2OLEDB7Setup.exe
[2:12:59 PM Info] Current version of msi.dll is: 3.1 build: 4000 platform: 2
[2:12:59 PM Info] Raw module path: H:SQL2005DB2OLEDB7Setup.exe
[2:12:59 PM Info] Universal module path: H:SQL2005DB2OLEDB7Setup.exe === Logging stopped: 2:12:59 PM Monday, August 20, 2007 === === Logging started at: 2:13:00 PM Monday, August 20, 2007 Build: 7.0.3038.0 Calling process: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe === The current user is NORTHGRUMdinsest. Computer name: DICA2ESITE13005 OS Version: 5.1 Build: 2600 Service Pack: 2.0 Suite: 256 Product Type: 1
[2:13:00 PM Info] Command Line: H:SQL2005DB2OLEDB7Setup.exe /Relaunch /RunningFromTemp /SetupXML C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpHISDB2_x86.xml
[2:13:00 PM Info] Language: 1033
[2:13:00 PM Info]
[2:13:00 PM Info] Running prehook init function
[2:13:00 PM Info] Entering PreInitHook
[2:13:00 PM Info] Detecting Sql Server 2005 (32bit)
[2:13:00 PM Info] Enumerating Sql Server 2005 instances from SoftwareMicrosoftMicrosoft SQL ServerInstance NamesSQL
[2:13:00 PM Info] Checking SQL version and edition for: SoftwareMicrosoftMicrosoft SQL ServerMSSQL.1Setup
[2:13:00 PM Info] Got Version 9.2.3042.00
[2:13:00 PM Info] Got edition Developer Edition
[2:13:00 PM Info] Done enumerating Sql Server 2005 instances, original hr = 00000000
[2:13:00 PM Info] Done enumerating Sql Server 2005 instances, hr = 00000000
[2:13:00 PM Info] Done detecting Sql Server 2005, hr = 00000000
[2:13:00 PM Info] Detecting existing integration server installations
[2:13:00 PM Info] Integration server is not installed
[2:13:00 PM Info] Done detecting existing integration server installations, hr = 00000000
[2:13:00 PM Info] Leaving PreInitHook (hr = 00000000)
[2:13:00 PM Info] Prehook Init function returned: 0.
[2:13:00 PM Info] Prehook Init function returned the following mode: 0
[2:13:01 PM Info] Product code: {722CAF00-DE6E-4438-82DE-E664B8B6222B}
[2:13:01 PM Info] Product name: Microsoft OLE DB Provider for DB2
[2:13:01 PM Info] Product PIDSKU: BI6-00082
[2:13:01 PM Info] Product Code (MPC): 91197
[2:13:01 PM Info] OEMID:
[2:13:01 PM Info] Product is not already installed.
[2:13:01 PM Info] Successfully opened Msi package: H:SQL2005DB2OLEDB7Msix86HISDB2.msi
[2:13:01 PM Info] Raw module path: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe
[2:13:01 PM Info] Universal module path: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe
[2:13:10 PM Info] Initializing Component Updater ...
[2:13:10 PM Info] Initialized Component Updater
[2:13:10 PM Info] No updates were found on the SUS server to download.
[2:13:14 PM Info] Required platform components:
[2:13:20 PM Info] Initializing Component Updater ...
[2:13:20 PM Info] Initialized Component Updater
[2:13:20 PM Info] No updates were found on the SUS server to download.
[2:13:20 PM Info] Required platform components: (none)
[2:13:20 PM Info] MSI command line: ADDLOCAL=REQUIRED_FEATURE,OLE_DB_PROVIDER_FOR_DB2 INSTALLDIR="C:Program FilesMicrosoft OLE DB Provider for DB2" PIDKEY="R2D433DHG9DQ79WW3DXQ929DY" USERNAME="Northrop Grumman Corporation" COMPANYNAME="NGGN" FILESINUSEERROR=""
[2:13:20 PM Info] MSI command line is ADDLOCAL=REQUIRED_FEATURE,OLE_DB_PROVIDER_FOR_DB2 INSTALLDIR="C:Program FilesMicrosoft OLE DB Provider for DB2" PIDKEY="R2D433DHG9DQ79WW3DXQ929DY" USERNAME="Northrop Grumman Corporation" COMPANYNAME="NGGN" FILESINUSEERROR=""
[2:13:20 PM Info] Detailed Log information for product H:SQL2005DB2OLEDB7Msix86HISDB2.msi is available at DetailedLog
[2:13:20 PM Info] MSI installation returned 2 - The system cannot find the file specified.
[2:13:20 PM Error] Error 0 occurred during MSI installation.
[2:13:20 PM Error]
[2:13:20 PM Error] === Logging stopped: 2:13:25 PM Monday, August 20, 2007 ===
Detailed Log
=== Verbose logging started: 8/20/2007 14:13:20 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:DOCUME~1dinsestLOCALS~1TempEBZ34671.tmpSetup.exe ===
MSI (c) (E4C) [14:13:20:343]: Resetting cached policy values
MSI (c) (E4C) [14:13:20:343]: Machine policy value 'Debug' is 0
MSI (c) (E4C) [14:13:20:343]: ******* RunEngine:
******* Product: H:SQL2005DB2OLEDB7Msix86HISDB2.msi
******* Action:
******* CommandLine: **********
MSI (c) (E4C) [14:13:20:343]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (E4C) [14:13:20:343]: Grabbed execution mutex.
MSI (c) (E4C) [14:13:20:359]: Cloaking enabled.
MSI (c) (E4C) [14:13:20:359]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (E4C) [14:13:20:359]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (B88) [14:13:20:374]: Grabbed execution mutex.
MSI (s) (B8:90) [14:13:20:374]: Resetting cached policy values
MSI (s) (B8:90) [14:13:20:374]: Machine policy value 'Debug' is 0
MSI (s) (B8:90) [14:13:20:374]: ******* RunEngine:
******* Product: H:SQL2005DB2OLEDB7Msix86HISDB2.msi
******* Action:
******* CommandLine: **********
MSI (s) (B8:90) [14:13:20:374]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (B8:90) [14:13:20:406]: MainEngineThread is returning 2
MSI (c) (E4C) [14:13:20:421]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (E4C) [14:13:20:421]: MainEngineThread is returning 2
=== Verbose logging stopped: 8/20/2007 14:13:20 ===
Does anyone have an idea as to why the installation is failing?
TIA,
Steve
P.S. Those aren't really smileys, they're actually semicolon Ds but I can't seem to get rid of the cartoon translation, even after checking the "This post contains a code sample" checkbox.
I have tried several times to install
SQL Server 2005 Developer Edition (most recently from MSDN Disk
3097.1) I have tried to complete an uninstall before each
attempt.
I do get the warning about Minimum Hardware Requirement, but can find
nothing in the detail requirements to exclude my PCs configuration.
I have installed: IIS and .NET Framework 2.0
I have also used ..aspnet_regiis -r to register ASP.NET
I am, successfully, running Visual Studio 2005.
Why does the installation process stop there and what can I do next?
I do get the warning about Minimum Hardware Requirement, but can
find nothing in the detail requirements to exclude my PCs configuration.
I have installed:
IE 6.0 sp1
IIS as a part of Win 2000 Professional Edition SP4
I have also used ..aspnet_regiis -r to register ASP.NET 2.0
.NET Framework 2.0
SQL Server Native Client
SQL Server Setup support files
PC includes:
Pentium III 800 MHz
512 MB memory
HardDrive C: 5.92 GB (1.37 GB free)
HardDrive D: 13.1 GB (9.11 GB free)
I have tried several times to install SQL Server 2005 Developer Edition
(most recently from MSDN Disk 3097.1) I have tried to
complete an uninstall before each attempt.
I am, successfully, running Visual Studio 2005.
Any suggestions will be appreciated.
I want to install SQL Server 2005 Developer Edition on a computer with Vista Business. It looks like a lot of issues. (1) Can I do this? (2) Does anyone have any instrucions?
Thanks for your help
Has microsoft issued an update so I can install SQL 2005 DE on Windows Vista? Thank You!
View 3 Replies View RelatedI have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!
View 11 Replies View RelatedPlease Help!!!.
I Installed everything but database Engine...
Error Log:
Property(S): SqlVerComBin.8E491190_3328_49D2_9FFE_2D036D847DE2 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.8E491190_3328_49D2_9FFE_2D036D847DE2 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlTarget.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstance.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlInstanceBin.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): sqlreps_dll.EB8FB35E_3FC3_41F6_9721_7400C2070A66 = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnsqlrepss90.dll
Property(S): SqlInstance.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): SqlTarget.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceInstall.E4D6F7B0_3639_4517_9BA2_30823DE19CEB = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLInstall
Property(S): CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon Files
Property(S): MSShared.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft Shared
Property(S): DatabaseRepl.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase Replication
Property(S): DatabaseReplRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources
Property(S): DatabaseReplRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources1033
Property(S): WindowsFolder = C:WINNT
Property(S): Gac.A6DEDA64_4924_4EA9_84E5_DC507BA0794B = C:Program FilesMicrosoft SQL Server90GAC
Property(S): Ver.A6DEDA64_4924_4EA9_84E5_DC507BA0794B = C:Program FilesMicrosoft SQL Server90
Property(S): Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 = C:Program FilesMicrosoft SQL Server90GAC
Property(S): Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.889BED4C_E3F4_4943_956C_6FFD882F721F = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.889BED4C_E3F4_4943_956C_6FFD882F721F = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBin.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90
Property(S): SqlVerComBinRes.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:Program FilesMicrosoft SQL Server90COMResources
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.3MSSQL
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.3MSSQLBinn
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.3MSSQL
Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C
Property(S): SqlFullTextDefaultPath = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = B0019B91BCDB3SQLServer2005MSFTEUser$B0019B91BCDB3$SQL2005PDI1
Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQL2005PDI1
Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3
Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.3MSSearch
Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3MSSQL
Property(S): FTEStartupType = 0
Property(S): FTEStatus = 3
Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.3
Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQL2005PDI1
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.3MSSQLBinn
Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQL
Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
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 = $SQL2005PDI1
Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQL2005PDI1:C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef
Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnFTERef|C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLFTData
Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinn
Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = C:Program FilesMicrosoft SQL ServerMSSQL.3MSSQLBinnSQL2005PDI1
Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYSYSTEM
Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQL2005PDI1
Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.3
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$SQL2005PDI1
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 = $SQL2005PDI1
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQL2005PDI1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQL2005PDI1
Property(S): SqlStateManaged = 2
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): RSVirtualDirectoryManager = Reports$SQL2005PDI1
Property(S): SOURCEDIR = S:PDIPDI ToolsSQL 2005 DeveloperCD1Setup
Property(S): SourcedirProduct = {2373A92B-1C1C-4E71-B494-5CA97F96AA19}
Property(S): InstallNgenTicks = 20000
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {BF3C1964-6601-4DBB-A782-1848FD4A2109}
Property(S): SQLBROWSERACCOUNT = CORPNBDG3C3
Property(S): ProductToBeRegistered = 1
MSI (s) (F8:64) [14:22:43:217]: Note: 1: 1708
MSI (s) (F8:64) [14:22:43:217]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (F8:64) [14:22:43:233]: Cleaning up uninstalled install packages, if any exist
MSI (s) (F8:64) [14:22:43:233]: MainEngineThread is returning 1603
MSI (s) (F8:48) [14:22:43:342]: Destroying RemoteAPI object.
MSI (s) (F8:C0) [14:22:43:342]: Custom Action Manager thread ending.
=== Logging stopped: 5/16/2007 14:22:43 ===
MSI (c) (7C:84) [14:22:43:342]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (7C:84) [14:22:43:342]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/16/2007 14:22:43 ===
I have function that returns a table of information about properties. Thedata comes from three different tables -- addresses (called PropertyID),property characteristics, and events concerning those properties (sales,appraisals, etc.), plus a table that maps one representation of propertytypes into another. The records are selected on the basis of location(longitude & latitude), property type, event type, and a range ofevent dates (upper and lower date specified). There are tens of millionsof records of all types, and almost any location, property type, event typeand date range will yield records.The heart of it is a cursor that selects records from joins on this basis:SELECT <a bunch of fields>FROM Property dJOIN PropTypeMap ptm ON ptm.PropertyTypeID = d.PropertyTypeIDJOIN PropertyID a ON a.PropID = d.PropIDJOIN Event e1 ON e1.PropID = d.PropIDLEFT OUTER JOIN Event e2 ON e2.PropID = d.PropIDWHEREd.LastSaleDate >= @LoDateAND a.GeoLongitude BETWEEN @LowerLon AND @UpperLonAND a.GeoLatitude BETWEEN @LowerLat AND @UpperLatAND ptm.PropCategory = @PropTypeAND a.GeoMatch <= @MinGeoQualityAND e1.EventTypeID = @SaleEventTypeAND e1.TransactionType = 'R'AND e1.EventDt BETWEEN @LoDate AND @HiDateAND e1.EventAmt > 0AND e2.EventTypeID = @AssessmentEventTypeAND e2.EventDt <= @HiDateAND e2.EventAmt > 0Each property has one PropertyID record, one Property record, and N Eventrecords (average perhaps five).What is the mystery? If @HiDate, which is the upper end of the time window,is 2002-11-08 or earlier, nothing is returned. If it's 2002-11-09 or later,oodles of records are found. I get the same query plan for either one, andbased on the content of the data, they should return almost exactly the sameset of records -- exactly the same set in almost all cases, in fact.Is 2002-11-08/09 some sort of magic dividing point? I have replicated thison the large database and on a smaller test version on another SQL Server.(SQL Server 2000) I dropped the indexes and tried it, andthe same thing happened. This is driving me crazy!
View 3 Replies View RelatedI am trying to install the SQL Server 2005 Enterprise Edition, but on the components selection page, the only options I can check are Sample Book/Docs and Tools(Business Intelligence Studio, SQL Management Studio).
Even on the advanced page, those are the only options. Everything runs with no problem, except the SQL server instance.
I checked on the SQL Server Configuration Manager, and it does not show any SQL instances installed.
I tried adding a new instance using the add/remove>change for Microsoft SQL Server 2005 by selecting the setup.exe file in the Enterprise CD, but the it has the same options. If I select the setup.exe file from my Workgroup Edition CD, the option for adding new instances works.
What should I Do?
Cant I add SQL server instances using the Enterprise Edition? I was unable to install even the first instance.
The computer I am using meets all requirements and no SQL versions have been installed yet.
Thanks for the help.
I have Vista Enterprise 64-bit. I have followed the 3 links in this Answered Link.
http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=2756202
I can turn on the IIS bits under
Web Management Tools and
Windows Authentication
But when I try to turn on the World Wide Web Services stuff I get
"An error has occurred. Not all of the features were successfully changed"
and when I click OK it has not turned on any of the fetures under World Wide Web Services.
Any clues?
I am wondering if it is possible to change from SQL Server Enterprise Evaluation Version to Developer Version. The reason is because the Enterprise Evaluation version expires after 180 days. So if I create reports and cubes in Enterprise Evaluation I can import them into Developer Edition right? Should I remove the Enterprise Evaluation version after 180 days or leave it then install Developer Edition?
View 1 Replies View RelatedWe have an existing installation of SQL Server 2005 Developer Edition (64bit) that we are ready to go live with and would like to change the edition to Enterprise Edition (64bit). We have purchased all the appropriate licenses. We would like to avoid UN-installing the Developer Edition and RE-installing the Enterprise Edition. There must be some way to change a registry key, provide your serial number via a command line utility or re-run the setup with the license key provided and direct it to just change the edition from Developer to Enterprise and not change any of the other settings like service account, sa account, collation, etc. Any help is most appreciated.
Thank you,
Matt
Hell
View 1 Replies View Related
When I am trying to install SQL Enterprise edition, in Server 2003 OS. while installing only it shows an error.
SQL Server 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".
Please help me to resolve this.
P4 2.8G Hz, 512 M RAM.thanks.
View 3 Replies View RelatedFailed to install SQL Server 2005 Enterprise (x86) on one server
I am trying to install SQL Server 2005 Enterprise on one of my test server. I am sure I entered the correct domain user name and password and the account is admin. I€™ve tried several times but I got this error instantly:
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."
Some of the other component could be installed properly. The system was just rebuilt with only VSTS 2005 installed.
Here is the part of the log
€¦
MSI (s) (48:58) [06:04:54:365]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (48:58) [06:04:54:365]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (48:CC) [06:04:54:365]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIE56.tmp, Entrypoint: Do_sqlScript
<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Jul 12 06:04:54 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jul 12 06:04:54 2007
Unable to start service (1069)
Error Code: 0x8007042d (1069)
Windows Error Text: The service did not start due to a logon failure.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls:ervice:tart
Source Line Number: 316
€¦
Thanks - Andy
(1) I have already installed of SQL Server 2005 Developer Edition first.
(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?
(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?
Hi,
We have 2005 Standard Edition in our production environment and 2005 Developer Edition in dev. Recently we started using a feature in dev only to realize it was an Enterprise specific feature when we wanted to move it to prod. Is there any way to turn off the enterprise features in developer edition so it behaves just like standard edition?
Thanks
Charlie
I just installed SQl 2005 Developer Edition, and don't see an Enterprise Manager icon. Only Configuration Tool icons were installed.
Is this all SQL 2005 Developer is, or shoudl I be seeing an Enterprise Manager?
Thanks for your response,
Nate Terry
We are in the initial stages of preparing for bringing in a DW Architect. What struck me odd was no one asked the DBAs about what we should be looking for in an architect. Should the DBAs be involved in the hiring process e.g. interviewing? I think so. Comments welcome
View 3 Replies View RelatedIf I run the same FOR XML query in a Development edition enviornment and a Enterprise Edition environment, the results are different. The query is exactly the same.
Here is the query:
DECLARE @MessageBody XML
DECLARE @AuditTable SYSNAME
DECLARE @SendTrans BIT
DECLARE @SendAudit BIT
DECLARE @RecordCount INT
DECLARE @OperationType CHAR(1)
SET @RecordCount = @@ROWCOUNT
SET @OperationType = 'U'
SET @SendTrans = 1
SET @SendAudit = 1
SET @AuditTable = 'States'
SELECT @MessageBody = (
SELECT * FROM
(
SELECT TOP 10
'INSERTED' AS ActionType, @SendTrans AS SendTrans, @SendAudit AS SendAudit,
COLUMNS_UPDATED() AS ColumnsUpdated, GETDATE() AS AuditDate,
@AuditTable AS AuditTable, 'test' AS UserName, @RecordCount AS RecordCount, *
FROM l_states
)AuditRecord
FOR XML AUTO, ROOT('AuditTable'), BINARY BASE64)
SELECT @MessageBody
In my DEV env (Developer Edition), this result is produced:
<AuditTable>
<AuditRecord ActionType="INSERTED" SendTrans="1" SendAudit="1" AuditDate="2007-06-22T15:43:12.497" AuditTable="States" UserName="test" RecordCount="1" StateAbbreviation="AK" State="Alaska" />
<AuditRecord ActionType="INSERTED" SendTrans="1" SendAudit="1" AuditDate="2007-06-22T15:43:12.497" AuditTable="States" UserName="test" RecordCount="1" StateAbbreviation="AL" State="Alabama" />
</AuditTable>
In my Enterprise Edition evn, this is the result:
<AuditTable>
<AuditRecord ActionType="INSERTED" SendTrans="1" SendAudit="1" AuditDate="2007-06-22T15:44:48.230" AuditTable="States" UserName="test" RecordCount="1">
<l_states StateAbbreviation="AK" State="Alaska" />
<l_states StateAbbreviation="AL" State="Alabama" />
</AuditRecord>
</AuditTable>
Does anyone have any idea what might be wrong? Any help is greatly appreciated.
Tim
Hi,
Is there any one knows how to fix this, please help! This is urgent.
In the configuration checking, there was only one warning message about operation system (this warning should be ignored according to some advice). When coming to the Component checkboxes, there is only one checkboxe checkable at the last item.
Thanks!
Hi all,
I have downloaded Microsoft SQL Server 2005 Enterprise Evaluation Edition ISO from the following site and burned it onto a DVD.
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
Prior to this I have installed Visual Studio 2005 Professional Edtion. During setup I have selected all the native client components i.e. Management Studio, Business Intelligense Studio. But after the install I am not able to see them under All Programs-> Microsoft SQL Server 2005. On further searching I have come across this link
http://channel9.msdn.com/ShowPost.aspx?PostID=142941
First of all, there is no sqlrun_tools.msi under setup folder of the dvd. And also when I tried to change component from Add/Remove programs and following the instructions as specified on clicking Change Installed components all that I see are: Connectivity Components and Software Development kit.
Could someone tell me how can I install Management Studio/ Business Intelligence Studio seperately? I don't want to go through the process of re-installation.