March 15, 2006 at 8:02 am
Hi friends. I have a situation here and I'm wondering if there is a solution to it:
I run SQL2000 from a Small Business Server ("MyServer"), and I already have Enterprise Manager loaded on my domain Workstation ("MyWorkStation").
I develop web application from my workstation and the application needs access to the database. The database is set up to use Windows Authentication only. So, I'd like to add MyWorkStation\IUSR_MyWorkStation as a user of the database.
In the 'New LoginIn' page (the 'General' tab), I type MyWorkStation\IUSR_MyWorkStation in the 'Name' box and click 'OK.' At this point, I receive the 15401 Error: Windows NT User Or Group Not Found. Check the name again.
Obviously, I checked the name many times and it was typed in correctly. So, I'm wondering what is wrong and, more importantly, how this problem can be resolved.
Thanks so much for your help!
March 15, 2006 at 8:29 am
Windows authentication on a sql server will only recognize domain accounts, or local machine accounts (local to the sql server). The local account on your computer will not be recognized.
You can try,
On the sql server create a local machine account called Iusr_MyWorkStation and make the password the same as the password for the IUSR account on your box. Tis is Pass thru authentication. Should work.
But ultimately you'll need to be using domain accounts.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply