Re: Can't connect to remote sql server from asp.net buk ok from Enterprise Manager

Discussion in 'ASP .Net' started by Mamcx, Jul 17, 2003.

  1. Mamcx

    Mamcx Guest

    Remove now aspnet user from admin group! (no matter is a test server, is a
    bad practique). You server is win2003? I don't can connect to Sql Server
    using NT authentication but with Sql Server authentication is fine. Create
    user group with the rigth permision on the database, create a user (like
    WebUser) with strong password and connect with it...
     
    Mamcx, Jul 17, 2003
    #1
    1. Advertising

  2. Mamcx

    karim Guest

    On Thu, 17 Jul 2003 17:53:16 -0500, Mamcx wrote:

    > Remove now aspnet user from admin group! (no matter is a test server, is a
    > bad practique). You server is win2003? I don't can connect to Sql Server
    > using NT authentication but with Sql Server authentication is fine. Create
    > user group with the rigth permision on the database, create a user (like
    > WebUser) with strong password and connect with it...


    aspnet has more rights that it should. I know and certainly this is not the
    cause of the problem.

    Rmember I said the app connects fine from my development machine. This
    means the user and password on the database work fine.

    Karim
     
    karim, Jul 18, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page