User Instances的小问题

运行mvc的时候出现了个"此版本的 SQL Server 不支持用户实例登录标志。该连接将关闭。"的异常。

这个处理只要把webconfig中的数据库链接修改一下就可以了,取消User Instance=true就可以了。

我处理后的语句是:

 

数据库链接字符串
 <add name="ApplicationServices" connectionString="data source=localhost;Integrated Security=SSPI;initial catalog=aspnetdb.mdf;" providerName="System.Data.SqlClient" />

 

主要问题是原来的数据库是用express的,我使用的是sql2008,连接字符串自然要做一些修改,这个是用户读取权限相关的问题,可以看下面的内容。

关于SQL Server Express User Instances 的问题可以参考:

http://msdn.microsoft.com/en-us/library/ms254504.aspx

User instances allow users who are not administrators on their local computers to attach and connect to SQL Server Express databases. Each instance runs under the security context of the individual user, on a one-instance-per-user basis.

 

User instances are useful for users who are running Windows under a least-privilege user account (LUA) because each user has SQL Server system administrator (sysadmin) privileges over the instance running on her computer without needing to run as a Windows administrator as well.

 

posted @ 2009-11-30 08:53  newos  阅读(222)  评论(0编辑  收藏  举报