Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Windows Backup and SQL 2005

Author  Topic 

dboiler1
Starting Member

39 Posts

Posted - 2007-02-08 : 18:27:34
I know I've been posting a lot about another problem but you all have been most helpful so I thought I'd throw this one at you too.

My nephew's company has a server with Small Business Server 2003 SP1 and they run Windows Backup for their daily backups. They also have SQL 2005 Workgroup on that machine. Prior to SQL 2005, they ran SQL 7 and had no problems with their daily backups. Once they upgraded (clean installed actually) SQL 2005 their backups fail. The event log errors with Event ID 6013 and says:

SQLlib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr=0x80004005 SQLSTATE: 08001, Native Error: 17 Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error Message: [DBNETLIB][ConnectionOpen[Connect[]].]SQL Server does not exist or access denied.

Obviously, SQL Server does exist, so I presume it has to do with an access denial. Microsoft has been no help and Googling other sites have gotten nowhere. DLL updates have been done and hot fixes installed. But the error persists.

Any ideas of where he should look?

Thanks in advance

Dave

Kristen
Test

22859 Posts

Posted - 2007-02-09 : 00:59:43
"SQL 2005 their backups fail"

How are they trying to make the database backups?

Kristen
Go to Top of Page

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-02-09 : 01:18:25
If they are running the backup using remote connections...see the following blog..
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx


MohammedU
Go to Top of Page

dboiler1
Starting Member

39 Posts

Posted - 2007-02-09 : 20:18:38
They do a standard SQL backup job for their daily backups, Full. Windows backup just croaks when it tries to backup anything SQL with the above Event ID.

Thanks,

dave
Go to Top of Page
   

- Advertisement -