I did not have any luck using ADSI:// myself. Only when switching to use LDAP:// did it work although it sounds like you had a few things going on simultaneously....

How is it going?

surma.sql (8/15/2012)

---

hello

i have question about SQL Server Jobs

I check the job properties and see the username is 'SA'. and i check into steps and there is no user is specify...

Suresh B. (8/15/2012)

---

Job does not run under owner's account.

1) If you run a job manually, it runs using your login.

2) If schedule it, job runs using SQL Server Agent service...

Catch it from where? In T-SQL or an app language like C#?

If your supplying a severity level of 10 then it will not trip a T-SQL CATCH block. Your RAISERROR...

No need to script them out. You can generate a command like this for each user with the new login for each. Just make sure you supply the NAME option...

Does this occur when you first start the server or intermittently after running for a while? The problem is likely related to the storage subsystem temporarily being viewed as offline...

Stairway to Data by Joe Celko[/url]

Moving User Databases (SQL Server 2008 R2)

Try it with LDAP instead of ADSI:

Select [Name] ,[DisplayName]

From OpenQuery

( ADSI,'SELECT name, displayname FROM ''LDAP://RHSPWDCOC02''

WHERE objectCategory = ''Person'' AND objectClass = ''user''')

I won't say incorrect because your situation may truly be unique, but personally I think you're approaching this from a very difficult angle, i.e. trying to contort the database server...

Pablo Campanini-336244 (8/16/2012)

---

YES......

You are absolutely right, I am using SQL Server 2008, not SQL Server 2008 R2, and the bug is killing me!!!!!!.

I will ask my boss to upgrade to...

Happy you got it sorted. I was curious so I did some looking to see if others had this issue and it looks like it may be a known bug...

Lynn Pettis (8/15/2012)

---

User abc is related to the LOGIN imstestuser. You then subsequently create a new login abc. This login is not the same as the user abc.

Flip...

Pablo Campanini-336244 (8/15/2012)

---

Hi

The command:

CREATE USER abc FROM LOGIN testLOGIN

creates a "database" login, not a SQL Instance login.

Please create also the sql ID at an Instance level.

Then connect to the SQL...