Instalando SQL Server 2008 R2 IIS em modo Core

14/08/2011 -

Instalar SQL Server 2008 R2

  1. Pre-Requisitos:
    • Dism /online /enable-feature /featurename:NetFx2-ServerCore
    • Dism /online /enable-feature /featurename:NetFx3-ServerCore
    • Dism /online /enable-feature /featurename:ServerCore-WOW64
    • Dism /online /enable-feature /featurename:NetFx2-ServerCore-WOW64
    • Dism /online /enable-feature /featurename:NetFx3-ServerCore-WOW64
    • Dism /online /enable-feature /featurename:MicrosoftWindowsPowerShell
    • Dism /online /enable-feature /featurename:MicrosoftWindowsPowerShell-WOW64
  2. Instalação:
    • Setup.exe /qs /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="administrator" /AGTSVCACCOUNT="NT AUTHORITY\Network Service"
    • netsh advfirewall firewall add rule name="SQL SERVER" dir=in action=allow protocol=TCP localport=1433
    • net start mssqlserver
  3. Configurações Básicas usando o SQLCMD.exe (em "C:\Program Files\Microsoft SQL Server\100\Tools\Binn") (ou use -q "sql")
    • EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
    • EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp', N'Enabled', REG_DWORD, 2
    • ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
    • ALTER LOGIN [sa] WITH PASSWORD=N'senha'
    • ALTER LOGIN [sa] ENABLE