SQLserver database connection

Source: Internet
Author: User
Everyone knows that to program a database, you must first connect to the database. Today I will talk about how to connect to the database: if your computer has been installed with the SQLserver database, then you can connect (my name is SQLserver2008). First, open "START" → "Program" → "MicrosoftSQLs" according to the following steps.

Everyone knows that to program a database, you must first connect to the database. Today I will talk about how to connect to the database: if your computer has installed the S QL server Data Base, then you can connect (My SQL server 2008). First, open "START" → "Program" → "Microsoft SQL s" according to the following steps.

As we all know, to program a database, you must first connect to the database. Today I will talk about how to connect to the database:

If your computer has been installed with the SQL server database, you can connect to it (My is SQL server 2008)

First, follow these steps to open "start"> "program"> "Microsoft SQL server 2008"> "SQL server manage", and then you will see the screen, according to your settings, enter the information and click "Connect". The database will be accessed.

Then you will see the same content as the image below

Of course, the database connection may fail. You should check your database configuration at that time:

Follow these steps to open "start"> "program"> "Microsoft SQL server 2008"> "configuration tool"> "Configuration Manager". Then you will see

If a project does not run in the status bar, right-click the "Start" button in the displayed dialog box and you will see the following content:

This indicates that your database can be used. If the start button cannot be used, you can try the following steps:

1. run the cmd command window as an Administrator and enter "net user Administrator/Active: yes" and press Enter. After this step, the computer will not be able to see any reaction, but the "meaning is included ".

2. log out of the computer. Don't worry. It will definitely start up.

3. An account is displayed, which is the administrator account. Click the account profile to enter the account.

4. Right-click the name that cannot run normally --> properties --> service --> Start mode, set start mode to automatic, and OK.

Now you can start the database.

Of course, the SQL server database may not be installed on your computer, which does not matter, but you must understand the environment requirements (including hardware and software) for SQL servers installation before installation) note the following before installation:

1. If you do not reinstall SQL Server, but upgrade the old SQL Server, back up useful data before installation.

2. Disable running SQL Server instances

3. Close the Window Event Viewer and registry administrator.

4. Log On As a system administrator

5. Check in advance whether the software and hardware configurations meet the system requirements.

Notice the problem above, the next installation is simple, follow the prompts to take it easy.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.