Problem with locks configuration

[taixut]

Hi all,

I've had a problem with my SQL Server saying that i run out of locks:

[298] SQLServer Error: 1204, SQL Server has run out of LOCKS. Rerun your statement when there are fewer active users, or ask the system administrator to reconfigure SQL Server with more LOCKS. [SQLSTATE HY000]

I've configurated the Server with sp_configure locks to increase it. Afterwards i've stopped the service and when i wanted to start it again it didn't start.

I've looked the log of SQL Server and i've realized the number of locks was to high and now the Server gives back this error:

Couldn't create exchange manager memory manager objects.

Is there a way to change this locks value with the MSSQLServer down? Can anybody help me with that?

Thanks in advance

 

[taixut]

Fortunately i've found and old version of the master DB. So the problem is solved.