Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have just installed Microsoft SQL Express from here: http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx

I need it because an example of some code I have uses it.

How do I start using it? Which port does it open by default? All I have after installing it is this:

alt text

I'm not asking for a full tutorial on how to admin MSSQL, just a hint on what to do next.

I have downloaded and tested in the past Oracle XE and test it with SQuirreL SQL client with out problems.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

I find the easiest way to interact with SQL Server Express is to download the SQL Server Management Studio Express. This tool will let you connect to SQL Server instances and manipulate the tables in any way you like using the GUI. You can also run scripts against the databases. Its a very useful database development tool.

share|improve this answer
1  
Correct. This tool is not included in the default SQL Server Express 2005 installation (to minimise download size, I suspect). You will need to download and install it seperately. Actually I just noticed - there's a link to it in the background window of your screenshot up the top! –  Mark Henderson Mar 10 '10 at 3:11
    
Thanks for the help. It is very frustrating to install this software and then stare at your screen thingking "NOW WHAT?!!!" @Ferseeker: lol :) :) Isn't it funny how things are very easy to spot when you now what to look at? :) :) After reading @heavyd answer I went like "Doh... that's the link" and your comment makes totally sense. This just shows how bad some pages are designed :) –  OscarRyz Mar 12 '10 at 16:05

After it's installed, it runs automatically, you don't have to start it. By default, there's no open port, just a named pipe. The default named pipe for SQL Express is \.\sqlexpress (I know this looks like a UNC, it's not, don't try).

There's quite a few ways for code to connect to it. A common way is the MSSQL ODBC Connector, where you might have to change the Instance Name (Full SQL server installs to the "default" instance, where express installs to a named instance).

share|improve this answer
    
The named pipe can also be seen like this: machineName\sqlexpress –  Chris Mar 10 '10 at 3:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.