Posted on: 2/21/2012 1:25:11 PM | Views : 604

Hi, I'm using Microsoft SQL Server 2008 R2.  I'm trying to import from excel.  I run the wizard and got to the "Choose a Destination" page.  In the "Database" field my database name is not im the dropdown list.  I then type the name of my database like this: 
SchoolInDB
When I click "Next" I got the error message:
'Login failed for user 'David-PC\David'. Cannot open database requested in login 'SchoolInDB'. Login fails. (Microsoft SQL Server Native Client 10.0)
Then I tried tying
SchoolIn.Modeles.SchoolInDB and got this error message:
Login failed for user 'David-PC\David'.
Cannot open database requested in login 'SchoolIn.Models.SchoolInDB'. Login fails. (Microsoft SQL Server Native Client 10.0)
How can I make this work?
...

Go to the complete details ...