SQL2000 has its own management interface.Open SQL Manager and select Windows Authentication. The SA password is set when SQL is initially installed and cannot be viewed.
First, you need to determine whether the database is in the SQLSERVER installation directory or somewhere else.If it is in the installation directory, you must copy it first. Generally, two files are copied, one is the data file (*. mdf), and the other is the log file (*. ldf), which is placed in other partitions or other directories.Then reinstall SQL SERVER;If the database itself is in another partition or directory, you can reinstall SQL SERVER directly..No data needs to be considered.
After installation, attach the database, and it is OK..
To view the SA password of SQL Server 2000, you usually need to use command line tools, such as SQLCMD, or use System Management ->Security ->Login in Enterprise Manager.First, open a command prompt to run as an administrator, and then enter 'sqlcmd - U sa - P' (leave blank and do not enter a password). If the connection succeeds but the password is required, it is the SA's unencrypted password.Open Enterprise Manager: Double click the SQL Server Management Studio icon in the installation directory, or search for Enterprise Manager from the Start menu, and click it to open it.Remember that the first time you run it, you may need to set permissions or accept the license agreement
