Hi - yes I know this problem of old. If you want to use pass-thru authentication (users windows account's credential are passed into SQL) you have to have IIS and...

Thanks very much for your help, appreciate it.

That's the one I use, however it is always static, as in the maximum amount it has needed since the last bounce because it doesn't release it, does it, unless...

It may/not be relevant to you as you stated that your instance was receiving a mixture of connections, but to pick up on one of the replies about checking what...

Resolved it! We looked at the Office XP product id and all the PCs that had the problem had the same id. The PCs that worked were different. Re-installing the...

Thanks very much for your suggestion but one of the people who has the problem actually has the full SQL Server dev install with Analysis Services both on SP3. This...

Hi Francisco. In my experience a sweating SQL Server benifits hugely from 'placing for performance'. Your proposal looks OK, if you can afford RAID0+1. That would always be my preference...

Steve, thanks everso for your contribution. Could you please tell me whether you favour RAID1 for logs because a)it's faster than R5, b) it's less expensive or c) more resilient....

If possible I always use domain accounts/ groups then the SIDs are the same always and the mapping is automatic whatever server the db is restored to. If I have...

What was the default database for that login? I've had odd errors before when the default database is not what it should be.

Hello. Had the same problem. See Q273572 to resolve it.