Ours is a SuperMicro.  3 days now without problems.  My worry factor is dropping.

FYI on my previous post, regarding memory, we're 64 bit on Win 2003 64-bit, no SServer SP applied.

Same problem here, happening once daily.  Saw discussion that suggested limiting sql server memory to be less than physical memory.  Since it can't hurt, I gave it a try and...

use the following:

EXEC sp_helprotect NULL, 'rolename'

An error of 401 Unauthorized probably means you

a) Don't have default access to the database the report draws from

b) Are using an SSL connection and forgot to enter username/password

If your...

I've basically got the same problem, only it doesn't have anything to do with Cognos. It's just on a production MSSQL 7 database I'm DBAing.

I'm new to using MSSQL...

Any further updates?

Just wanted to post our findings here to maybe help others. It was an issue with the Access front-end. Created a new mdb, file, import, select all, select...

I'm having the same problem. Exact same circumstances except mine will only come up with that error sporadically.

I am trying to the get contractor back in here to look at what's going on as when I change from sql authenication to trusted (by adding guest as an...

the code i am using to connect to the database is the identical class that i have used for countless projects in .net 1.1 and vs 2003 so i don't...

The problem is caused by not having variables large enough to store the encrypted data. Because SQL Server was cutting off the encrypted data, decrypting wouldn't work. I...

Thanks, Journeyman; unfortunately, the article didn't help. It's about using encryption in .NET, not SQL Server 2005... Does anyone else have any ideas?

PW, thank you for fine tuning my code, as you can see, I am still very new to SQL. Here is what I have, but I am still getting...