Search code examples
sqlsql-serverinstallationsql-server-expresssql-server-2014-express

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?

Solution

  • 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.