sql server express 换为sql server2005后，web.config文件中，数据库连接字串怎么修改？

Question

公司换了台电脑，数据库由原来的sql server express改成了sql server2005后，程序调试时出错，具体：
sql server express中的字串
<connectionStrings>
    <add name="MySaleDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MySaleDB.mdf;Integrated Security=True;User Instance=True"
      providerName="System.Data.SqlClient" />
    <add name="MyASPNETDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"
      providerName="System.Data.SqlClient" />
</connectionStrings>sql server2005中修改为：
<connectionStrings>
<add name="MySaleDBConnectionString" connectionString="Server=(local);database=MySaleDB;Uid=bsjxc;Pwd=sqlserver2005" providerName="System.Data.SqlClient"/>
<add name="MyASPNETDBConnectionString" connectionString="Server=(local);database=MyASPNETDB;Uid=bsjxc;Pwd=sqlserver2005" providerName="System.Data.SqlClient"/>
</connectionStrings>
还是出错
1.如何修改？
2.原连接字串中怎么没有库名？

Answer 1

你保证你的SQL 2005是默认实例？

Answer 2

<connectionStrings> 
<add   key="MySaleDBConnectionString"   value="Server=(local);database=MySaleDB;Uid=bsjxc;Pwd=sqlserver2005"   providerName="System.Data.SqlClient"/> 
<add   key="MyASPNETDBConnectionString"   value="Server=(local);database=MyASPNETDB;Uid=bsjxc;Pwd=sqlserver2005"   providerName="System.Data.SqlClient"/> 
</connectionStrings> 

Answer 3

原来是附加一个数据库文件的AttachDbFilename= ¦DataDirectory ¦\MySaleDB.mdf;
附加这个文件，数据库名就是MySaleDB了

Answer 4

直接这样吧。。<appSettings>
<add   key="MySaleDBConnectionString"   value="Server=(local);database=MySaleDB;Uid=bsjxc;Pwd=sqlserver2005"/> 
<add   key="MyASPNETDBConnectionString"   value="Server=(local);database=MyASPNETDB;Uid=bsjxc;Pwd=sqlserver2005"/> 
</appSettings> 

Answer 5

to Haiwer:
SQL 2005是默认实例

Answer 6

to pt1314917:
是Ｃ#语言，但是改动字串后，cs文件中connectionStrings，MySaleDBConnectionString，connectionString字串都要修改，想保留下面这种格式，怎么写呢？
<connectionStrings> 
        <add   name="MySaleDBConnectionString"   connectionString="" 
            providerName="System.Data.SqlClient"   /> 
        <add   name="MyASPNETDBConnectionString"   connectionString="" 
            providerName="System.Data.SqlClient"   /> 
</connectionStrings> 

Answer 7

改成下面这样，还是不行：
<connectionStrings>   
                <add       name="MySaleDBConnectionString"       connectionString="Server=(local);database=MySaleDB;Uid=bsjxc;Pwd=sqlserver2005"/>   
                <add       name="MyASPNETDBConnectionString"       connectionString="Server=(local);database=MyASPNETDB;Uid=bsjxc;Pwd=sqlserver2005"/>   
</connectionStrings>

Answer 8

没写过这种写法，在网上搜了下。楼主自己对照改改看：
＜connectionStrings＞
＜add name="Pubs" connectionString="Server=localhost;
Integrated Security=True;Database=pubs;Persist Security Info=True"
providerName="System.Data.SqlClient" /＞
＜add name="Northwind" connectionString="Server=localhost;
Integrated Security=True;Database=Northwind;Persist Security Info=True"
providerName="System.Data.SqlClient" /＞
＜/connectionStrings＞