Post reply

Migrating DB to SQL authentication

  • January 11, 2010 at 10:52 am

    #215315

    Hi,

    I'm an experienced developer, but new to SQL Database administration.

    Recently I designed a web site using .NET with a back-end content management system using a local database and Windows Authentication. Now it's time to deploy the site so it needs to make use of SQL Authentication on a remote server.

    I've been trying to create logins and roles but these are not working as required; the asp:login is failing, and there is no code I can examine to determine why. No exceptions are being thrown - login is simply failing silently.

    I would greatly appreciate any advice on how to proceed. Is there any documentation that you can recommend or steps you think I might be able to take?

    Thanks in advance,

    - Dave H.

  • January 11, 2010 at 10:53 am

    #1101941

    The first step would be to check the sql server error log this will have an entry for the Failed login and the error code. From this you can get the reason for the failure, most likely wrong password or the user does not have access to the database.

    post the errors if you need any further help

  • January 13, 2010 at 12:46 am

    #1102915

    Dave H. (1/11/2010)

    Hi,

    I'm an experienced developer, but new to SQL Database administration.

    Recently I designed a web site using .NET with a back-end content management system using a local database and Windows Authentication. Now it's time to deploy the site so it needs to make use of SQL Authentication on a remote server.

    I've been trying to create logins and roles but these are not working as required; the asp:login is failing, and there is no code I can examine to determine why. No exceptions are being thrown - login is simply failing silently.

    I would greatly appreciate any advice on how to proceed. Is there any documentation that you can recommend or steps you think I might be able to take?

    Thanks in advance,

    - Dave H.

    I agree steve.

    Dave,

    Actually what u did?

    Additionally,

    Did u chage server authentication --->windos A.D mode to sqlserver and windows A.D mode

    If change the authentication u need to restart the instance.

    Edit:Add more info

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply