I was able to solve the problem with the "sa login failed". I did it via
sqlservr -c -f .
Thanks for the help. I really appreciate it. =)
- 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