MS SQL Database Logins
Navigate to: Main Menu > MS SQL > Click Database Logins.
This page manages the SQL Server authentication credentials (Logins) for your account. These logins act as the "keys" to your databases and are the usernames you use in your connection strings.
Login Lifecycle
When you click ADD NEW LOGIN, the credential is saved securely within our control panel system. It is not physically provisioned on the SQL Server engine until you actually use it to create a new database. Once assigned, the system creates the user on the server and grants it ownership of that database.
Important Shared Hosting Limitations
- One Login Per Database: On shared hosting plans, a database is assigned exactly one login (the Database Owner) at the moment of creation. You cannot add secondary users to an existing database, nor can you switch the owner without deleting and re-creating the database.
Actions & Impact
Click the menu icon (three horizontal lines) next to a specific login to manage it:
- Change password: Resets the password for this specific user.
Critical Warning: Since a single login can be assigned to multiple databases, changing the password here affects every database using this credential. You must immediately update the connection strings in all your applications to prevent downtime.
- Delete: Removes the login from your account.
Constraint: You cannot delete a login that is currently assigned to an active database. To delete a login, you must first delete all databases that are using it.