Post reply

help with sql server 2000 sp4-->emergency

  • September 17, 2006 at 12:07 am

    #90490

     

    Hi everyone,

    Our site is down, because of our hosting company applied sql server 2000 sp4 on windows 2000 server.

    right after it applied the service pack, our sql server database is down and no conn etc. When one technical support restart the server,

    the obejcts like tables in database cannot be recognized from our asp pages anymore, data cannot be inserted into any database table and data cannot be pulled out correctly from database table through asp program, but I can run query and look at data through sql analyzer.

    what is the problem, is it because of connection string? before this service pack 4, everything runs fine and we never had this kind of disaster.

    I have connection string like this:

    conn.Open "dsn=XXXXXX;uid=XXXXX;pwd=XXXXXX"

    Is there any problem with my connection string with sp4 applied?

    Can you please help?

    Betty

  • September 17, 2006 at 12:47 am

    #660910

    I think the problem has to do with the fact that it has changed the authentication mode to windows only instead of Mixed mode authentication(instead of SQL Server and Window). Please change it and restart the SQL Server.

    Thanks

    Sreejith

  • September 18, 2006 at 1:00 am

    #660955

    What error messages are you getting from the application when you try and connect?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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