Wednesday, April 3, 2013

[MS SQL Server] Installing SQL server 2008 Express from windows application

[MS SQL Server] Installing SQL server 2008 Express from windows application

Installing SQL server 2008 Express from windows application

Posted: 16 Jul 2012 09:44 PM PDT

HiI am trying to install SQL Server 2008 Express from Window ApplicationI am using this command[code="other"]"/qs /ACTION=Install /SkipRules=VSShellInstalledRule RebootRequiredCheck /HIDECONSOLE /FEATURES=SQL /INSTANCENAME=" + _InstanceName + " /SECURITYMODE=\"SQL\" /SQLSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" /SAPWD=" + _SAPassword + " /SQLSYSADMINACCOUNTS=\"BUILTIN\\ADMINISTRATORS\" /ENABLERANU=1 /AGTSVCACCOUNT=\"NT AUTHORITY\\SYSTEM\" /TCPENABLED=1 /ERRORREPORTING=1";[/code]It gives some error[code="plain"]Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068643839 Exit facility code: 1203 Exit error code: 1 Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Start time: 2012-07-17 15:24:44 End time: 2012-07-17 15:31:36 Requested action: Install Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120717_152357\sql_engine_core_inst_Cpu32_1_3.log Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.4000.0[/code]This is the log[code="plain"]=== Verbose logging started: 7/17/2012 15:31:31 Build type: SHIP UNICODE 5.00.7601.00 Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x86\setup100.exe ===MSI (c) (88:9C) [15:31:31:134]: Resetting cached policy valuesMSI (c) (88:9C) [15:31:31:134]: Machine policy value 'Debug' is 0MSI (c) (88:9C) [15:31:31:134]: ******* RunEngine: ******* Product: l:\ba31376b3b92fbc8f394b3\x86\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi ******* Action: ******* CommandLine: **********MSI (c) (88:9C) [15:31:31:134]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (88:9C) [15:31:34:134]: Failed to grab execution mutex. System error 258.MSI (c) (88:9C) [15:31:34:135]: Cloaking enabled.MSI (c) (88:9C) [15:31:34:135]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (88:9C) [15:31:34:136]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (c) (88:9C) [15:31:34:137]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1MSI (c) (88:9C) [15:31:34:137]: MainEngineThread is returning 1618=== Verbose logging stopped: 7/17/2012 15:31:34 ===MSI (s) (48:80) [15:31:49:560]: User policy value 'DisableRollback' is 0MSI (s) (48:80) [15:31:49:560]: Machine policy value 'DisableRollback' is 0MSI (s) (48:80) [15:31:49:560]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (48:80) [15:31:49:560]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (48:80) [15:31:49:564]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2 MSI (s) (48:80) [15:31:49:565]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1MSI (s) (48:80) [15:31:49:565]: Restoring environment variablesMSI (s) (48:80) [15:31:49:573]: Destroying RemoteAPI object.MSI (s) (48:80) [15:31:49:573]: Custom Action Manager thread ending.[/code]Any info need let me knowThanksWith regardsDD

Logical CPU Count and Hyperthread Ratio ?

Posted: 02 Apr 2013 05:53 PM PDT

Hi,The query output as below[code="sql"]SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],cpu_count/hyperthread_ratio AS [Physical CPU Count], physical_memory_in_bytes/1048576 AS [Physical Memory (MB)], sqlserver_start_timeFROM sys.dm_os_sys_info OPTION (RECOMPILE);[/code]Logical CPU Count - 16 Hyperthread Ratio - 8 Physical CPU Count - 2Physical Memory (MB) - 32756 Hyperthread Technology is create two logical processor on actual physical processor, So server has 2 Physical CPU, it means Dual core processor. Hyperthread Ratio is 8, 8*2=16 logical processor.I want to know, Does Logical CPU Count and Hyperthread Ratio should be same numbers?thanksananda

Entering Service Account Details During Install

Posted: 02 Apr 2013 09:16 AM PDT

I read an article posted by GilaMonster about remedies for some errors preventing SQL from starting.One section was on the Service Account being locked out.This reminded me of a time when the Service Account got locked out during a new SQL installation here.The incorrect password was entered for the respective services and the Service Account got locked out during the authentication attempts (depends on the password policy of course) -- so all all the production SQL services would now have a locked account and would not be able to be restarted.So when you perform new installs of SQL do you enter the main prod service account at this point in the installation or do you just use the local system account to get SQL installed, and then use SQL Configuration Manager to change the service accounts post install? This way you can at least do one at a time therefore reducing the chances of a locked account!Just curious.thanks

Upgrade SSAS to a lower edition

Posted: 02 Apr 2013 06:26 AM PDT

I currently have SSAS 2008 (Ent)Is it possible to upgrade it to SSAS 2008 R2 Standard. I know from Version and Edition Upgrades http://technet.microsoft.com/en-us/library/ms143393(v=sql.105).aspx that SQL 2008 engine Enterprise upgrade path is only Enterprise or Datacenter is this the same for Analysis services?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog