Knowledge Base

< All Topics

How to access MSSQL database

The client can access the MSSQL databases from local computer. He/She needs to install SQL Server Management Studio on his/her computer. It can be downloaded through link below:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
Once downloaded you will see the SQL management studio as shown in the picture below:
https://kb.dollar2host.com/wp-content/uploads/2023/09/image-918.png
enter the server name: Serverip\MSSQLSERVER2012 (version of database should be changed as per your database version here)
Authentication: SQL server authentication
user: database user name
pass: database password which is used for the above user
and then click “connect” to connect to the database.
If you are still unable to access the database, contact the support instantly through live chat or through the ticket link https://www.dollar2host.com/clients/submitticket.php?step=2&deptid=1
Note: The “My Little Admin” option has been removed from Plesk because the vendor no longer supports it.
( https://support.plesk.com/hc/en-us/articles/12376955589399-Are-there-any-alternatives-to-myLittleAdmin-in-Plesk-for-Windows-#:~:text=Answer,can%20be%20managed%20via%20Plesk )

Categories
Scroll to Top