sql server 2005本地修改密码

连接至数据库后，可看到

 

 

右击属性即可修改密码。

 

asp连接SQL：

dim connstr,conn
 Private Sub ConnOpen()
set Conn=server.createobject("ADODB.connection")
Conn.ConnectionString ="Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=hanyang;Data Source=PC-201012041302\SQLONE;Connect Timeout=15"
Conn.Open
  'db=server.mappath("../#database#/#database#.mdb")
  'set conn=server.createobject("adodb.connection")
  'conn.open "driver={microsoft access driver (*.mdb)};pwd=;dbq="&db '没有密码
  'conn.open "Provider = Sqloledb;User ID=sa;Password=sa;Initial Catalog =text;Data Source =local"
 End Sub

 Private Sub ConnClose()
  If Not (Conn Is Nothing) Then
   Conn.Close : Set Conn = Nothing
  End If
 End Sub
 
ConnOpen()'打开数据库连接