VC2008连接SQL2005开发总结

1. Install VS2008

2. Install SQL2005 and SQL SMSE2005(Server Manager Studio Expree)

     You should donwload them on the Microsoft website. The SQL SMSE2005 also is free for download and development.

3. Configuate SQL2005 Server.

     Step is below:

     A.  Run "StartMenu---->All Program---->Microsoft SQL Server 2005---->SQL Server 2005 Surface Area Configuration".

          1). Click "Surface Area Configuration for Services and Connections"

          2). Please find items such as "Local and remote connections---->Using both TCP/IP and named pipes" from "/SQLEXPRESS/Database Engine/Remote Connections". Then please choose it and save&quit.

     B.  As the A step, Run "SQL Server Configuration Manager "

                 1).  Click "SQL Server 2005 Services" and stop the service.

          2).  Click "SQL Server 2005 Netwok Configurationr" and open the "Protocols for SQLEXPRESS", make the "TCP/IP" AND "Named Pipes" as "Enabled", But you have to  continue opening the "TCP/IP Properties"

and choose the "IP Addresses" panel, and fill  the all "TCP Port" with 1433, at last "Save&Quit".

     C.  Run "Microsoft SQL Server Management Studio Express"

           1).  Login in and open the "Server Properties" page.

           2).  Click "Security" and actiive the "SQL Server and Windows Authentication Mode ", then "Save&Quit".

     E.  Please  change or create Username& Password  form "/Security---->Login name" in "Microsoft SQL Server Management Studio Express".

     D.  Please Create the Database and Table you need from the "/Databased" in "Microsoft SQL Server Management Studio Express"

4.  Check the step1---3 and make sure that it can work properly.