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.

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
add comment

2 Answers

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
add comment

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