1) I don't remember what mode I installed. I'm pretty sure I went with
Windows Auth though. When prompted in VS for a database connection, I am
offered both choices.
2) I'm the user, and the admin. It's all located on my workstation.
3) I have the default instance SQLEXPRESS but no attached databases.
New information:
Recently, I changed my account password on my local system from no password,
which is what I had when I installed SQL, to a password with content. The
database was created after the password was in place. I don't know if this
has any bearing on my problem.
Also, I tried attaching the database to my project using Database Explorer
and continue to experience the login error.
My sorry I'm an idiot, but I just recently decided to return to programming
after many years of other IT work.
"Angel J. Hernández M." wrote:
Is your server configured for Mixed Authentication? (Windows & SQL) if
so... does the user you want to use access to the database selected? does it
have a default database?
Regards,
--
Angel J. Hernández M.
MCP - MCAD - MCSD - MCDBA
http://groups.msn.com/desarrolladoresmiranda
http://www.consein.com
"wschlichtman" <ws**********@discussions.microsoft.com> escribió en el
mensaje news:F8**********************************@microsof t.com... In my Windows application, I am attempting to access an SQL database
called
PhotoAlbum.mdf. I keep receiving the following error:
Cannot open database "PhotoAlbum" requested by the login. The login
failed.
Login failed for user 'William\Will'.
Here is my connection string:
"data source=.\\SQLEXPRESS;initial catalog=PhotoAlbum;" +
"integrated security=SSPI;persist security info=False;" +
"workstation id=WILLIAM;packet size=4096";
I have also tried:
"Data Source=.\\SQLEXPRESS;" +
"AttachDbFilename=PhotoAlbum.mdf;Integrated Security=True;" +
"User Instance=True";
which also met with problems of a different nature.
I am running SQL 2005 Beta 2 on a Windows XP Pro machine w/SP2.
Any insight would be appreciated.