locked
SQL Server Express and SQL Server Authentication RRS feed

  • Question

  • Hello,
    Can SQL Server Express 2008 creat databases with SQL Server Authentication or would that fall under the non-express territory?
    Thanks,
    KT
    Tuesday, January 20, 2009 12:06 AM

Answers

  • Yes, you can use mixed mode authentication in all versions of SQL Server.  Keep in mind that mixed mode authentication (Windows and SQL logins) is an instance level setting, not a database level setting.

    Does this help?
    Aaron Alton | thehobt.blogspot.com
    • Marked as answer by KT99 Wednesday, January 21, 2009 8:56 PM
    Tuesday, January 20, 2009 2:41 AM

All replies

  • Yes, you can use mixed mode authentication in all versions of SQL Server.  Keep in mind that mixed mode authentication (Windows and SQL logins) is an instance level setting, not a database level setting.

    Does this help?
    Aaron Alton | thehobt.blogspot.com
    • Marked as answer by KT99 Wednesday, January 21, 2009 8:56 PM
    Tuesday, January 20, 2009 2:41 AM
  • Hello,
    Yes that did help, thank you.  I enabled IIS 7 on my vista and it works like a charm now.  I guess it was the visual studio express server that couldn't connect to my databases.
    Wednesday, January 21, 2009 8:56 PM