English | 中文

Browse Services

  Categories

Account Management
1
Control Panel
4
Dedicated Server
1
Email
6
Let's Encrypt SSL
0
Network Test
2
Other
2
VNC
3
VPS or Cloud VM
30
Web Hosting
12

  Categories

  Tag Cloud

/etc/localtime 550 5.7.511 access phpMyAdmin without login to cPanel almalinux blacklist block list cagefs centos web panel change ip cloud server cloud vm cloud-init cloudlinux cpanel cPanel ModSecurity CRS date directadmin elastic cloud hosting email email compromised email port email security failed to retrieve directory listing file transfer failed filezilla firewall ftp glibc GPG-KEY growpart http headers imap imap folder not showing inode IP blacklist removal ip change request locale lve manager mail client man-in-the-middle mariadb microsoft missing imap folder MITM ModSecurity mysql root password outlook OWASP php-redis phpmyadmin phpmyadmin interface pop pop3 redis resize partition resize2fs RPM-GPG-KEY-AlmaLinux share hosting backup limit share hosting free backup shared hosting smtp ssh key sshkey ssl support access thunderbird time timedatectl timezone tls universal time utc utf-8 WAF Web Application Firewall web security wordpress

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket

How to reset SQL admin (sa) password? Print

  • 3
This article show you how to reset SQL server sa password (provided you are administrator)

1) Login to Windows server.
2) Open Microsoft SQL Server Management Studio
3) Login with "Windows Authentication" mode
4) Press "New Query" and paste following:

ALTER LOGIN [LoginName] WITH PASSWORD=N'NewStrongPassword'
GO

change [LoginName] to sa
change NewStrongPassword to your new password

5) Press "Execute".
6) Done.

Was this answer helpful?

Related Articles

How Resize/Reclaim Partition for Windows VPS Question: Why I am getting lesser storage space compared to what I had ordered?Answer: Our... How to connect to remote desktop? This article show you how to connect to your Windows VPS via remote dekstop connection.From your... Configuration information could not be read from the domain controller... When you first using the newly ordered Windows VPS, you will be asked to change your windows user... How to change default Windows Server RDP Port To change Windows Server default RDP port 3389 to your own port number, please follow below...
« Back

  Tag Cloud

/etc/localtime 550 5.7.511 access phpMyAdmin without login to cPanel almalinux blacklist block list cagefs centos web panel change ip cloud server cloud vm cloud-init cloudlinux cpanel cPanel ModSecurity CRS date directadmin elastic cloud hosting email email compromised email port email security failed to retrieve directory listing file transfer failed filezilla firewall ftp glibc GPG-KEY growpart http headers imap imap folder not showing inode IP blacklist removal ip change request locale lve manager mail client man-in-the-middle mariadb microsoft missing imap folder MITM ModSecurity mysql root password outlook OWASP php-redis phpmyadmin phpmyadmin interface pop pop3 redis resize partition resize2fs RPM-GPG-KEY-AlmaLinux share hosting backup limit share hosting free backup shared hosting smtp ssh key sshkey ssl support access thunderbird time timedatectl timezone tls universal time utc utf-8 WAF Web Application Firewall web security wordpress

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket