实例服务器名称SQL Server 2012 [英] instance servername sql server 2012
问题描述
您好，我已经安装了Management Studio 2005(x64)，但我的电脑中装有Microsoft sql server 2012.但是由于不知道服务器名称而无法连接服务器. (如果在我的电脑中使用sql server 2008 express，则默认服务器名称为"./sqlexpress")
Hello I have installed management studio 2005(x64) alse I have microsoft sql server 2012 in my pc. But cant connect server due to dont know server name. (if sql server 2008 express were in my pc, default servername would be "./sqlexpress")
如何在自己的PC中连接服务器?我也想知道；
How can I connect server in my own pc ? And also I wanted to know;
我应该使用另一个管理工作室吗?将ms2005与sqlserver 2012一起使用会出现问题吗?你会其他工作室吗? (请说明原因)
Should I use another management studio ? can there be a problem use ms2005 with sqlserver 2012 ? Do you recemmond other studio ? (with exp. reason please)
感谢任何愿意帮助您的人.
Thank you anyone who just feel to help.
推荐答案
其中至少一个必须是命名实例.因此，请打开SQL Server 2012版本的SQL Server配置管理器，然后查看服务内容(并确保您要连接的服务已启动-您可以右键单击以启动该服务).我的都是命名实例:
At least one of them must be a named instance. So, open the SQL Server 2012 version of SQL Server Configuration Manager, and see what the services say (and make sure the one you want to connect to is started - you can right-click to do so). Mine are all named instances:
因此，如果我想连接到SQL Server 2008 SP3实例，则可以使用以下任何一种方法进行连接:
So, if I wanted to connect to the SQL Server 2008 SP3 instance, I would use any of the following to connect:
.\SQL2008SP3
LOCALHOST\SQL2008SP3
(local)\SQL2008SP3
YOURMACHINENAME\SQL2008SP3
127.0.0.1\SQL2008SP3
例外是，如果子文本具有(MSSQLSERVER)-这是默认实例，而不是命名实例.在这种情况下，您只需连接到YOURMACHINENAME或..
The exception is if the subtext has (MSSQLSERVER) - this is a default instance rather than a named instance. In that case you would just connect to YOURMACHINENAME or ..
此外，不，您不应该使用Management Studio 2005来管理SQL Server 2012实例.实际上，我认为上述配置管理器不会显示您的2012实例.因此，在执行任何操作之前，您应该卸载Management Studio的2005版本，并在此处获取2012 SP2版本:
Also, no, you should not use Management Studio 2005 to manage SQL Server 2012 instances. In fact I think the above Configuration Manager won't show your 2012 instance. So before you do anything, you should uninstall the 2005 version of Management Studio, and go get the 2012 SP2 version here:
http://www.microsoft.com/zh-CN -us/download/details.aspx?id = 43351
单击下载，所需文件为SQLManagementStudio_x64_ENU.exe.关于此版本在2012 SP1中的好处是，它是SSMS Express的第一个版本，实际上完全功能齐全且没有许可证.以前，您必须忍受无SQL Server代理管理之类的限制，而这些限制现在都已荡然无存.
Click Download, the file you want is SQLManagementStudio_x64_ENU.exe. The nice thing about this version in 2012 SP1 is that it's the first version of SSMS Express that is actually fully functional and license free. Previously you had to live with limitations like no SQL Server Agent management, well those restrictions are now all gone.
(如果您以前安装的SQL Server 2012由于某种原因未提供该功能，则在安装客户端工具时，这还将为您提供Configuration Manager的新版本.)
(When you instal the client tools, this should also give you a new version of Configuration Manager, if your previous installation of SQL Server 2012 did not provide that for some reason.)
这篇关于实例服务器名称SQL Server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
