Comments
 
posted on January 1st 1970, at 01:00
by lunarg
Provided you still have administrative access to the server itself, and the server is running in mixed mode (i.e. you can actually use local SQL logins), you can perform the steps below to reset the password. Note that this will result in some downtime as the SQL Server service will have to be restarted in single user mode.

First, determine the service name (can be done via services.msc): if it is the default instance, it's usually called MSSQLSERVER. If an instance name was specified, it is usually MSSQLSERVER$instance-name. E.g. if the instance is called MYSWEETAPP, the service name would be MSSQLSERVER$MYSWEETAPP.

Open an administrative (elevated) command prompt or Powershell:

First, s  ...
Add a new comment
 
Your name:
Your e-mail:
Your comment:
 
Basic BBcode is supported.
Captcha:
Type the letters and numbers as shown.
/get/captcha/1745028916
Not readable? Get another.
 
 
 
 
« April 2025»
SunMonTueWedThuFriSat
  12345
6789101112
13141516171819
20212223242526
27282930   
 
Links
 
Quote
« If the batteries of a TV remote run out, why do we press the buttons so much harder? »