数据库连接字符串该怎么改

[ab83328523]

我装sql 2005 时 没有装 默认实例 ，装了另一个命名实例 SA ，那么下面的四个连接字符串该怎么改啊，帮帮忙
<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"/>

[Martin-月影]

好像是 Data Source=.\SA
你试试

[-过客-]

try...

Data Source=.\SQLEXPRESS;
==>
Data Source=.\SA;

[oec2003]

Data Source=.\SQLEXPRESS 改成Data Source=.\SA
\后面的就是实例名

[蓝海D鱼]

[Quote=引用 3 楼 oec2003 的回复:]
Data Source=.\SQLEXPRESS 改成Data Source=.\SA
\后面的就是实例名
[/Quote]UP

[宝_爸]

\SA

[宝_爸]

.\SA

如果远程连接

机器名\实例名

[fengxupeng]

呵呵，我不太懂，附加个问题，如果是默认的实例名称，是不是就只写.呀？

[皓月明]

我晕

[zyhjavascript]

data source=.\sqlexpress;initial catalog=数据库名;integrated security=sspi;