Customer is using non-standard port for SQL Server. Site security does not allow the creation of an alias or to enable named pipes. Would like to be able to specify the servername,portnumber when registering the SQL Server from the LiteSpeed Console. Server registers properly but gets an oledb connection error when trying to backup via the LiteSpeed console. OLE DB Error Connect failed. (hr=80004005). Error: 10901, Msg: Failed to login to SQL Server
WORKAROUND 1
Had customer create a backup using the LiteSpeed UI and did not run. Selected preview script and copied into SSMS.
exec master.dbo.xp_backup_database
@database = N'Admin',
@servername = N'servername,portnumber', >>> added this line
@backupname = N'Admin - Full Database Backup',
@desc = N'Full Backup of Admin on 11/16/2011 11:07:15 AM',
@compressionlevel = 2,
@filename = N'C:\Test.bak',
@init = 1,
@with = N'STATS = 10'
GO
Executed from SSMS and backup was successful.
WORKAROUND 2
Upgrade to Netvault LiteSpeed for SQL Server 7.0 or later.
