Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
will SQL and windows authetication applied during setup has other implications?

Answered will SQL and windows authetication applied during setup has other implications?

  • Tuesday, March 28, 2006 1:49 AM
     
     
    Sign In to Vote
    0
    I choose SQL and windows authetication during SQL Express 2005 install. Will this has any impact on the connection string in my Visual Studio 2005 environment?
     

All Replies

  • Tuesday, March 28, 2006 9:32 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    The setup during installation only predefines what you *can* use. If you chosse mixed authentication, like you stated above, this should be no problem, you can use WIndows authentication which would be

    (...)Integrated Authentication=true(...)

    or SQL Server Authentication

    (...)UserId=SomeUser;Password=SomePassword(...)

    For more information about connectionstrings goto www.connectionstrings.com

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

     
  • Tuesday, March 28, 2006 9:41 AM
     
     
    Sign In to Vote
    0
    ok thanks!!!!!!