convert Windows authentication to use SQL Server authentication.(sql server 2008)
  • hi ,I have an account that is setup for Windows authentication. running reports and has various permissions in multiple databases. I need to convert this account to use SQL Server authentication.how i can do that thank you :) .
  • 1 Comment sorted by
  • Vote Up0Vote Down Jaguar777Jaguar777
    51.00 Karma Accepted Answer
    You need to change settings in app.config or web.config to user sql server authentication like this:
      <connectionStrings>
        <add name="SMSConnectionString" connectionString="Server=yourserver; Database=yourdb; Uid=sqluser; Pwd=sqluserpassword"
     </connectionString>
    Test this connection within visual studio first and copy connection from Server manager.


Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week

Optimum Creative