For SQL Service2000 installation: 1) In general, the most easily installed on your computer is a personal version, and other versions have higher requirements for computers' hardware and operating system platforms. So you can choose to install your personal version installation. 2) In the process of installation For the user's settings, usually only use Windows system login mode. 3) For the selection of installation, the typical installation is an option that does not contain the "Full-text Retrieval", and can only be installed into the SQL service only from the custom from the custom. 4) It is usually installed in an instance, install an instance to the computer, and then the SQL server is platform. This example and full-text retrieval component are default to automatic execution in "Service". Some explanations and problems after installation: 1) After the installation is successful, a server named named system is generated. It includes MSSQLServer. It does not have a direct dependency of the instance, but it is based on instance components and full-text search component services during application, and performs advanced operations and applications. 2) View in the client network tool, check whether the port in the "TCP / IP" attribute in the "TCP / IP" in the "Regular" option is consistent, if inconsistent, the port in the properties makes it . Do not use dynamic ports.
3) Because there are many ways to connect with the server, it is not just some of Microsoft's tools and software, and JDBC may also be used, which requires a SQL authentication user. The usual operation is as follows: (1), using the Enterprise Manager at the server side, and select "Use Windows Authentication" to connect SQL Server;
(2), expand the "SQL Server Group", right-click the name of the SQL Server server, select "Properties", and select the "Security" tab;
(3) Under "Authentication", select "SQL Server and Windows". Otherwise the user 'DSDS' login failed, the reason: not associated with the trusted SQL Server connection. "
(4). "Log in" in the "Safety" fulointment is "New" to set the relevant information in each tab in the dialog.
(5), restart the SQL Server service (you can select the corresponding component instance in Administrative Tools -> Services ", click Restart. Or restart your computer).
4) There is no relationship between ODBC and SQL Sevice, and registration in ODBC is just equivalent to using a database of SQL Service (only set for OBDC-JDBC Bridge).
