August 8, 2003 at 1:24 am
the mssql server 2000 i am using on my server is runing but it shows it is stoped and i cann't logon to it using user id and password nor with windows authentication i just did one thing that is
You cannot use a SQL Server Standard security login account after a Typical installation of SQL Server 2000 until you change the authentication mode to Mixed.
To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use the following steps:
Open the Enterprise Manager.
Expand a Server group.
Right-click a server name, and then click Properties.
Click the Security tab.
Under Authentication, click the SQL Server and Windows option button.
Restart SQL Server in order for the change to take effect.
and after that the problim come can anybody help
thanks
August 8, 2003 at 3:06 am
Are you sure it's running?
Cheers,
- Mark
Cheers,
- Mark
August 10, 2003 at 7:44 am
Check the error logs and the event log, that should show it's state, can also check running processes of course. Going from NT only to mixed should not break anything.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply