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
Collegeas 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
Collegedatabase) - 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:
