Re: [NTISP] Re: [Emerald] Help !! SQL Server 6.5 won't start

Danny Sinang ( (no email) )
Sat, 22 Apr 2000 10:11:18 +0800

Hi Peter,

It seems to be working, except that the "sa" login fails.

It won't seem to accept the last password I gave it. And at one point, it
says teh maximum number of 5 configured user connections are already
connected. System Administrator can configure to a higher value with
sp_configure.

What do I do now ?

- Danny

----- Original Message -----
From: Peter Deacon <peterd@iea-software.com>
To: Emerald <emerald@iea-software.com>
Cc: NTISP <ntisp@iea-software.com>
Sent: Saturday, April 22, 2000 9:53 AM
Subject: [NTISP] Re: [Emerald] Help !! SQL Server 6.5 won't start

> On Sat, 22 Apr 2000, Danny Sinang wrote:
>
> > Hello.
> > I have a SQL Server 6.5 server running on a dual Pentium Pro machine
with
> > 300 MB RAM. Only NT, SQL Server and RadiusNT are running on it.
>
> > I mistakenly set its Memory ( in SQL Enterprise Manager / Configure ) to
its
> > maximum value 100 MB and I set the TempDB in RAM to 60 MB.
>
> > Then I stopped the SQL Server and now it won't restart.
> > The event log has a Kernel Category error saying
> > Mesg 17155 : initblkmem : not enough memory for MEMMAP structures
>
> > I can't reconfigure SQL Server because it won't start. How do I fix this
?
>
> This will do the trick...
>
> sqlservr /c /f
>
> Have Fun!
> Peter
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart