Re: SQL2000 backed by Veritas BackupExec9 on newly migrated W2003

Hi Tibor,

Thank you for your posting. I agree, this is not much to go by except that
there is obviously a change in the permissions somewhere that is preventing
BackupExec from accessing the SQL server. Since the backup server to SQL
communication at the OS level is working, I doubt that it is a permission
issue regarding drives, it seems more like either a Veritas SQL client issue
or an issue with SQL server permissions as the Veritas server will backup th
e
local SQL DB but not the remote SQL server DB. What do you think?

"Tibor Karaszi" wrote:

> This doesn't give us anything to go on. The application (BE) executes some
 SQL statement which
> fails. We don't know the statement, nor the SQL Server error message. I su
ggest you talk to Veritas
> about this.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> http://www.sqlug.se/
>
>
> "aabrams" <aabrams@discussions.microsoft.com> wrote in message
> news:8D728A16-E573-4906-99FF- C4D4AFF46478@microso
ft.com... 
>
>
>

Hard to say as I don't really know the BE architecture. Does it have some ki
nd of log? Or perhaps
you can run Profiler and through that try to capture which SQL statement goe
s wrong (assuming it is
a SQL statement)?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
http://www.sqlug.se/


"aabrams" <aabrams@discussions.microsoft.com> wrote in message
news:D79771A6-F14F-4AD5-8BC5- BB3E7AAD148A@microso
ft.com...
> Hi Tibor,
>
> Thank you for your posting. I agree, this is not much to go by except that
> there is obviously a change in the permissions somewhere that is preventin
g
> BackupExec from accessing the SQL server. Since the backup server to SQL
> communication at the OS level is working, I doubt that it is a permission
> issue regarding drives, it seems more like either a Veritas SQL client iss
ue
> or an issue with SQL server permissions as the Veritas server will backup 
the
> local SQL DB but not the remote SQL server DB. What do you think?
>
> "Tibor Karaszi" wrote:
>