Microsoft SQL 2008 Agent not starts

I was playing around with VMware vSphere ESXi 4.1 & vCenter 4.1 together with Microsoft Windows Server 2008 & Microsoft SQL 2008. I can login to my vCenter and everything seems to be work perfectly. Due to certain reason, I have rebooted the Windows server and the incident happen. The VMware Virtual Center service and SQL Agent do not start. The VMware vCenter service is highly depending on SQL Services before it can startup.

The SQL agent event log show as example below:

Log Name: Application
Source: SQLAgent$SQL2008
Date: 10/9/2008 11:22:57 AM
Event ID: 103
Task Category: Service Control
Level: Error
Keywords: Classic
User: N/A
Computer: WIN2K8.local.planetmy.com
Description:
SQLServerAgent could not be started (reason: Unable to connect to server ‘WIN2K8\VCSQL2008′; SQLServerAgent cannot start).
Read more

Possibly Related Posts:


September 14, 2010 · Filed Under Tips, VMware

2 Comments 

lppasswd: Unable to open passwd file: Permission denied

The lppasswd command used to adds, changes, or deletes passwords in the CUPS digest password file which refer to /etc/cups/passwd.md5.

In order to create a new CUPS administrator user, enter a command: lppasswd -g sys -a username.

I’m having a problem creating a new user with error message: “lppasswd: Unable to open passwd file: Permission denied” today.

lppasswd

And I just would like to share the solution as below:
Read more

Possibly Related Posts:


November 11, 2009 · Filed Under How's To, Open Source

1 Comment 

Missing /var/log/lastlog

The /var/log/lastlog file is a lastlog logging file which save all the last user login logs.


planetmy:~ # rpm -qf /usr/bin/lastlog
pwdutils-3.x.x.x-xx.xx

The Linux lastlog command use to prints the contents of the last login log. The login-name, port, and last login time will be printed.

For an example:

kajarona pts/137 140.171.171.73 Tue Oct 13 14:31:55 +0200 2009
aszg pts/82 140.171.171.11 Wed Nov 4 07:14:24 +0100 2009
ciakp pts/111 140.171.171.11 Tue Nov 3 07:44:41 +0100 2009
tkaj pts/68 140.171.171.64 Tue Nov 3 12:32:05 +0100 2009
ragab pts/108 149.223.30.18 Wed Nov 4 12:55:46 +0100 2009
aqelsp **Never logged in**
qrsnid pts/169 149.223.30.22 Thu Nov 5 08:52:10 +0100 2009
qqacharaj **Never logged in**
poygies pts/187 140.171.171.17 Thu Nov 5 09:50:33 +0100 2009
bojakt pts/11 140.171.171.101 Wed Nov 4 15:03:47 +0100 2009
chomata pts/182 149.223.20.86 Thu Nov 5 10:16:33 +0100 2009

Read more

Possibly Related Posts:


November 5, 2009 · Filed Under Open Source, Tips

Comment 

How to Add Date And Time To Your Bash History on SuSE Linux

The SuSE Linux Enterpise 10 which came together with bash-3.x RPM and HISTORY command show insufficient information(at least for me) as example below:

1 vi /etc/hosts
2 rpm -qa|grep bash
3 cat /etc/SuSE-release
4 history

For any SuSE Linux Enterprise server 10 that managed by more than one people, I would suggest you should make history command more user friendly and more information for auditing purposes.

Edit /etc/bash.bashrc and append to the bottom:

export HISTTIMEFORMAT="%h/%d - %H:%M:%S "

save it.
Read more

Possibly Related Posts:


June 7, 2009 · Filed Under How's To, Open Source, Tips

Comment 

How to set Auto Complete “service” command on Redhat

I have been using SuSE Linux for some time and I love SuSE Linux service script that activated with a symbolic link. In order to start a SSH service, I can easily issue a command “rcsshd start”.

For Redhat or Centos Linux, you’re require to type command such as “service sshd start” and the main problem is NO auto complete for service command by default. Yes I admitted I’m lazy guy!

So how to set AUTO COMPLETE “service” command on Redhat/Centos?

Type:
complete -W "$(ls /etc/init.d/)" service
Read more

Possibly Related Posts:


January 19, 2009 · Filed Under How's To, Open Source, Tips

Comment 

Next Page →

Planet Malaysia
  • Follow us on Twitter


    • web www.planetmy.com