Post reply

couldnot connect to sql server -memory allocation

  • February 13, 2003 at 2:28 pm

    #159432

    Hi all,

    I tried to install sp3 on sql server 2k and it failed to run the first script and when i restarted my server and tried to run the setup again it's giveing me the error that it couldn't verify my account.I am a local system admin on that box and now i am not able to connect to the server since it says

    couldn't coonect to server

    reson:memory allocation failure.

    The server is up and running .Any help is highly appreciated.

    Thanks,

    M

  • February 13, 2003 at 2:41 pm

    #448933

    Use server network utility to verify TCP/IP is enabled.

  • February 13, 2003 at 3:03 pm

    #448938

    it's enabled.

  • February 13, 2003 at 3:08 pm

    #448939

    Check registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQuery value to "DBNETLIB" exists.

    TCP/IP has to be enabled in Client Network Utility in Server too.

    Which MDAC version in your server?

    Edited by - Allen_Cui on 02/13/2003 3:08:53 PM

  • February 13, 2003 at 3:24 pm

    #448940

    it's the same.ANd how do i verify the MDAC version??

  • February 14, 2003 at 9:10 am

    #448995

    Ok.I got it set.I had to reinstall SQL server .

    Thanks,

    M

  • February 14, 2003 at 9:25 am

    #449006

    Download MDAC component checker from http://www.microsoft.com/data

Viewing 7 posts - 1 through 6 (of 6 total)

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