Hi Del

First thanks for suggestions but the solution was so stupid. The original
name for the SQL database was VIRTUAL_BACK (tdpsql.cfg) anyway the
administrator of this machine change the name when doing maintenance to
VIRTUAL-BACK !!!!!!!!!!!!!!!!!!!!!

Making the change to the tdpsql.cfg again and everything now is running
perfect.

So sorry for bothering you guys and apologize .....

Regards Robert  

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Del
Hoobler
Sent: Wednesday, February 11, 2004 6:23 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Sql Error

Robert,

You might want to read through this Microsoft KB article (Q328306):

 
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql

to see if anything helps. If not, it sounds like you may need to contact the
IBM Support Team. They can obtain a trace and find out where things might be
going wrong.

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/11/2004
10:59:28 AM:

> Hi del
> 
> When running  TDPSQLC QUERY SQL * /SQLSERVER=servername got exactly 
> the
same
> error when doing the restore ....
> 
> You are right I think too that the TDP isn't talking to local SQL 
> server correctly , but when running some queries (select ....) on the 
> database everything is O.K
> 
> Regards Robert
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
Del
> Hoobler
> Sent: Wednesday, February 11, 2004 5:40 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Sql Error
> 
> Robert,
> 
> Looks like Data Protection for SQL is not talking to the local SQL
server
> correctly.
> What happens when you issue this command:
> 
>    TDPSQLC QUERY SQL *
> 
> Can you connect to the SQL server that way?
> Are you running on a cluster?
> Is it a named instance?
> Have you tried specifying the SQL Server name using the 
> /SQLSERVER=servername option?
> 
> For example:
> 
>     TDPSQLC QUERY SQL * /SQLSERVER=servername
> 
> where "servername" is the virtual SQL server name or the names instance?
> 
> Thanks,
> 
> Del
> 
> ----------------------------------------------------
> 
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/11/2004
> 09:48:15 AM:
> 
> > Hi to all
> > 
> > When trying to restore a SQL Database on a different machine got 
> > this
> error
> > message:
> > 
> >    Starting Sql database restore...
> > 
> > ACO5424E Could not connect to SQL server; SQL server returned:
> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not 
> > exist
> or
> > access
> >  denied.
> > [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
> > Microso
> > ft SQL-DMO (ODBC SQLState: 08001) (HRESULT:0x80040000)
> > 
> > 
> > My command is: tdpsqlc restore campus full /fromsqlserver=highlearn
> > 
> > When I do a  tdpsqlc query tsm query tsm * /fromsqlserver=highlearn 
> > I saw all the backups …….
> > 
> > The SQL database on this machine is working correctly and started ...
> > 
> > My TDP for SQL version is: 5.1.5.0
> > 
> > Any help will be appreciate …..
> > 
> > 
> > Regards Robert Ouzen
> > E-mail:   rouzen AT univ.haifa.ac DOT il