
UNSOLVED
C
crisargentoIMI
19 Posts
0
1181
March 10th, 2008 04:00
networker mssql module 5.1 (MSSQL 2005) error during schedule backup
Hello Support Forum,
I am experiencing problems backing up MSSQL 2005 using the Networker module 5.1
Backup client is Win2k3
My errors are as follows:
43621 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 35 Computer Name: %s User Name: %s 2 12 5 SCADA 13 13 Administrator
52702 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 33 System Version: %d.%d Build %d %s 4 1 1 5 1 1 2 1 4 3790 0 1 S
37975 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 49 Microsoft Data Access Component(MDAC) version: %s 1 0 11 2.82.1830.0
37978 1205145540 5 0 0 10096 9072 0 scada nsrsqlsv 43 %s(%d): Can't open key <%s> in the registry 3 23 9 sqlutil.c 1 4 9658 23 69 Software\Wow6432Node\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
29446 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 44 Local host has following SQL Server online: 0
37977 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 19 MSSQL server : %s 1 0 11 SCADA\WINCC
37982 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 33 Use Legato Networker Server : %s 1 0 22 mwcnetworker.mwci.zone
37983 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 35 Legato Networker Server Version: %s 1 0 44 NetWorker 7.3.3.Build.510 Network Edition/14
52708 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 17 %s Version: %s %s 3 23 12 nsrexecd.exe 0 15 7.3.3.Build.510 0 0
52708 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 17 %s Version: %s %s 3 23 12 nsrsqlsv.exe 0 9 5.1.0.182 0 42 Supporting SQL 7.0, SQL 2000, and SQL 2005
43337 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 13 Command line: 0
43338 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 4 %s 1 0 151 C:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s mwcnetworker.mwci.zone -g ADHOC SQLTRANSLOG -LL -m scada -l full -q -W 78 -N MSSQL:master MSSQL:master
29085 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 36 Microsoft SQL Server Provider error: 0
38006 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 3 %s. 1 24 69 Named Pipes Provider: Could not open a connection to SQL Server [2].
38006 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 3 %s. 1 24 221 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.
38006 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 3 %s. 1 24 21 Login timeout expired
37955 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 32 \nCannot login to SQL Server %s. 1 12 4 null
43709 1205145551 1 0 0 10096 9072 0 scada nsrsqlsv 13 Stop time: %s 1 35 25 Mon Mar 10 18:39:11 2008
Maybe you have encountered this problem and can give me advice on how to resolve it.
Thanks.
Cris Sargento
I am experiencing problems backing up MSSQL 2005 using the Networker module 5.1
Backup client is Win2k3
My errors are as follows:
43621 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 35 Computer Name: %s User Name: %s 2 12 5 SCADA 13 13 Administrator
52702 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 33 System Version: %d.%d Build %d %s 4 1 1 5 1 1 2 1 4 3790 0 1 S
37975 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 49 Microsoft Data Access Component(MDAC) version: %s 1 0 11 2.82.1830.0
37978 1205145540 5 0 0 10096 9072 0 scada nsrsqlsv 43 %s(%d): Can't open key <%s> in the registry 3 23 9 sqlutil.c 1 4 9658 23 69 Software\Wow6432Node\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
29446 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 44 Local host has following SQL Server online: 0
37977 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 19 MSSQL server : %s 1 0 11 SCADA\WINCC
37982 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 33 Use Legato Networker Server : %s 1 0 22 mwcnetworker.mwci.zone
37983 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 35 Legato Networker Server Version: %s 1 0 44 NetWorker 7.3.3.Build.510 Network Edition/14
52708 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 17 %s Version: %s %s 3 23 12 nsrexecd.exe 0 15 7.3.3.Build.510 0 0
52708 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 17 %s Version: %s %s 3 23 12 nsrsqlsv.exe 0 9 5.1.0.182 0 42 Supporting SQL 7.0, SQL 2000, and SQL 2005
43337 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 13 Command line: 0
43338 1205145540 1 0 0 10096 9072 0 scada nsrsqlsv 4 %s 1 0 151 C:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s mwcnetworker.mwci.zone -g ADHOC SQLTRANSLOG -LL -m scada -l full -q -W 78 -N MSSQL:master MSSQL:master
29085 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 36 Microsoft SQL Server Provider error: 0
38006 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 3 %s. 1 24 69 Named Pipes Provider: Could not open a connection to SQL Server [2].
38006 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 3 %s. 1 24 221 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.
38006 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 3 %s. 1 24 21 Login timeout expired
37955 1205145551 5 0 0 10096 9072 0 scada nsrsqlsv 32 \nCannot login to SQL Server %s. 1 12 4 null
43709 1205145551 1 0 0 10096 9072 0 scada nsrsqlsv 13 Stop time: %s 1 35 25 Mon Mar 10 18:39:11 2008
Maybe you have encountered this problem and can give me advice on how to resolve it.
Thanks.
Cris Sargento
Responses (3)
Solutions (0)
crisargentoIMI
19 Posts
176
0
Posted March 11th, 2008 23:00
i ran client initiated backup using networker sql server user as administrator and it worked....when i put the username administrator and password on the client configuration and ran scheduled backup i get errors...Reply

dgreggs1
86 Posts
176
0
Posted March 10th, 2008 09:00
On your Networker Server in the configuration for the SQL client you need to provide a Remote User Name/Password of a user that has SA rights on the SQL Server you are trying to backup.
Thanks,
Dana