Prev: Placing a SUM amount into a column
Next: Optimizer on SQL 2005
From: Bev Kaufman on 2 Feb 2010 14:53
I keep a copy of Sql 2000 on my workstation for those clients who are still
on the old software. About a year or so ago, my network user was changed
from bev to bevk so it would be consistent with other users. I hadn't had a
problem until now, when I was asked to test something on Sql 2000.
The job failed to run because it still had the login bev instead of bevk.
But when I try to create the bevk login, I get error 15401: Windows NT user
or group 'MCRCORP\bevk' not found.
I checked the control panel, and user MCRCORP\bevk most certainly does
exist, with Administrator rights. What is going on?

From: Jay on 2 Feb 2010 16:55
MCRCORP\bevk sounds like a network/Active Directory login, while anything in
your control panel would be a local Windows user.

Try deleting the "MCRCORP\bevk" and replacing it with "bevk". That, or
switch from Windows auth, to SQL Server auth.

"Bev Kaufman" <BevKaufman(a)discussions.microsoft.com> wrote in message
news:1BBA2A3F-45BF-47A6-830C-EEF71D4A0A78(a)microsoft.com...
>I keep a copy of Sql 2000 on my workstation for those clients who are still
> on the old software. About a year or so ago, my network user was changed
> from bev to bevk so it would be consistent with other users. I hadn't had
> a
> problem until now, when I was asked to test something on Sql 2000.
> The job failed to run because it still had the login bev instead of bevk.
> But when I try to create the bevk login, I get error 15401: Windows NT
> user
> or group 'MCRCORP\bevk' not found.
> I checked the control panel, and user MCRCORP\bevk most certainly does
> exist, with Administrator rights. What is going on?
>


 | 
Pages: 1
Prev: Placing a SUM amount into a column
Next: Optimizer on SQL 2005