Thanks to everyone who tried to help me figure out this problem... although this isn't the best solution, i decided to go with a new Global Group, with the same...

Hi there... sorry for the long response, but was away for a few days.

Anyway, to answer your question, there are no errors whatsoever in the first computer's event log. 

There...

Thanks... i will do that... hopefully someone can help me out with this on the best option.

Basically, options are.

1. Convert Windows 2003 Server to a domain controller (i'm unsure if...

I looked at the link, and based on the info in the page, i can tell you that i'm running our domain in Windows 2K mixed mode...

"When the domain functional...

Ok... TestUser created... Made him a "Small Business User", and logged onto Win2K3 server, no problem...

Made him a part of "TestGroup"...TestGroup was made part of the Group Scope "Global" first.....

Hi, thank you for continuing to help me out with this issue...

Yes... i just tried, and can log onto the server (console) itself with one of the accounts that is in...

Hi Rudy,

I did in fact have a separate Update statistics maintenance plan that runs daily at 10:30pm, which does a sampling of 100% of the database... I don't know if...

Hi,

Does anyone else have any suggestions?  Because of this issue, i'm unable to continue with making this server live...

I was thinking of making the server a domain controller, but...

Hi Rudy,

Thanks for that...  i will look at going through that list and applying it...

I will mention that i have a database maintenance plan which does Optimization (reorganize data and index...

Hi,

Here's a copy of one of the execution plans that may help figure out why this is taking so long...

Here's the Insert statement, from the plan.

INSERT INTO #TempItems  (I.ItemID,...

Well, the tables are indexed (full text indexed)... TitleIndex, AuthorIndex, SeriesName (and a few others that aren't listed above)..

But is it possible that i'm still getting a table scan?  How...

Ok, i didn't know i could capture the plan in profiler.. i'll do that now..

Each table (items/pubitems) have about 80 fields, and not the

Hi,

1. Yes i have tried to delete the account, and readding it...

2. I did use sp_grantlogin to grant login to this group, and i still get the same error.  Even...

Hi,

No, it isn't part of any other group that could be specifically denied... in fact, i don't believe i have any Windows Groups that are specifically denied...

If that was the...

Hi there,

The error i get says the login failed for that particular user, but it is based on the user that is logging in (DOMAIN/User).  This happens to every user...