You certainly don't want to use the SA account. If you go to your database, you should see a security/users tab somewhere.
If you don't see any user besides SA, you should add one. You can either create a Windows User account, or one directly in SQL Server. Then just add that user to db_owner, or something more restrictive if necessary. Then add that user to the DB you want it to access. On Tue, Jul 19, 2011 at 1:09 PM, Matthew Woodward <[email protected]> wrote: > On Tue, Jul 19, 2011 at 11:07 AM, Daniel Eng <[email protected]> wrote: >> >> My SQL Server Authentication is set to SQL Server and Windows >> Authentication mode. >> >> Do you know what is the default for this? Assuming I did not set up a user >> at all? > > There is no default other than a user called sa which whoever installed SQL > Server would have set a password for, and which you don't want to use to > connect from your web apps anyway. > You'd have to check with whoever is administering your SQL Server box to get > a user/pass they want you to use. > -- > Matthew Woodward > [email protected] > http://blog.mattwoodward.com > identi.ca / Twitter: @mpwoodward > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html > > -- > official tag/function reference: http://openbd.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en > -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
