I used Data Connections to connect a database but couldn't make it.
1. I used Windows Authentication to log on to database, my database's name wasn't displayed in Select or enter a database name dropdown menu, so I enter my database's name then I pressed Test Connection button, it said "This connection can't be tested because the specified database doesn't exist or isn't visible to the specified user."
2. So I used SQL Server Authentication to log on to the server,then I put my database's name in Select or enter a database name dropdown menu box, then press OK it's said that "Login failed for user 'xxx' or Try to press Test Connection button it said that "Login failed for user 'xxx'.
I'm sure that I use a correct username and password and I think it's a problem about VS can't see my database in SQLExpress2008.
please give me an advice to solve the problem.
View Complete Post