SQL Server Express Integration in VS 2005

  • Thread starter Thread starter pmclinn
  • Start date Start date
P

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.
 
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!
*********************************************
 
Back
Top