August 22, 2014 at 11:02 am
Hello,
I could really use some direction on how to troubleshoot applications that run on SQL Server 2008.
For instance we are trying to install a web application on our server using a wizard. The wizard runs and installs what it needs but then it gets to a certain spot and stops then does a complete roll back and un-installs everything and just quits.
What steps as a DBA can I take to find out why this install stops and does a roll back.
I have looked and the log files but they tell me nothing. Nothing registers in the log about this or at least I can't find anything.
Is the an application in SQL I can run to find out what is going on? Is there a good off the shelf application I can buy and install on the server to tell me what is going on?
I am looking for all advice on how to do this.
Thank you
August 22, 2014 at 12:41 pm
Since you are SQL Server 2008 you should use a server-side trace (ignore the section about the rowset provider) to capture what the application is trying to do on the SQL Server. It certainly seems like the installer is trying to do something that it doesn't have permissions to do and failing.
You can also check the SQL Server and Windows logs to see if there are any errors logged there.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply