mssql

Hello, We have noticed that the MSSQLSERVER2019 is randomly stopped. We have to manually start it from the services management. How to find the reason for this? Where we can see the logs related to it? Thank you

Hello, According to this article:  How to install the sqlsrv extension for the Plesk PHP handlers? (https://support.plesk.com/hc/en-us/articles/12377482190999) I try both options explained, but not works. 1) pdo_sqlsrv and sqlsrv-5.8.1 on CentOS 7 with PHP 7.2 I just try also install sqlsrv...

I am trying to connect to MS SQL from php I use: $conn = new PDO("dblib:Server=$serverName;Database=$base", "$user", "$pass"); but it seems that my server is missing PDO DRIVER, I only have: PDO drivers mysql, odbc, pgsql, sqlite and I got: Got error 'PHP message: PHP Fatal error...

Hi I need help, I have added a godaddy ssl for my webpage and it works fine. But I am still getting this message. Dose this have to with the Plesk admin ssl. I don't have any there and its only accessible via VPN localhost.

Hi i use this command for backup MySQL Database in Plesk Obsidian and Windows Server 2016 : cd C:\Program Files (x86)\Plesk\mysql\bin mysqldump.exe -uMyUsername -pMySamplePassword -P3306 SampleDatabse > D:\BACKUP\MySQL\SampleDatabse.sql BUT i can not find command for Get Backup ( MS SQL...

Hello, i want to connect with my database in Microsoft SQL Server. I use default install on plesk Microsoft SQL Server: And upload here my database I. Next i check settings: II. I check settings in Sql Server Configuration Manager and set port to 1433 III. In the end i add rule in...

Hello It's not comun, but we have recieved sometime request about our clients to have mssql driver for php on our web hosting in plesk/linux. I join you today an oficial link to microsoft website that explain perfectly how to do it, it's very easy. Hope that can help someone!

Hello, By mistake we have changed the password for "sa" user on MS SQL instance directly from SSMS. Once this has been done, we're unable to make any changes via the Plesk panel. It says "Error: The test connection to the database server has failed because of an unacceptable password...

I have a bunch of sites setup in Plesk. Most of them are running MSSQL hosted by the same server. Each database is supplied with it's own MSSQL login credentials. This allows me to connect to each database remotely. I disabled the sa account because it's extremely bad practice to expose this...

Is there any way to activate the MSSQL extension in PHP 5.6 using plesk ?. 2 days ago I'm looking for information and I do not find anything clear. i want connect my websyte to remote windows 2008 server with SQL 2008 Server. Thanks.

Hi we are trying to connect to MSSQL from our plesk server, but when we run the page we get this error: mod_fcgid: stderr: PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in <file name>...

TITLE: Internal error: path is out of webspace, 'Hosting Settings' and 'FTP Access' PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE: Plesk Onyx Version 17.0.17 Update #21,‪ Microsoft Windows Server 2012 , R2‬, MySql local engine PROBLEM DESCRIPTION: I have recently used the Plesk Reconfigurator...

Hi Guys, I've recently created a C# site and uploaded it to Plesk servers. I also created a DB and link it with the site. Once I do this and I create a user for the DB as well, I try to connect to that instance of MSSQL remotely using SSMS (everything goes nice and smooth). Once the remote...

I am brand new to the Plesk world, but recently purchased an Onyx license and had been evaluating it and everything had been looking great. I contacted Plesk support in regards to MSSQL database management and the person I talked to said I could use myLittleAdmin, but apparently that has a...

Hello. We have a windows server 2008 R2 with running plesk 12.x on that. When we want to restore database backup, this error occurred: The following objects were not found in the backup file:nafisfiledata:mssql:localhost: And when we checked the backup files, we found that the backup files...

Hello. Do I need to install mssql on my server and license it to enable that feature or it's include in the plan? Thanks in advance - Tal.

I have a .bak file and I need to upload this database. And I don't know how to upload it.