错误消息“此版本的SQL Server 2008 R2不支持用户实例登录标志". [英] Error msg "the user instance login flag is not supported on this version of SQL Server 2008 R2"

问题描述

您好，我曾经在PC上安装过SQL Express 2005，然后又升级到了SQL Server 2008 R2.我尝试使用用SQL Express 2005创建的SQL Server 2008 R2打开数据库文件，它给我一个错误消息"此版本的SQL Server不支持用户实例登录标志.连接将被关闭. 我该如何解决?

Hi, I used to have SQL Express 2005 on my PC, I upgrade to SQL Server 2008 R2. I try to open a database file with SQL Server 2008 R2 that was created with SQL Express 2005 it gives me an error msg "The user instance login flag is not supported on this version of SQL Server. The connection will be closed." How can I fix it?

推荐答案

我不确定这是否对您有用...

我曾经遇到过同样的问题，我所做的是删除此类数据库的日志文件，并使用SLQ Management Studio及其工作进行加载/附加...

示例我删除了:
``ASPNETDB_log.ldf" 并仅保留"ASPNETDB.MDF"
在加载或连接之前...

但在此之前，我建议您先备份此类文件，以防万一...


请别忘了投票，如果有帮助的话，其他人可以考虑作为答案 ...

Hi,
I am not sure if this will work in yours …

I had been encountered such same problems, what I did were removing the log file of such database, and load/attached using SLQ management Studio and its work…

Example I remove the:
''ASPNETDB_log.ldf’ and keep only the ‘ASPNETDB.MDF’
Before loading or attaching it...

But before doing that, I advised you to backup first such files in case…


Please do not forget to vote if could help so that others may consider as an answer...

Regards,

如果没有在SQL 2008中使用Express，则不能使用用户实例.您可以先手动创建数据库，然后将连接字符串设置为指向该数据库.记住从连接字符串中删除用户实例规范.

If you''re not using Express with SQL 2008 then you cannot use user instances. You can create the database manually first and set the connection string to point to that database. Remeber to take away the user instance specification from the connection string.

这篇关于错误消息“此版本的SQL Server 2008 R2不支持用户实例登录标志".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！