Re: Sql Error
2004-02-11 11:01:58
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
|
|
|