Have Geek Brain

Connecting to a new installation of SQL Server

I know mysql and I would like to learn sqlserver. I am currently sticking to the basics of the basics:

  • How to install and configure sql server
  • How to connect to it

I installed Sql Server via the Web Platform Installer and installed Visual Studio 2008. However, I cannot figure out how to connect to my server:

  • I can see that the SQL service (SQLEXPRESS) itself is running in both services.msc and Sql Server Configuration Manager
  • I am trying to connect to it through Management Studio, but I am at a loss as to what to do.

Where to begin?

+2


a source to share


2 answers


Start Management Studio and select Database Engine as the SqlExpress instance, then select Windows Authentication and click Connect. You will then see your databases in the object explorer if you want to create one database by right clicking and create a new one.



You can take a look at http://msdn.microsoft.com/en-us/library/ms186312.aspx

+2


a source


There are two types of ways to install an instance of SQL Server: 1. Named instance 2. Default instance

When you are using the default instance and this is the only instance on the computer, the server will listen directly on port 1433, which is the default SQL Server port. This is what you would expect if you come from a mysql background.

When you "name" an instance, such as SQLEXPRESS, it behaves differently. You are connecting to a special service (the SQL Server Browser Service) that is now listening on this port and pointing the client to the "correct" port of the named instance. Hopefully I know for sure about this, but that's what's going on in general.



You can directly connect to a named instance if you see which port it is binding in the SQL Server error log and if you can select a port in the client application.

Read more about it here: http://msdn.microsoft.com/en-us/library/ms181087.aspx

+1


a source






More articles:


All Articles