Asp连接SQL Server 2012的方法  

Connection of SQL Server 2012 by Asp

作　　者：张莉[1] 许志强[2] ZHANG Li XU Zhiqiang(Tianjin Modern Vocational Technology College, Tianjin 300350, China Institute of Architecture Design ofBIDR, Tianjin 300222, China)

机构地区：[1]天津现代职业技术学院,天津300350 [2]中水北方勘测设计研究有限责任公司,天津300222

出　　处：《天津科技》2017年第3期70-72,共3页Tianjin Science & Technology

摘　　要：分析了动态网站与静态网站的概念及区别,SQL Server两种身份验证模式(Windows身份验证模式、SQL Server和Windows身份验证混合模式)的配置,以及两种身份验证模式的特点及区别,使用SQL Server配置管理器启用、禁用以及配置网络协议。介绍了在不了解SQL Server 2012数据库安装密码的情况下,如何更改SQL Server2012数据库用户名的密码,在Asp中怎样使用数据库用户名密码的形式连接SQL Server 2012数据库,实现网站后台数据库的连接。This article mainly analyzes the concept and difference of dynamic website and static website. The configuration modes of SQL Server authentication include： Windows authentication mode and SQL Server and Windows authentication hybrid mode. The characteristics and differences of the two authentication modes were introduced and using SQL Server configuration Manager to enable, disable and configure the network protocol was explained. It also explains the SQL Server 2012 database user password changing without knowing installation password and in Asp how to use the database user name password in the form of SQL Server 2012 Database to achieve the background database connection site.

关 键 词：ASP SQL SERVER数据库 网站 

分 类 号：TP393[自动化与计算机技术—计算机应用技术]