Link to home
Start Free TrialLog in
Avatar of sasllc
sasllcFlag for United States of America

asked on

Problem with SQL 2017 Standard login password

As I'm sure will be obvious below, note that I know nothing about SQL 2017 except that an app I'm installing requires it.  


I bought SQL and installed it a month ago.  I don't remember specifying a password, but the app I am now trying to install says I must have defined a password for user 'sa'.  Is this correct?


Can I solve my problem by reinstalling SQL 2017 Standard on the same server using the same license key, with no problem?  If so, will it be asking me for a password that will go with user 'sa'?


Or are there other considerations here or better ways to solve this problem--so I can move forward with installing the app?  TIA



Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

  1. Open SQL Server Configuration Manager from Start Menu > Programs > Microsoft SQL Server 20xx > Configuration Tools > relevant to the newest version of SQL Server you have installed (e.g. if you have 2005 and 2012 installed, use the 2012 version). Don't have a Start Menu? On Windows 8's Start screen, start typing SQL Server Con... until it shows up.
  2. Stop the SQL Server instance you need to recover by right-clicking the instance in SQL Server Services and selecting "Stop"
  3. Right-click the instance you just stopped, click Properties, and in the “Advanced” tab, in the Properties text box add “;–m” to the end of the list in the “Startup parameters” option (on newer versions, you can go directly to the "Startup Parameters" tab, type "-m" and click Add, without worrying about the syntax, the semi-colon, or anything else).
  4. Click the “OK” button, and restart the SQL Server Instance
  5. After the SQL Server Instance starts in single-user mode, the Windows Administrator account is able to connect to SQL Server using the sqlcmd utility using Windows authentication. You can use Transact-SQL commands such as "sp_addsrvrolemember" to add an existing login (or a newly created one) to the sysadmin server role.

The following example adds the account "David" in the "CONTOSO" domain to the sysadmin role:

EXEC sp_addsrvrolemember 'CONTOSO\David', 'sysadmin';

Once the sysadmin access has been recovered, remove the “;-m” from the startup parameters using the Configuration Manager and restart the SQL Server instance one more time.

NOTE: make sure there is no space between “;” and “-m”, the registry parameter parser is sensitive to such typos. You should see an entry in the SQL Server ERRORLOG file that says “SQL Server started in single-user mode.


From SSMS login as contoso\david and reset the sa password


Source


Avatar of sasllc

ASKER

Per the attached screenshot, I cannot see a way to add -m at the end of the line. I cannot find how to widen the view, and even though I arrowed over to the far right it will not let me key in -m or anything else.

Since I have not utilized this SQL installation yet, would there be any problem with me instead simply reinstalling with the same key?
SS075.jpg

uninstall and reinstall is also a valid option.

Avatar of sasllc

ASKER

Does the install process ask for a password for user 'sa' as they imply?  I don't remember it asking, so I want to make sure I don't miss it this time--if there is more to it than simply answering a question that clearly asks for that a password for user 'sa'.
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial