SQL Server 2005 won't accept connections

  • SQL Server 2005 running on a virtual server with 3GB of memory.

    someone inadvertently changed the memory allocation for SQL server and now the CPU is pegged and I cannot connect to SQL Server. When i look at talk manager on the server sql server is using 100% of CPu and 81248k of memory

    Can anyone help me in resolving this?

  • I got the full story. I think SQL Server memory configuration was changed from 2GB to 2mb? can anyone help me resolve?

  • restarted the service, got a connection and set the memory back to 2048mb

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

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