Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to install the Adventure Works database onto an instance of SQL Server but i cannot get any instance entries listed in the dialog as below:

enter image description here

I have enabled FileStream and TextIndexing is installed. This is a 64 bit Sql Server Instance running on 64 bit Windows 7. Any ideas appreciated.

share|improve this question
Is your SQLBrowser service running? The SQL-instance can't be detected if that's not running. – wullxz Nov 21 '11 at 23:46
Yes SqlBrowser service is on. – rism Nov 22 '11 at 0:29
Are you sure that you installed the Database Engine component when you installed SQL? – joeqwerty Nov 22 '11 at 2:28
Yes the server instance contains other dbs. – rism Nov 22 '11 at 9:11

You should have "Windows Authentication" enabled and also your current "Windows Account" name should have access to your SQL Server instance. Because there is no question about the login info in the installer (damn it!) so default info would be your windows account information.

share|improve this answer

Open SQL server management studio, expand security and logins, right clcik your credential and click properties.From the login properties click server roles and make sure that your credential have sysadmin permission(sysadmin check-box is checked).

enter image description here

share|improve this answer

Your Answer


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.