Re: Cant seem to find IUSR_MachineName in users using SQLEXPRESS 2005

#1

ARGH! Thanks Brian,

I managed to fight through that (was my inexperience with SQL 2005,
(defining the Logins before defining the Users).

Now I'm faced with a different issue. I finally got my ASP.Net app working
using an ADO interface to SQL Server 2005 to create a crystal report,
exporting to a pdf file (phew!). I was screaming for joy when I finally got
this all working. I began testing, starting with the first report, it ran
for a long time and didn't produce anything. I went back to the first
report I ran, and it ran a long time and didn't produce anything. I opened
up management studio, and IT wouldn't even connect! I got a "Cannot
generate SSPI context" error, out of the blue, after it was already working.
nothing had changed in the meantime, I'm always careful about that.

Anyway, if you have any idea what might have occured, please let me know. I
hope this is not indicative of an unreliable database system.

"Brian Smither" <bsmitherINVALID (AT) INVALIDcitlink (DOT) net> wrote

Quote:

"Rico" <r c o l l e n s @ h e m m i n g w a y . c o mREMOVE THIS PART IN
CAPS> wrote in news:jqQDf.291171$tl.48607@pd7tw3no:

When I import the old database, I'm trying to grant the
IUSR_MachineName account access to the database, but I can't seem to
find that user account.

I can't find that account either, unless...

On one Server 2003, I do not have IIS6 installed/activated (I have not yet
indentified any roles this server will have). On another Server 2003, I
do.
In Computer Management control panel, Local Users and Groups, Users, I see
IUSR_<machinename>.

On the third hand, this built-in name will not show when searching for
objects when adding names to the Security tab of Folder Properties, nor, I
would imagine, any other place where you can pick names of Users or
Groups.

I think it's just a name you have to know about.

Now, SQL Server 2005 Express - I just finished installing that. What a
fracking nightmare!

--
Remove INVALID from e-mail address.

Brian Smither
Smither Consulting

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Cant seem to find IUSR_MachineName in users using SQLEXPRESS 2005

comp.database.ms-sqlserver comp.database.ms-sqlserver

Re: Cant seem to find IUSR_MachineName in users using SQLEXPRESS 2005 - 02-06-2006 , 01:15 PM