My batch file statement is:
expressmaint -S (local) -D ALL_USER -T DB -R d:\reports -RU WEEKS -RV 1 -B d:\Database_Backups -BU DAYS -BV 1 -V -C
Expressmaint error: Failed to connect to server (SERVERNAME\SQLEXPRESS).
Expressmaint error: Failed to connect to server (local).
Expressmaint error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL
Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Remote connections ARE set to be allowed in Surface Area Configuration, using both TCP/IP and named pipes.
Batch file is being run locally and manually by local administrator account, which has SysAdmin rights on the instance.
Hope you can help...
Thank you, Tom