sql server 2008 r2和2012之间的冲突 [英] Conflict between sql server 2008 r2 and 2012

问题描述

我同时安装了 SQL Server 2008 r2 和 SQL Server 2012，但是当我打开 SQL Server 2008 r2 management studio 并通过 (localhost) 输入时，它的版本似乎是 11.0.2218，用于 sql server 2012 management studio，所以我无法访问或创建旧表.有没有办法改变SQL Server管理工作室?

I have both SQL Server 2008 r2 and SQL Server 2012 installed, but when I open SQL Server 2008 r2 management studio and enter by (localhost), it's version seems to be 11.0.2218 which is for sql server 2012 management studio, so I can't access or create older tables. Is there any way to change SQL Server management studio?

推荐答案

打开你的 SQL Server 配置管理器，在 SQL Server 网络配置下你会找到 Protocols for 并且所有安装的实例都会那里.MSSQLSERVER 是默认实例.在那里找到您的实例名称.

Open your SQL Server Configuration Manager, Under SQL Server Network Configuration you will find Protocols for and all the instances that is installed will be there. MSSQLSERVER is the default instance. Find your instance name there.

还有其他选项是运行 regedit 转到 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 你会发现像这样的键.

There other option is to run regedit Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server You will find keys like.

MSSQL10_50.MSSQLSERVER 和MSSQL11.SQLEXPRESS

不过你的会有所不同.

这将显示 SQL Server 版本和实例.我的显示 MSSQL10.5，它是 2008 R2 作为 MSSQLSERVER，这是默认实例，MSSQL11 作为 SQLEXPRESS，这是我 2012 年的命名实例

That will show you the SQL Server version and instance. Mine show MSSQL10.5 which is 2008 R2 as MSSQLSERVER which is the default instance, and MSSQL11 as SQLEXPRESS which is my named instance for 2012

这篇关于sql server 2008 r2和2012之间的冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！