How can I check the installed paramters on the Amazon SQL Server AMI?

• Paul Nevlud

  Old Hand

  Points: 329

  More actions

  August 29, 2012 at 2:39 pm

  #393048

  I'm using the Amazon AMI that comes with SQL Server installed (Microsoft Windows Server 2008 R2 with SQL Server Standard). I'd like to know how the SQL Server was configured during installation. There's quite a bit that I can pull out from SSMS, but I'd rather get something like an installation configuration file. Specifically, I'm interested in the Authentication mode, default data locations, etc.

  My natural next step is to change many of these to suite my needs.

  Thanks for any help on this topic.

  Paul

• Stupeo

  Hall of Fame

  Points: 3067

  More actions

  October 5, 2012 at 4:49 am

  #1545984

  Surely it's easier to see default locations and security settings in SSMS than trying to read through a log file?

• YeeHwua

  SSChasing Mays

  Points: 613

  More actions

  January 7, 2013 at 11:35 am

  #1574452

  If my understanding is correct:

  You can logon AWS RDS console the get server primary parameter and optional parameter group.

  please be aware that the console need to be opened on IE, don't use Firefox, otherwise you might not be able to change editable parameter.

  Some parameters are marked as editable, it quite easy to spot them.

  for instance "ad hoc distribute queries".

  good luck!