Login problems...

Question

Login problems...

Ben Griffiths

SSC Journeyman

Points: 79
More actions
June 8, 2004 at 2:16 pm

#102053

I have just installed SQL 2000 onto my machine... running xp pro. It doesnt seem to let me login on enterprise etc... also when i run the service pack 3a file, it comes up with an error, also to do with the login bit. Any help would be greatly appreciated!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

gmmastros SSC Veteran Points: 208 More actions · Answer 1

Without more information, it is hard to say what the problem is.

SQL Server has several authentication methods. SQL Server authentication, Windows NT authentication, and mixed mode (allows either). When installing SQL 2000, you should have been prompted for a password for the SA account. It's possible that you typo'ed the password. I recommend that you log in using NT authentication and then immediately change the password for the SA account.

You should also verify that the SQL Server service is started. Start/Settings/Control Panel/Administrative Tools/services. Look for "MSSQL Server". It should be set for automatic (the service starts when you boot the machine), and "Started". Double click this item in the list. Make sure the start up type is Automatic. Then check the logon tab. the "Log on as" should be set to "Local system account".

The first time I set up SQL Server, I did not use "local system account". I used an actual NT account. The problem I had, several months later, occured when I changed the password for that account. All of a sudden, SQL 2000 wasn't working anymore.

George Mastros
Orbit Software, Inc.

SQLBill SSC Guru Points: 51440 More actions · Answer 2

I agree with George that you aren't giving us enough information to help you. What version of SQL Server 2000 are you using?

How are you trying to login?

-SQLBill

SQLBill SSC Guru Points: 51440 More actions · Answer 3

Also, are there any related messages in the Windows Event Viewer logs (security, application, system logs)?

-SQLBill

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 4

http://support.microsoft.com/default.aspx?scid=kb;en-us;841394&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;841251&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;841252&Product=sql2k

Ben Griffiths SSC Journeyman Points: 79 More actions · Answer 5

Ther version is the latest 120 day evaluation copy, downloaded directly from microsoft. The service itself never actualy starts... The error message I get is

"The service did not start due to a login failure",

then straight afterwards I get

"An error 1069 (The service did not start due to a logon failure) occured while performing this service operation on the MSSQL Server service."

When I installed the software, I just left all the main options as they were, and it used the normal account name for this pc etc... any idea how I could sort this out? This is the first time I have used this software by the way, so newbie would be an understatement!

gmmastros SSC Veteran Points: 208 More actions · Answer 6

Is the logon account set to "Local System Account"?

You can check this by opening the services panel... start/control panel/administrative tools/services

Find the "MSSQL Server" service and double click on it. Then, click on the "Log On" at the top of the window.

George Mastros
Orbit Software, Inc.

Ben Griffiths SSC Journeyman Points: 79 More actions · Answer 7

Just re-installed and set to local account, works fine now, thanks guys