sure. SQL Server runs as a service. It is always running, even when no one
is logged in. In order to do that, it has to "pretend" to be a person who
is "logged in" to the computer. (oversimplification)
You have to provide the account for SQL Server to run under. This gives you
the ability to control what privileges should be afforded to a proc running
in SQL, because you can change the permissions on any account.
Apparently, the password has expired on the account you provided when you
set up SQL.
How to change the account:
Start->Settings->Control Panel->Administrative Tools->Services
Find the entry for MSSQL. Double-click it.
This is usually a tabbed dialog. On my XP machine, I have a tab for "log
on" where I can provide the account to log on as. I don't remember what the
dialog for Win2K is, but you can find it by looking around. Normally, the
OS gives you the choice of running a service as the "local system account"
or as a specific user account. I usually pick the local system account for
SQL Server, but if you want to use a different account, that's fine. Just
make sure that the account you use has the necessary rights to let SQL
Server run.
Once you change this setting, look to see if you have another service for
SQL Server Agent. This is related to SQL Server, and has to be running
under the same account.
Unfortunately, I don't remember most of the names of these services. The
machine I am typing on is a home system, and I can't just pop over to my
services dialog an peek, unfortunately. I hope you don't have any trouble
finding them.
Good Luck,
--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"dcinfinite" <dc********@discussions.microsoft.com> wrote in message
news:9C**********************************@microsof t.com...
Thanks alot..it worked..
i have another problem actually..now i've solved the problem with setting
up Visual Studio.Net n IIS. i have a problem with SQL 2000 server. I've
installed it b4 and it worked perfectly, but this time it didnt work
eventhough i installed it in the exact way..when i try to start the SQL
server .. an error message saying "the service did not start due to logon
failure" ..."error 1069 occured while performing this service operation on
the MSQL Server service"
do u have any idea?once again..thanks..