up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
75% accept rate
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
feedback

3 Answers

up vote 0 down vote

Is your SQLBrowser service running?
The SQL-instance can't be detected if that's not running.

link|improve this answer
Yes SqlBrowser service is on. – rism Nov 22 '11 at 0:29
@wullxz this should've been a comment, ideally. – Tom O'Connor Nov 22 '11 at 16:56
feedback
up vote 0 down vote

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][1]

link|improve this answer
feedback
up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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