Click here to Skip to main content
15,911,142 members
Home / Discussions / C#
   

C#

 
AnswerRe: SQL connectivity issue in My own Windows Serive Pin
Covean27-Jan-10 1:01
Covean27-Jan-10 1:01 
You should change the service config/start state by setting the "SeviceDependedOn" value with an array of services that needs to be started before your service can start.

ServiceInstaller example:

[RunInstallerAttribute(true)]
public class ControllerInstaller : Installer
{

    public ControllerInstaller()
    {
        processInstaller=new ServiceProcessInstaller();
        serviceInstaller=new ServiceInstaller();
        processInstaller.Account=ServiceAccount.LocalSystem;
        serviceInstaller.StartType=ServiceStartMode.Automatic;
        serviceInstaller.DisplayName = "ServiceDisplyName";
        serviceInstaller.ServiceName = "ServiceName";
        serviceInstaller.ServicesDependedOn = new string[] { "MSSQL$SQLEXPRESS" };
        Installers.Add(serviceInstaller);
        Installers.Add(processInstaller);
    }

    private ServiceInstaller serviceInstaller;
    private ServiceProcessInstaller processInstaller;
}


Now your service depends on a service called MSSQL$SQLEXPRESS (service name not display name) and
the system tries to start this service before yours. If it can't start this service your service can't start too.


Here some code to do this execution time:
(You need the permissions to access these registry keys!)

string[] szArrayDependsOn = (string[])Registry.GetValue("HKEY_LOCAL_MACHINE\\System\\CurrentControlSet\\Services\\[YourServiceName]", "DependOnService", null);
if ((szArrayDependsOn == null) || (szArrayDependsOn.Length != 1) ||
    (szArrayDependsOn[0] == null) || (szArrayDependsOn[0].ToUpper() != "MSSQL$SQLEXPRESS")
{
    Registry.SetValue("HKEY_LOCAL_MACHINE\\System\\CurrentControlSet\\Services\\[YourServiceName]", "DependOnService", new string[] { "MSSQL$SQLEXPRESS" }, RegistryValueKind.MultiString);
}


Greetings
Covean

AnswerRe: SQL connectivity issue in My own Windows Serive Pin
PIEBALDconsult27-Jan-10 5:32
mvePIEBALDconsult27-Jan-10 5:32 
GeneralRe: SQL connectivity issue in My own Windows Serive Pin
WinCrs27-Jan-10 18:19
WinCrs27-Jan-10 18:19 
Questionrecursive folder compare Pin
vantoora26-Jan-10 23:39
vantoora26-Jan-10 23:39 
AnswerRe: recursive folder compare Pin
SeMartens26-Jan-10 23:55
SeMartens26-Jan-10 23:55 
GeneralRe: recursive folder compare Pin
vantoora27-Jan-10 19:00
vantoora27-Jan-10 19:00 
GeneralRe: recursive folder compare Pin
vantoora29-Jan-10 2:16
vantoora29-Jan-10 2:16 
QuestionRendering issue C# Pin
Paul Harsent26-Jan-10 23:28
Paul Harsent26-Jan-10 23:28 
AnswerRe: Rendering issue C# Pin
tolw27-Jan-10 19:30
tolw27-Jan-10 19:30 
QuestionExplicit casting with Type variable Pin
Kaikus26-Jan-10 23:21
Kaikus26-Jan-10 23:21 
AnswerRe: Explicit casting with Type variable Pin
OriginalGriff26-Jan-10 23:45
mveOriginalGriff26-Jan-10 23:45 
GeneralRe: Explicit casting with Type variable Pin
Kaikus27-Jan-10 0:48
Kaikus27-Jan-10 0:48 
GeneralRe: Explicit casting with Type variable Pin
OriginalGriff27-Jan-10 1:16
mveOriginalGriff27-Jan-10 1:16 
GeneralRe: Explicit casting with Type variable Pin
Kaikus27-Jan-10 22:21
Kaikus27-Jan-10 22:21 
GeneralRe: Explicit casting with Type variable Pin
Gideon Engelberth27-Jan-10 4:40
Gideon Engelberth27-Jan-10 4:40 
GeneralRe: Explicit casting with Type variable Pin
Kaikus27-Jan-10 22:26
Kaikus27-Jan-10 22:26 
GeneralRe: Explicit casting with Type variable Pin
Gideon Engelberth28-Jan-10 2:47
Gideon Engelberth28-Jan-10 2:47 
AnswerRe: Explicit casting with Type variable Pin
PIEBALDconsult27-Jan-10 5:33
mvePIEBALDconsult27-Jan-10 5:33 
QuestionExecute smtpclient authenticate method from reflection? Pin
ankit_verma26-Jan-10 23:14
ankit_verma26-Jan-10 23:14 
AnswerRe: Execute smtpclient authenticate method from reflection? Pin
SeMartens26-Jan-10 23:45
SeMartens26-Jan-10 23:45 
GeneralRe: Execute smtpclient authenticate method from reflection? Pin
ankit_verma26-Jan-10 23:48
ankit_verma26-Jan-10 23:48 
GeneralRe: Execute smtpclient authenticate method from reflection? Pin
SeMartens26-Jan-10 23:53
SeMartens26-Jan-10 23:53 
GeneralRe: Execute smtpclient authenticate method from reflection? Pin
ankit_verma27-Jan-10 0:10
ankit_verma27-Jan-10 0:10 
GeneralRe: Execute smtpclient authenticate method from reflection? Pin
SeMartens27-Jan-10 0:17
SeMartens27-Jan-10 0:17 
GeneralRe: Execute smtpclient authenticate method from reflection? Pin
ankit_verma27-Jan-10 0:23
ankit_verma27-Jan-10 0:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.