July 22, 2005 at 4:07 am
Files\Microsoft SQL Server\Mssql$SQL_TEST1\Data\MSSQL$SQL_TEST1\LOG\
Property(S): InstanceName.24170C3F_A9E4_47C1_8DFE_FD79C2714697 = SQL_TEST1
Property(S): PackageCode = {D29DCF7A-8199-4373-BA0D-2F3635EC940C}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): SA...
Property(S): SECURITYMODE = SQL
Property(S): INSTANCENAME = SQL_TEST1
Property(S): DATADIR = C:\Program Files\Microsoft SQL Server\Mssql$SQL_TEST1\Data\
Property(S): CURRENTDIRECTORY = C:\MSDERelA
Property(S): CLIENTUILEVEL = 0
Property(S): CLIENTPROCESSID = 424
Property(S): USERNAME = FSC
Property(S): COMPANYNAME =
Property(S): ACTION = INSTALL
Property(S): VersionDatabase = 110
Property(S): VersionMsi = 3.01
Property(S): WindowsBuild = 2195
Property(S): ServicePackLevel = 4
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:\WINNT\
Property(S): WindowsVolume = C:\
Property(S): System16Folder = C:\WINNT\system\
Property(S): TempFolder = C:\DOCUME~1\FSC\LOCALS~1\Temp\
Property(S): ProgramFilesFolder = C:\Program Files\
Property(S): CommonFilesFolder = C:\Program Files\Common Files\
Property(S): AppDataFolder = C:\Documents and Settings\FSC\Application Data\
Property(S): FavoritesFolder = C:\Documents and Settings\FSC\Favorites\
Property(S): NetHoodFolder = C:\Documents and Settings\FSC\NetHood\
Property(S): PersonalFolder = C:\Documents and Settings\FSC\My Documents\
Property(S): PrintHoodFolder = C:\Documents and Settings\FSC\PrintHood\
Property(S): RecentFolder = C:\Documents and Settings\FSC\Recent\
Property(S): SendToFolder = C:\Documents and Settings\FSC\SendTo\
Property(S): TemplateFolder = C:\Documents and Settings\All Users\Templates\
Property(S): CommonAppDataFolder = C:\Documents and Settings\All Users\Application Data\
Property(S): LocalAppDataFolder = C:\Documents and Settings\FSC\Local Settings\Application Data\
Property(S): MyPicturesFolder = C:\Documents and Settings\FSC\My Documents\My Pictures\
Property(S): AdminToolsFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools\
Property(S): StartupFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(S): ProgramMenuFolder = C:\Documents and Settings\All Users\Start Menu\Programs\
Property(S): StartMenuFolder = C:\Documents and Settings\All Users\Start Menu\
Property(S): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
Property(S): FontsFolder = C:\WINNT\Fonts\
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 15
Property(S): PhysicalMemory = 766
Property(S): VirtualMemory = 1746
Property(S): AdminUser = 1
Property(S): LogonUser = FSC
Property(S): UserSID = S-1-5-21-1715567821-1343024091-854245398-1000
Property(S): UserLanguageID = 2057
Property(S): ComputerName = FSC-9MPEWG25WQ8
Property(S): SystemLanguageID = 1033
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 19
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 10:29:44
Property(S): Date = 22/07/2005
Property(S): MsiNetAssemblySupport = 2.0.50215.312
Property(S): RedirectedDllSupport = 1
Property(S): Privileged = 1
Property(S): DATABASE = C:\WINNT\Installer\9f1ed.msi
Property(S): OriginalDatabase = C:\MSDERelA\Setup\SqlRun01.msi
Property(S): UILevel = 3
Property(S): AgentServiceName = SQLAgent$SQL_TEST1
Property(S): InstanceRegKey = Microsoft SQL Server\SQL_TEST1
Property(S): InstanceSubDir = MSSQL$SQL_TEST1
Property(S): SqlPerfMonRegKey = SQLCTR$SQL_TEST1
Property(S): SQLServiceName = MSSQL$SQL_TEST1
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
Property(S): SOURCEDIR = C:\MSDERelA\Setup\
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductToBeRegistered = 1
MSI (s) (E4:84) [10:29:44:714]: MainEngineThread is returning 0
MSI (s) (E4:F8) [10:29:44:724]: Destroying RemoteAPI object.
MSI (s) (E4:48) [10:29:44:724]: Custom Action Manager thread ending.
MSI (c) (A8:A0) [10:29:44:734]: Back from server. Return value: 0
MSI (c) (A8:A0) [10:29:44:734]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 10:29:44: INSTALL. Return value 1.
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 500
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
Property(C): ProductName = Microsoft SQL Server Desktop Engine
Property(C): ProductVersion = 8.00.761
Property(C): MsiHiddenProperties = SqlSa...
Property(C): TARGETDIR = C:\Program Files\Microsoft SQL Server\Mssql$SQL_TEST1\Binn\
Property(C): SQLVersion.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 8.00.194
Property(C): SQLExitCode.2D02443E_7002_4C0B_ABC9_EAB2C064397B = 1603
Property(C): APPS_TEST = 1
Property(C): SQLMSDESelected = 1
Property(C): CSDVersionNumber = 768
Property(C): CSDVersion = 8.00.761
Property(C): SystemFolder = C:\WINNT\system32\
Property(C): PackageCode = {D29DCF7A-8199-4373-BA0D-2F3635EC940C}
Property(C): ProductState = -1
Property(C): SA...
Property(C): PackagecodeChanging = 1
Property(C): SECURITYMODE = SQL
Property(C): INSTANCENAME = SQL_TEST1
Property(C): DATADIR = C:\Program Files\Microsoft SQL Server\Mssql$SQL_TEST1\Data\
Property(C): CURRENTDIRECTORY = C:\MSDERelA
Property(C): CLIENTUILEVEL = 0
Property(C): CLIENTPROCESSID = 424
Property(C): VersionDatabase = 110
Property(C): VersionMsi = 3.01
Property(C): WindowsBuild = 2195
Property(C): ServicePackLevel = 4
Property(C): ServicePackLevelMinor = 0
Property(C): MsiNTProductType = 1
Property(C): WindowsFolder = C:\WINNT\
Property(C): WindowsVolume = C:\
Property(C): System16Folder = C:\WINNT\system\
Property(C): TempFolder = C:\DOCUME~1\FSC\LOCALS~1\Temp\
Property(C): ProgramFilesFolder = C:\Program Files\
Property(C): CommonFilesFolder = C:\Program Files\Common Files\
Property(C): AppDataFolder = C:\Documents and Settings\FSC\Application Data\
Property(C): FavoritesFolder = C:\Documents and Settings\FSC\Favorites\
Property(C): NetHoodFolder = C:\Documents and Settings\FSC\NetHood\
Property(C): PersonalFolder = C:\Documents and Settings\FSC\My Documents\
Property(C): PrintHoodFolder = C:\Documents and Settings\FSC\PrintHood\
Property(C): RecentFolder = C:\Documents and Settings\FSC\Recent\
Property(C): SendToFolder = C:\Documents and Settings\FSC\SendTo\
Property(C): TemplateFolder = C:\Documents and Settings\All Users\Templates\
Property(C): CommonAppDataFolder = C:\Documents and Settings\All Users\Application Data\
Property(C): LocalAppDataFolder = C:\Documents and Settings\FSC\Local Settings\Application Data\
Property(C): MyPicturesFolder = C:\Documents and Settings\FSC\My Documents\My Pictures\
Property(C): AdminToolsFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools\
Property(C): StartupFolder = C:\Documents and Settings\All Users\Start Menu\Programs\Startup\
Property(C): ProgramMenuFolder = C:\Documents and Settings\All Users\Start Menu\Programs\
Property(C): StartMenuFolder = C:\Documents and Settings\All Users\Start Menu\
Property(C): DesktopFolder = C:\Documents and Settings\All Users\Desktop\
Property(C): FontsFolder = C:\WINNT\Fonts\
Property(C): GPTSupport = 1
Property(C): OLEAdvtSupport = 1
Property(C): ShellAdvtSupport = 1
Property(C): Intel = 15
Property(C): PhysicalMemory = 766
Property(C): VirtualMemory = 1748
Property(C): AdminUser = 1
Property(C): LogonUser = FSC
Property(C): UserSID = S-1-5-21-1715567821-1343024091-854245398-1000
Property(C): UserLanguageID = 2057
Property(C): ComputerName = FSC-9MPEWG25WQ8
Property(C): SystemLanguageID = 1033
Property(C): ScreenX = 1024
Property(C): ScreenY = 768
Property(C): CaptionHeight = 19
Property(C): BorderTop = 1
Property(C): BorderSide = 1
Property(C): TextHeight = 16
Property(C): ColorBits = 32
Property(C): TTCSupport = 1
Property(C): Time = 10:29:44
Property(C): Date = 22/07/2005
Property(C): MsiNetAssemblySupport = 2.0.50215.312
Property(C): RedirectedDllSupport = 1
Property(C): Privileged = 1
Property(C): USERNAME = FSC
Property(C): COMPANYNAME =
Property(C): DATABASE = C:\DOCUME~1\FSC\LOCALS~1\Temp\9ee3f.msi
Property(C): OriginalDatabase = C:\MSDERelA\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Logging stopped: 22/07/2005 10:29:44 ===
MSI (c) (A8:A0) [10:29:44:744]: Note: 1: 1707
MSI (c) (A8:A0) [10:29:44:744]: Product: Microsoft SQL Server Desktop Engine -- Installation operation completed successfully.
MSI (c) (A8:A0) [10:29:44:774]: Grabbed execution mutex.
MSI (c) (A8:A0) [10:29:44:774]: Cleaning up uninstalled install packages, if any exist
MSI (c) (A8:A0) [10:29:44:774]: MainEngineThread is returning 0
=== Verbose logging stopped: 22/07/2005 10:29:44 ===
July 22, 2005 at 4:08 am
O/S = Windows 2000 Professional Service Pack4
I am pulling my hair out on this one.
I was very careful with the installation making sure none of the services were running which a required not to.... could not find any of them to be honest, also made sure IIS was not running either
[Options]
SECURITYMODE=SQL
INSTANCENAME="SQL_TEST1"
TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$SQL_TEST1\Binn\"
DATADIR="C:\Program Files\Microsoft SQL Server\Mssql$SQL_TEST1\Data\"
The setup completes with the log informing a successful installation
When I restart the SQL Server Service Manager icon is blank i.e. no green play or red stop.... I presumed I would type in my name of the sql server instance and select the sql server from the services drop down but there is no services to choose from in the drop down.
Above is the output from the log.... would really appreciate any help!!! sorry used verbose logging first post did not work
thanks
July 22, 2005 at 6:40 am
Adam,
Are the MSSQLSERVER and SQLSERVERAGENT services running?
ll
July 25, 2005 at 11:23 am
yes
July 25, 2005 at 12:23 pm
Are you typing it in using:
<servername>\<instance>
For instance:
MySQLServer\SQL_Test1
Also, if you use isql (case sensitive on the switches) to connect locally to the instance, say:
isql -S \SQL_Test1 -E -Q "SELECT @@SERVERNAME"
Does that work?
K. Brian Kelley
@kbriankelley
July 26, 2005 at 6:49 am
thanks working, there were no instructions what to do once installed but because of the above post I type in \ under name and clicked on refresh services, and the rest is history... thanks
July 26, 2005 at 6:50 am
CompName\Server Instance Name
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply