Problem in login to server

[Eli20]

Hi, i am trying to install Miscrosoft SQL Server 7.0 in a newly formatted Windows XP pro computer.
i had installed it perfectly before i formatted.

now when i try to install the startndard edition, it sais it can only install me client components, so i installed the desktop edition, and i have the server and all, but it sais it has a problem of login, it doesnt specify the problem.

does anybody know what the problem might be??

thank you very much

Eli

 

[nigelrivett]

Did you allow mixed security?
If not try changing the registry to allow it

The registry entry will be something like

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLServer\LoginMode

Change it from 1 to 2 then restart the server.
Now try to log in with sa and no password.
Make sure you set a password shortly afterwards - the service pack which you must apply will suggest it anyway.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[mrdenny]

Standard Edition can not be installed on the workstation OS. Standard and Enterprise SQL editions require the Server OS.

For the password problem, refer to Nigel's post.

Denny

--Anything is possible. All it takes is a little research. (Me)