[Veritas-bu] SQL for NT Agent Configuration

Before I start making assumptions did you do these steps?  

You have to configure a user DSN.  And you must be LOGGED in on the nt box
as the user you plan to setup the dsn for while setting up the dsn.  The
netbackup client service must also login as that user.  

After that you have to start up the dbackup nbu sql client gui from the
command line with these switches.

dbbackup -mssql -dsn "name of the dsn you created" -u "user" -p "password -
sorry but it's just once"

You'll get a can't connect error and the gui will bring you into its dbms
setup.  There you make sure nbu is logging in with the dsn you setup.



Simon Lurye
Senior Consultant
Veritas Software


-----Original Message-----
From: Keahey, Ricky L [mailto:ricky.l.keahey AT intel DOT com]
Sent: Thursday, August 31, 2000 1:02 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] SQL for NT Agent Configuration


I am trying to get the NBU SQL client working on an NT4 with NBU 3.4 and SQL
7.0.  I keep getting the following error when I try to enter the DBMS from
the command line.  This is what shows up in the dbbackup log file.

16:50:03 [312,262] <32> CODBCaccess::CreateDSNlist: ERR - Error in
RegQueryValueEx, opening <SOFTWARE\ODBC\ODBC.INI\qastatsdb4\Server>: 2. The
text follows:
16:50:03 [312,262]     CONTINUATION: - The system cannot find the file
specified.
16:50:05 [312,262] <32> CDSNaccess::LookUpInstance: ERR - Error in
RegQueryValueEx, opening <SOFTWARE\ODBC\ODBC.INI\qastatsdb4\Server>: 2. The
text follows:
16:50:05 [312,262]     CONTINUATION: - The system cannot find the file
specified.

I have configured the ODBC user DSN and did the test and it passed.  It
keeps coming up saying that it can't access the ODBC and because of that, I
can't get to the databases on the NBU SQL Client.

Does anyone have a clue as to what could be going on here?  This is a SQL
7.0 server that I am trying to connect to.

Thanks,
Rick Keahey

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu