SQL service2000 Installation Operations FAQ

Problem
For SQL service2000 Installation: 1 in general, the most easily installed on the computer is a personal version, the other version of the computer hardware and operating system platform has higher requirements. You can therefore choose to install a personal version of the installation. 2 in the installation process for the user's settings, usually only the use of Windows system Landing mode. 3 for installation choices, a typical installation is an option that does not include full text search, and only select the component from the customization to install to the SQL service. 4 usually installs as an instance, installs an instance to the computer, and then the SQL Server takes it as the platform. This instance and the Full-text retrieval component are automatically executed by default in the service. Some explanations and problems after installation: 1 after the installation is successful, a server with the name of the system will be generated. It includes MSSQLServer. It is not directly dependent on the instance being installed, but it is an advanced operation and application that is based on the instance component and the Full-text Retrieval component service in the application process. 2 view in the Client Network tool, in the alias option, view the ports in the corresponding server and the ports in the properties of "TCP/IP" in the general, and then modify the ports in the properties to make them consistent. Do not use dynamic ports.



3 Because there are many ways to connect to the server, not just some Microsoft tools and software, but also the possibility of using JDBC, which requires a SQL authentication user. This is typically done as follows: (1), use Enterprise Manager on the server side, and select "Use Windows Authentication" to connect to SQL Server;

(2), expand "SQL Server Group", right click on the name of SQL Server server, select "Properties", and then select the "Security" tab;



(3) Under Authentication, select SQL Server and Windows. Otherwise, the user ' DSDS ' login fails because it is not associated with a trusted SQL Server connection.



(4). Under the security Fulcrum, right-click and select New to set up relevant information in each tab in the dialog.

(5), restart the SQL Server service (you can select the corresponding component instance in the Administrative Tools-〉 service) and click Reboot. or restart the computer).

4 The last ODBC has nothing to do with SQL Sevice, registering in ODBC is just the equivalent of a database using a SQL service (only set up for the Obdc-jdbc Bridge).