Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

in my server i have 3 instances,one of them got failed, and
this cause we r not able to connect to server, how to know
which instance was dameged?

Answer Posted / sarojini makineni

Open SQL Server error log using notepad to know the Process
ID of respective instance of SQLservr.exe and stop such
process alone using Task Manager - (you may better download
procexp.exe to know the pid)

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to defragment table indexes?

990


How much space does sql server 2016 take?

974


What are the ways available in sql server to execute sql statements?

1135


How to call stored procedure using http soap?

1077


What are the reporting services components?

142


Are resultset updatable?

951


When should you use an instead of trigger?

955


What is dbcc command in sql server?

1091


Why functions are used in sql server?

960


Tell me something about security and sql azure?

114


what is a mixed extent? : Sql server administration

1102


Do you know query execution plan?

1172


Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

904


What is the security model used in sql server 2005?

1009


How to retrieve error messages using mssql_get_last_message()?

1054