I've had similar problems and never really understood the root cause. But when we would delete/recreate an account or renamed an AD account, the account would no longer be valid...

Two ways that I know of ...

1)

SELECT ServerProperty('IsIntegratedSecurityOnly')

1 = Integrated Security

0 = SQL & Integrated Security

2)

EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode'

1 = Integrated Security

2 = SQL & Integrated Security

http://www.experts-exchange.com

Matt Rose (1/23/2008)

---

that worked to a point...there are 2 users which i can't get to not be orphaned...

one of em is a regular user who is a sys admin and...

I don't know how you plan on implementing it, or your environment size, but what I did was create a simple VBScript to loop through a control table that has...

http://bwunder.com/ArchiveUtility.aspx

I've been using this product for almost 2 years now, and I absolutely love it. I've been demo'ing his newest version and I'll tell you what, it's got a lot...

I'd highly recommend staying away from SQLMail in SQL2000 ... it's a nightmare.

Instead, there is an easy solution ... upgrade to 2005 and use database mail! 🙂 If that's possible,...

asif_ku (1/23/2008)

---

First of all thanks for quick respond!

Yes, that folder exisit on same machine where Sql server is running.

I am not sure how to give permission to that folder? Can...

Well, ensure your test machine has the matching logins ... once that is completed, you can run this to sync up your orphaned users to the corresponding login:

sp_msforeachdb

'USE ?

DECLARE @username...

GRANT EXECUTE TO RoleOrUser

When you view the job, does it show you the name of the DTS it is calling or is it encrypted? Regardless, at the job level there may be parameters...

Are you using version 4.8? If so, there is a known problem with Litespeed backups over 4GB resulting in a similar error. They released a hotfix and a new version...

I've been using this utility (which he promises a 2005 version soon) for over a year and absolutely love it:

http://www.sqlservercentral.com/products/bwunder/archiveutility/

Is the SQL Server Browser service running?

removed