Friday, February 04, 2005 - 9:30 AM - 11:00 AM Pacific Time
Bryan Von Axelson, TechNet Presenter, Microsoft Corporation
In this session we show how to review SQL Server logs, SQL Server events in Event Viewer, and create a Database Maintenance plan that backs up and optimizes your SQL Server databases. We will also discuss how to use SQL Server troubleshooting tools such as SQLDiag.exe, the Database Consistency Checker, and use troubleshooting stored procedures. Finally we will create and then troubleshoot a block in SQL Server using troubleshooting tools and the SQL Server Profiler.
Please i need assistance in re-installing my SQL software. It was gving me an error message that reads SQLSTATE=IM002...[Microsoft][ODBC Driver manager].....Data source name not found and no default driver specified. If there is any response please sent to : firstname.lastname@example.org
I'm sorry with this amount of information its impossible to say what's wrong. My guess is you might beneift from reinstalling MDAC.
More information is needed - eg what version of SQL, why are you reinstalling it, the contents of sqlstp.log (in the windows directory). Do any of your other odbc applications work?
WIth this sort of information I suggest you telephone product support who will be able to take you through a diagnostic - other than that flatten the box and start again may be the easiest thing