2 replies
by dr. soft
You didn't mention the tool you are using for administrating you SQL server. Something like 'Enterprise Manager' that only ships with a full blown lisnced version of SQL Server 2000.
If you don't have any thing to manage the sql server then proceed as follow;
Un-install your current server installation and restart the PC. Re-install the SQL Server and at its step-7 titled 'Services Accounts' check the Radio-button 'use the same account for each service' and under the 'Service Settings' heading, check the radio-button 'Use the local system account'. Thats all what is needed.
INSTALLATION PROCEDURE FOR SQL SERVER:
Run SQL_Standard_2000\setup.bat from CD.
Click Next
Select Local Computer option and Click Next
Select create a new instance of SQLServer or Install Client Tool option and click Next
Select Server and Client Tool option and click Next
I have mailed u to your e mail id too
Click Next by selecting Default option
Select Custom option and click Next
Click Next by Default Seletion.
Click Next by selecting the option as shown
Select Mixed mode option and enter pwd ?? and click Next
Select Collation Designator Option, select Latin1_General from the dropdown List Box and Check the Binary Option from the Sort Order
In order to set the collation as Latin1_general_BIN.
Click Next
Click Next
Select per seat for option, devices=50 and click Continue.
Service Pack Install
Run \SQL_Standard_SP3A\SP3A\setup.bat from CD to install servicepack3
Click Next
Click Next
Enter PWD ?? and Click Next
Click Continue by selecting the option as Shown
Click OK
This discussion is closed to new replies.
Trending Networks posts
Sort by Trending