SQL Server does not start after installing Rollbase private

Posted by Akioma on 20-Oct-2013 08:43

Hi all,

after installing Rollbase with the windows installer, rollbase does not work.
Looking through the logfiles i can see in the DB log the following error:

SQL Server 11.3.01 started, configuration: "rbdb.virtualconfig"
SQLSRV2 1: (-----) Failure during dsmUserSecureConnect (-1)
SQLSRV2 1: (-----) Server is unable to complete start up.
(8842) Could not spawn a SQL server.

Any ideas wat is going wrong here?

TIA,

Mike

All Replies

Posted by Libor Laubacher on 21-Oct-2013 09:56

What exact OS is that? Can you post the way the database is started (I mean startup parameters)

If you make a brand new database, does SQL92 access work there?

proenv

prodb xx sports

proserve xx -S 6666

sqlexp -db xx -S 6666

does that work ?

Posted by Akioma on 21-Oct-2013 10:12

Hi,

the OS is Win7 64Bit. I also tried on Windows Server 2008R2 with the same result. I was using the following settings:

-db rbdb

-S 8910

-n 210

-Mn 8

-Ma 25

-Mi 25

-minport 10001

-maxport 10200

-SQLStmtCache 1000

-schlockwq

-maxAreas 100

-B 20000

-lruskips 100

-spin 10000

-L 20000

-bibufs 20

-aibufs 20

I should mention that on all the machines I tried there was already Progess 11.3 intalled. Maybe that is causing problems?

Just tested it with a brand new db like you suggested and there I can connect with no problem.

I now have it working on one machine. The only difference I can see is that on that machine I updated the already installed Progress 11.3 to 11.3.1

Posted by Libor Laubacher on 21-Oct-2013 10:35

One possible reason for the error above is usually large -B, but 20000 (unless there is a typo) is well within the boundaries. So if you do "sqlexp -db rbdb -S 8910" I presume it would fail? I'll keep looking.

Posted by Libor Laubacher on 21-Oct-2013 10:40

And since you mentioned 11.3.1 - can you apply it on the machine where it wasn't working before. I mean - if you can. I don't usually suggest that, but since it works on other machine - it might the simpliest way of moving forward.

This thread is closed