SQL 2005 连接数据库字符串代码有没有问题

Question

<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\liveportal.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
<add name="SqlConnection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\liveportal.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
<add name="MemberShipDAL.Properties.Settings.WMFConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\liveportal.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
<add name="MemberShipDAL.Properties.Settings.AspNetMembershipSql" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\liveportal.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
<add name="LivePortalConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\liveportal.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

Answer 1

有问题，最简单的写法： server=数据库服务;uid=用户名; pwd=密码;database=数据库名

Answer 2

<add name="ConnectionString" connectionString="Data Source=数据库服务器;Initial Catalog=数据库名;User ID=用户名;Password=密码" providerName="System.Data.SqlClient" />