Thanks for your reply...

Ss .. this might be the reason for that.

Anyother answer ?

Hi Ankur,

thanks for your reply ...

while running this query in sql server 2008 its showing result as running but...

thks for your reply...

i have one more question.i want send mail if sql server agent is not running .how do i find status of sql agent ?

Thanks in...

are you telling to open the default port of sql in windows fire wall or tcp/ip filter ?

k .. thanks your reply ....

Do you know the reason for this issue ?

MM.. this is the only way to change the network binding order of virtual work order ... 🙂 ...

you can change the network binding of the physical network adapter but you can not change binding order of the virtual network adapter order ...

Has anyone resolved the above issue ?

its helped me to resolve this issue...

"The Sql Server Analysis Service (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to...

i have got solution for this issue ....

HKLM\System\CurrentControlSet\Services\TCPIP\Linkage

change your network adapter binding in above reigistry path and you can verify the network adapter order by ipconfig command....

sudhakara (7/18/2009)

---

GilaMonster (7/18/2009)

---

sudhakara (7/18/2009)

---

It'll help, but more than...

GilaMonster (7/18/2009)

---

sudhakara (7/18/2009)

---

It'll help, but more than 8...

GilaMonster (7/18/2009)

---

sudhakara (7/18/2009)

---

i am going to create one data file for each cpu processor with equal size for tempdb so how it will chose the data file to allocate extend...

george sibbald (7/18/2009)

---

I have never applied a SP to a multi node cluster so I won't comment on that, but if this is a two node cluster leave both nodes...