ADSM-L

Re: Sql Error

2004-02-11 10:40:28
Subject: Re: Sql Error
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 11 Feb 2004 10:39:52 -0500
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 

<Prev in Thread] Current Thread [Next in Thread>