SQL Server Express Integration in VS 2005

[pmclinn]

I have create some user accounts in a local SQL 2005 db, created by
visual studio. I should note I'm developing on windows vista 64 bit
ed. In order to get this database to work on my web server do I have
to create it outside of VS? Every time I push the SQL Express DB's to
my remote web server I end up with errors. I'm assuming this is
because the DB is not set in Mixed mode authentication from within
VS. Is there a way to change this behavior in Studio as to allow for
mixed mode?

Thank you for your help.

[Cowboy \(Gregory A. Beamer\)]

Change the connection string in the config file so it is a mixed mode
connection string instead of a trusted connection. Your app should then work
fine on the production server.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************
"pmclinn" <pm*****@gmail.comwrote in message
news:11*********************@p77g2000hsh.googlegro ups.com...

>I have create some user accounts in a local SQL 2005 db, created by
visual studio. I should note I'm developing on windows vista 64 bit
ed. In order to get this database to work on my web server do I have
to create it outside of VS? Every time I push the SQL Express DB's to
my remote web server I end up with errors. I'm assuming this is
because the DB is not set in Mixed mode authentication from within
VS. Is there a way to change this behavior in Studio as to allow for
mixed mode?

Thank you for your help.