problem In sql server 2005

• bandi_satish

  Newbie

  Points: 5

  More actions

  January 15, 2008 at 11:09 pm

  #185681

  Hi,

  I am facing a problem In sql server 2005. we installed sql server in cluster environmnet.

  During doing sometesting i mistakenly enabled VIA protocal,then i cannot start Sql server

  All forums bogs(ex: http://blogs.msdn.com/sql_protocols/archive/2006/04/28/585835.aspx) says just disable VIA then it should work

  but iam craking my head i disabled VIA still i cannot start,other than that i disable VIA ,if i restart PC its becoming Enabled.

  I dont know what is the Problem please help.

  Thanks In advance

  Satish

• Johan Bijnens

  SSC Guru

  Points: 135553

  More actions

  January 16, 2008 at 12:05 pm

  #768877

  check the sqlserver errorlog file.

  Maybe it contains the messages you need to take care of.

  (you can also post its content)

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 16, 2008 at 1:31 pm

  #768935

  I assume you're managing sql server through cluster administrator? If you take the service(s) offline you should be able to make your changes.

  Agree that the error should be in the sql error log - sql is usually very good at telling you why it won't start.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/