This is one of them where "how long is a piece of string" comes in to play.

Unless you know excatly what is thrown through TempDB its a tough one to...

Not to worry, always try the most obivous thing first.

Few questions

Has the users machine dropped out of the...

has the user logged off and back on again after changing his password? if not this is a good place to start as the servers will be trying to...

google the /PAE and /3GB switch for windows boot.ini file as depending on what RAM configuration you need both or just one

then you need to enable AWE in SQL

but you...

configure AWE on your existing 32 bit server, this will increase the upper limit of RAM that the server can address, that way you can assign more than 4GB of...

because the product was not developed for a 64 bit environment

is this a production environment?

if so I would not risk running 2000 on 64 bit operating systems, I would leave it 32bit always.

I was just saying it could be done,...

I know Spotlight on SQL Server Enterprise from Quest has a "configuration" tab, but you have to look at it at sever level you cannot compare side by side (unless...

river1 (11/15/2011)

---

So, you are saying that i can install SQL Server 2000 (with sp4) on an windows 2k8 64 bits but, because SQL Server 2000 exists only in 32 bits...

you can install 2000 on 2008 x64, but as 2000 is 32bit only it uses WoW, need to ensure your running a minimum of SP4 for 2000

I only found this...

good question, but in my morning daze i forgot to click @qoda is created, doh, epic fail on my part

do you have any group policies which applied once the server was in the domain?

it seems like for some reason the accounts are no longer part of the admin group...

I would of said that if the account in SQL is set as disabled then even if you do boot into safemode that it wouldnt make much of a difference...

Dev (11/14/2011)

---

If you have disabled the built-in Administrator account, booting into

Safe Mode will automatically enable it again (temporarily, for that

Safe Mode session).

Disclaimer: NOT TESTED. Post...

when you installed sql and got to the authentication mode page, what account did you add, was it your own windows account or was it the administrators account or a...