SQL Server Express Integration in VS 2005

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.
 
C

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!
*********************************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top