• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Restore msSql database

A

AndreinaP

Guest
All users in the server are getting this error when they try to restore an mssql database

Error: dbbackup failed: Unable to restore database 'PruebaRestore'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

At the server, the event viewer shows the following:
dbbackup.DbBackupException: Unable to restore database 'PruebaRestore' ---> System.Runtime.InteropServices.COMException (0x80040000): [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
at SQLDMO.SQLServerClass.Connect(Object ServerName, Object Login, Object Password)
at dbbackup.DbBackupManager.CollectNeededLogins(String database, List`1 neededLogins)
at dbbackup.DbBackupManager.MsRestore(String database, String backupPath, Boolean dropLogins)
at dbbackup.DbBackupManager.Restore(String database, String backupPath, String netPath, String netUser, String netPass, Boolean dropLogins)
--- End of inner exception stack trace ---
at dbbackup.DbBackupManager.Restore(String database, String backupPath, String netPath, String netUser, String netPass, Boolean dropLogins)
at dbbackup.DbBackupManager.Main(String[] args)

I have gaved full control to everyone over the temp's plesk backup directory, but always the same error.

Please, I need to solve this matter.
Thanks in advance.
 
Back
Top