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:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Wednesday, February 11, 2004 6:23 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] On Behalf > Of Del > Hoobler > Sent: Wednesday, February 11, 2004 5:40 PM > To: [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
