• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

mssql

  1. Systems

    Question install php-mssql (php 5.4)extension or pdo_sqlsrv / sqlsrv extension (php >= 7.2)

    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...
  2. B

    Question how to install MS SQL drivers for PDO

    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...
  3. S

    Issue Need help: SQLSTATE[08001][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider

    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.
  4. E

    Question Backup Database MS SQL Server by Command Line in windows

    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...
  5. X

    Issue Can't connect with MSSQL Database

    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...
  6. S

    Instruction Add mssql odbc drivers for php on plesk linux server 2020-01-18

    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!
  7. N

    Resolved Update sa password for MS SQL from plesk

    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...
  8. J

    Issue Is there a way to configure Plesk to use a Windows Authentication login?

    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...
  9. L

    Issue MSSQL Extension on PHP 5.6

    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.
  10. Noam Harel

    Question mssql connect

    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>...
  11. Greg Eslick

    Resolved Internal Error path is out of webspace, hosting settings and ftp access

    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...
  12. N

    Resolved Connectivity between website and DB

    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...
  13. RubyHaus Inc.

    Issue myLittleAdmin Licensing

    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...
  14. C

    Issue .tmp instead of .sql file in backups.

    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...
  15. T

    MSSQL licensing

    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.
  16. A

    How to upload .bak file in MSSQL Management Studio?

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