Hello i don't know if this is the r

[jl3574]

Hello i don't know if this is the right forum to create this thread.

i am having a hard time gettin my sql server to connect .i installed Microsoft SQL server (developer edition) to run on my win xp
after installation when i open my sql server service maneger to connect it said the following

" AN error 1-69 - (the service did not start due to a logon failure) occurred while performing this service operation on the MSSQLServer service."

How the option i uses to install MS SQL server is both client and server tools , domain system account and window authentication mode

also when i tryed opening up SQL server enterprise maneger under edit sql server registered properties i try to set it "sql server authentication" it said fail sql server does not exist or access denied

i don't know what i'm doing wrong? did i install it wrong?
i need to use client and server tools so i use developer eddition. please help !!

 

[Nowell]

Hi,

There must be a 'sa' password that you are not setting correctly, do you know what the password is?

 

[SQLBill]

When you first set up SQL Server, you use the SA account. You then need to add logins to allow access to the database. Set your database back to Mixed Authentication. Regisgter the server in Enterprise Manager using the SA account. Go to Security>Logins and create a new login with your account information (making yourself a sysadmin). Then switch the server back to Windows authentication only.

-SQLBill

 

[mrdenny]

It sounds to me like the service isn't starting.

Make sure the service is starting. From the error you gave, it sounds like the account that you entered to run the SQL Server doesn't have the correct username or password.

Try starting the service manually from Computer Managment or from dos and see what it says.

Denny

Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.