Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

enter image description here

What should I input the connection name there? I have a database called Stack Overflow... I tried the hostname as localhost and it didn't work

share|improve this question
    
I recently downloaded the advanced version of SQL Express 2008R2, and it looks like it came with the "full version" of SQL Server Management Studio. Since this is a better tool for working with SQL Server than Oracle SQL Developer, you might want to look in to it. –  Joe Internet Mar 9 '11 at 11:45
add comment

1 Answer

It doesn't matter what you put as the connection name. This is just the name the SQL Developer uses to list the database (so using the database name is a good idea but it can be anything you want).

The problem here is that SQLEXPRESS isn't a known hostname. The hostname should be the name (or IP address) of the server that hosts the SQL Server instance which holds your database. Once you have the correct hostname and port you should be able to select the database you want from the drop-down list. Click Test to ensure all is OK, then Save.

share|improve this answer
add comment

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.