Windows Authentication Problems

[wschlichtman]

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=.\\SQLEX PRESS;initial catalog=PhotoAl bum;" +
"integrated security=SSPI;p ersist security info=False;" +
"workstatio n id=WILLIAM;pack et size=4096";

I have also tried:

"Data Source=.\\SQLEX PRESS;" +
"AttachDbFilena me=PhotoAlbum.m df;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.

[Angel J. Hernández M.]

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
"wschlichtm an" <ws**********@d iscussions.micr osoft.com> escribió en el
mensaje news:F8******** *************** ***********@mic rosoft.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=.\\SQLEX PRESS;initial catalog=PhotoAl bum;" +
"integrated security=SSPI;p ersist security info=False;" +
"workstatio n id=WILLIAM;pack et size=4096";

I have also tried:

"Data Source=.\\SQLEX PRESS;" +
"AttachDbFilena me=PhotoAlbum.m df;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.

[wschlichtman]

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
"wschlichtm an" <ws**********@d iscussions.micr osoft.com> escribió en el
mensaje news:F8******** *************** ***********@mic rosoft.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=.\\SQLEX PRESS;initial catalog=PhotoAl bum;" +
"integrated security=SSPI;p ersist security info=False;" +
"workstatio n id=WILLIAM;pack et size=4096";

I have also tried:

"Data Source=.\\SQLEX PRESS;" +
"AttachDbFilena me=PhotoAlbum.m df;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.