微软SQL服务器,创建服务器资源管理器中新表 [英] Microsoft SQL Server, creating new table in server explorer

查看:206
本文介绍了微软SQL服务器,创建服务器资源管理器中新表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

对于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:


  1. 创建一个新的WPF项目,称为StudentDb

  2. 开启服务器资源管理器(查看>服务器资源管理器)

  3. 在数据连接右键单击>创建新的SQL Server数据库
    创建新的SQL服务器数据库窗口打开

  1. Create a new WPF project called StudentDb
  2. Open Server Explorer ( View > Server Explorer )
  3. 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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆