SQLserverExpress 换为SQLServer2005标准版后，web.config中数据库连接字符串怎们改

SQLserverExpress下的数据库连接代码如下：
<connectionStrings>
<add name="constr" connectionString="Data Source=.\SqlExpress;uid=sa;pwd=sa;Initial Catalog=OA_DB" providerName="System.Data.Client"/>
<add name="OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="OA_DBConnectionString1" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Integrated Security=True;MultipleActiveResultSets=False;Packet Size=4096;Application Name=&quot;Microsoft SQL Server Management Studio&quot;" providerName="System.Data.SqlClient"/>
<add name="OA_DBConnectionString2" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="OA_DBConnectionString3" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="sj_OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;Password=" providerName="System.Data.SqlClient"/>
<add name="sj_OA_DBConnectionString2" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;Password=" providerName="System.Data.SqlClient"/>
<add name="wc_OA_DBConnectionString2" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="wc_OA_DBConnectionString3" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="wc_OA_DBConnectionString9" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="wc_OA_DBConnectionString10" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="qs_OA_DBConnectionString2" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="qs_OA_DBConnectionString4" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="qs_OA_DBConnectionString5" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="qs_OA_DBConnectionString6" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="qs_OA_DBConnectionString1" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="qs_OA_DBConnectionString3" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="table_tz_OA_DBConnectionString1" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>
<add name="table_xw_OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>
<add name="table_file_OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>
<add name="table_message_OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>
<add name="table_bbs_OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;User ID=sa;Password=sa" providerName="System.Data.SqlClient"/>
<add name="table_gx_OA_DBConnectionString" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
<add name="linminchao_OA_DBConnectionString5" connectionString="Data Source=.\SqlExpress;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>
</connectionStrings>

解决方案 »

  1.   

    对改data sourec  要加一个空格
      

  2.   

    已经解决了   直接附加后再分配用户，连库字符串改成直接连接sql服务器方法就可以了 
    <connectionStrings> 
    <add name="constr" connectionString="Data Source=.;uid=sa;pwd=sa;Initial Catalog=OA_DB" providerName="System.Data.Client"/> 
    <add name="OA_DBConnectionString" connectionString="Data Source=.;Initial Catalog=OA_DB;Persist Security Info=True;User ID=sa;pwd=sa" providerName="System.Data.SqlClient"/>