微软SQL服务器,创建服务器资源管理器中新表 [英] Microsoft SQL Server, creating new table in server explorer
问题描述
对于C#编程任务我要创建在Microsoft SQL Server的表。我的Visual Studio 2013的Microsoft SQL Server 2012的新安装。当我安装了它,我指定我的管理员访问权限的用户(这是只有我的用户一台笔记本电脑反正)。我似乎无法能够完全按照我的老师的指点的分配:
For a C# programming assignment I have to create a table in Microsoft SQL Server. I have Visual Studio 2013 and Microsoft SQL Server 2012 freshly installed. As I installed it I specified my user for admin access (this is on a laptop with only my user anyway). I can't seem to be able to fully follow my teacher's instructions for the assignment:
- 创建一个新的WPF项目,称为StudentDb
- 开启服务器资源管理器(查看>服务器资源管理器)
-
在数据连接右键单击>创建新的SQL Server数据库
创建新的SQL服务器数据库窗口打开
- Create a new WPF project called StudentDb
- Open Server Explorer ( View > Server Explorer )
Right click on Data Connections > Create New SQL Server Database The Create New SQL Server Database window opens
选择一个服务器名称(默认值: .\SQLEXPRESS
)
Select a Server name (default: .\SQLEXPRESS
)
点击确定
在服务器资源管理器,你会发现在数据连接列出一个新的数据库
In Server Explorer you’ll find a new Database listed under Data Connections
在4号,这似乎唯一的服务器是MORTHOS这是我的计算机名。 (我希望这是任意的)。我能够创建一个新的数据库命名的大学。当我到达6我发现我的进步研磨完全停止。我只有选项刷新和性能,看不到的地方添加一个新表,如下图所示:
On number 4, the only server that appeared was "MORTHOS" which is my computer name. (I am hoping that this is arbitrary). I was able to create a new DB named college. When I get to 6 I find that my progress grinds to a complete halt. I only have the options Refresh and properties and can't see where to add a new table as pictured here:
我知道它有一个有效的连接,是因为它能够成功地创建了数据库学院。我甚至可以证实,它具有良好的连接,当我点击测试:
I know it has a valid connection, because it was able to successfully create the College database. I can even confirm that it has a good connection when I click "test":
有人能告诉我什么我做错了?
Can someone please tell me what I am doing wrong?
编辑:在SQL Server Management Studio中我看到自己的登录下:
in SQL Server Management Studio I do see myself under the logins:
推荐答案
如果你只看到刷新和属性,当你右键点击在服务器资源管理器的表,你可能需要从 http://msdn.microsoft.com/en安装SQL Server数据工具-us /数据/ hh297027 。
If you only see Refresh and Properties when you right click on Tables in Server Explorer, you probably need to install SQL Server Data Tools from http://msdn.microsoft.com/en-us/data/hh297027 .
这篇关于微软SQL服务器,创建服务器资源管理器中新表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!