Microsoft SQL Server, creating new table in server explorer
c#, sql-server, visual-studio
Solution
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 .
Problem
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: - 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 Select a Server name (default: `.\SQLEXPRESS`) - Choose Windows Authentication - Enter `College` as the new database name Click OK In Server Explorer you’ll find a new Database listed under Data Connections - Expand the College Database (by clicking the triangle left of the `College` database) - Right click Tables > Add New Table 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? EDIT: in SQL Server Management Studio I do see myself under the logins: