Sql initialization failed

  • 17 August 2004
  • 2 replies
  • 8 views

Badge +5
when running the K2 server an error message appears on the console says:

K2.net Server Version 3.4138.1.0 (Service Pack 1)
-------------------------------------------------
Server starting
Loading .NET Framework v1.1.4322
Framework loaded successfully
Service started under BEAT-DEVAdministrator
Sql initialization failed, retrying in 10 seconds
Sql initialization failed, retrying in 10 seconds
Sql initialization failed, retrying in 10 seconds

Also i cant register a new k2 server?

2 replies

Badge +4
A couple of obvious things to check:

* Is SQL Server running?
* If you're using Windows Authentication for the SQL Instance, are you using a Windows Account that has rights in the SQL database? Does the Service Account have rights in the K2 databases?
* Is SQL Server running as a Named Instance? I've only used K2 against a Default Instance of SQL, so I'm not sure about Named Instances...

Try re-booting the server (if that's possible) - There may be components that are in an indeterminate state...

Registering Server Instances:
I not 100% sure, but it's unlikely you'll be able to register the server until it's started up sucessfully...
Badge +1
I am currently having this issue when changing the database that the server was using. I want to change it back to the old database but it simply keeps repeating the "Sql initialization failed" every 10 seconds without end. I cannot reboot the server so how do I get it to stop trying to initialize the SQL server so I can change the database value?

Reply