SQL Server Database 002-sql server R2 connection string

The database is installed and the connection string is required for use in the program. How to write it? Take SQL Server R2 as an example.
1, after installing SQL Server R2, similar to Oracle's Plsql tool. SQL Server R2 also has tools, that is, SQL Server Management Studio,


2. After opening SQL Server Management Studio,


The server, user name, and password are all entered at the time of installation.


3, enter the interface, you can create your own database name, you can also click the attachment to import the existing database (MDF file).

Or

4. For example, create a new database here named:


The connection string is:
Data source=88226d6210524c7;initial catalog=hopeloan2013; User Id=sa;pwd=yys


You can change the value of the place to your own.

SQL Server Database 002-sql server R2 connection string