how can i backup SQL 2005 Express?

[LioriK]

Hi All,

I'm using Legato Networker ver.7.4 sp4 and i'm trying to backup SQL Express 2005 and i got errors:

* xxxxxxx:MSSQL: 1 retry attempted
xxxxxxx:MSSQL:: No full backups of this save set were found in the media database; performing a full backup
* xxxxxxx:MSSQL: 43708:nsrsqlsv:Start time: Thu Mar 19 09:16:21 2009
* xxxxxxx:MSSQL: 43621:nsrsqlsv:Computer Name: xxxxxx User Name: SYSTEM
* xxxxxx:MSSQL: 29085:nsrsqlsv:Microsoft SQL Server Provider error:
* xxxx:MSSQL: 38006:nsrsqlsv:Named Pipes Provider: Could not open a connection to SQL Server [2]. .
* xxxxx:MSSQL: 38006:nsrsqlsv: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..
* xxxxx:MSSQL: 38006:nsrsqlsv:Login timeout expired.
* xxxxx:MSSQL: 67945:nsrsqlsv:Cannot login to SQL Server Default Instance.
* xxxxxx:MSSQL: 43709:nsrsqlsv:Stop time: Thu Mar 19 09:16:31 2009
* xxxxxx:MSSQL:

I enabled Remote connections.
Can you please tell how to fix this problem?

Thanks, Lior.

 

[a060463xyz]

You try to connect with username=SYSTEM.
Chjange your client settings and connect with an server or domain admin.

 

[LioriK]

I tried to connect with a domain user & local user,
this didn't helped.
do you have any other solution for this?

Thanks, Lior.

 

[tbozzio]

Have you tried specifying the saveset as MSSQL$SQLEXPRESS: instead of MSSQL:?

Can you perform a manual backup of databases through the Networker Module for MSSQL?

Do flat-file backups work for the same client?

Take a look at INF: TCP Ports Needed for Communication to SQL Server Through a Firewall -

http://support.microsoft.com/kb/287932