CODEWITHSUNDEEP
sqlsql-serverinstallationsql-server-expresssql-server-2014-express
Chris
Chris

Reputation: 435

SQL Server 2014 Express Set Up

I have downloaded Microsoft SQL Server Management Studio 2014 Express. I have set it up and I now need to connect to the server. I think my server name has something to do with my computer name but its not working. How do I get in?

Upvotes: 3

Views: 9613

Answers (3)

user2611407
user2611407

Reputation: 11

localhost/SQLExpress in SSMS (SQL Server Management Studio)

Upvotes: 0

Dave C
Dave C

Reputation: 7392

Assuming you installed SQL Server, and not just SSMS please read this:

http://msdn.microsoft.com/en-us/library/ms143531(v=sql.120).aspx

In all likelihood it was setup with the default instance name of \SQLExpress. So to connect, you would enter machinename\SQLExpress.

Ex: Office-PC1\SQLExpress

If you specify MSSQLServer for the instance name, a default instance will be created. For SQL Server Express, if you specify SQLExpress for the instance name, a default instance will be created.

NB: If you open the "Server Name" drop down in the SSMS "Connect To Server" window, there is a "Browse for more..." option which should help you find your installed server.

Upvotes: 5

Anthony Jones
Anthony Jones

Reputation: 95

Assuming you actually installed the db server, and NOT just the management tools, you can always use "localhost" (without the quotes). Have you made sure you are using port 1433? I am not sure if that was a question during the setup.

Upvotes: 0

Related Questions