sql server连接字符串和express版本有区别吗?!
By default (though I don't recommend it1), Sql Express is installed as a named instance http://msdn.microsoft.com/en-us/library/ms165614(SQL.90).aspx. That means you must connect like Server=servername.com\SQLEXPRESS
as opposed to just Server=servername.com
.
一如既往,连接字符串.com http://connectionstrings.com/sql-server-2008有好东西。
1 I don't recommend named instances because they run on a different port http://support.microsoft.com/kb/265808, which makes firewalling a PITA. Also, it makes little sense to me to run more than 1 MSSQL Server on a computer when you could just host multiple databases instead - so I'm not really sure what the point is.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)