0

have the following command to install sql using CMD prompt.

C:\SQL Server 2008\setup.exe" /QS /INDICATEPROGRESS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /SkipRules=RebootRequiredCheck /FEATURES=SQL,RS,BIDS,Conn,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS /INSTANCENAME=MSSQLServer /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCSTARTUPTYPE=Manual /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSVCSTARTUPTYPE=Automatic /ASSVCACCOUNT="NT AUTHORITY\SYSTEM" /ASSVCSTARTUPTYPE=Automatic /RSSVCACCOUNT="NT AUTHORITY\SYSTEM" /RSSVCSTARTUPTYPE=Automatic /ISSVCACCOUNT="NT AUTHORITY\SYSTEM" /ISSVCSTARTUPTYPE=Automatic /BROWSERSVCSTARTUPTYPE=Disabled /SECURITYMODE=SQL /SAPWD=test /RSINSTALLMODE=DefaultNativeMode /ASSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM

The installation goes fine and all the required services are installed.

the problem i have is when i try to log-in to the installed instance through management studio i get "Server Name: "

Error Number: 18456. ??

how can i reassign parameter values so that i will be able to login after install

xlecoustillier
  • 16,183
  • 14
  • 60
  • 85
toro
  • 1
  • 1

1 Answers1

0

You should use .\SQLEXPRESS as server name and windows authentication. To access sql from your PC name the follow this tutorial. Click Here

Manoj Pilania
  • 664
  • 1
  • 7
  • 18
  • Thanks for the suggestion but i'm trying to do a full install and not a express install – toro Feb 26 '13 at 04:19