SQL Server 2014 Express Set Up

sql sql-server installation sql-server-express sql-server-2014-express
Chris picture Chris · Jul 18, 2014 · Viewed 9.5k times · Source

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?

Answer

Dave Cullum picture Dave Cullum · Jul 18, 2014

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.

Related questions

Add SSIS to existing SQL Server instance

I am trying to add Integration Services an existing SQL Server 2008 instance. I went to the SQL Server Installation Center and clicked the option to "New installation or add features to an existing installation." At this point, a file system …

Read More
Microsoft SQL Server stuck at "Install_SQLSupport_CPU64_Action"

While installing SQL Server 2017 Developer Edition, I got stuck at "Install_SQLSupport_CPU64_Action", this happened to me for the second time, once at work and once at home. After searching online I found no solution.

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More