Cannot install Adventure Works DB to Sql Server because Install Instance drop down is blank

Question

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.

Are you sure that you installed the Database Engine component when you installed SQL? — joeqwerty, Nov 22 '11 at 02:28
Is your SQLBrowser service running? The SQL-instance can't be detected if that's not running. — wullxz, Nov 21 '11 at 23:46

score 1 · Answer 1 · answered Jan 28 '12 at 20:02

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.

score 0 · Answer 2 · edited Nov 12 '12 at 06:38

0

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

edited Nov 12 '12 at 06:38

Michael Hampton

244,070
43
506
972

answered Jan 04 '12 at 06:28

arjun koteshwar

1

Cannot install Adventure Works DB to Sql Server because Install Instance drop down is blank

2 Answers2