Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdkottman
Starting Member
7 Posts |
 Posted - 2007-04-17 : 11:56:50
|
| We just upgraded to 2005 from a previous installation of 2000. Due to performance issues, I stopped the 2000 instance, and now the following message keeps popping up in the event log:MS SQL SNMP Extension Agent reconnecting.Following that, there are the following messages:ODBC error encountered, State = 08001, native error = 17, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied..-------------ODBC error encountered, State = 01000, native error = 2, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())..-------------ODBC error encountered, State = 08001, native error = 17, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied..-------------ODBC error encountered, State = 01000, native error = 2, error message = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())..Any suggestions?a |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 14:19:58
|
| Any SNMP tool still monitor sql2k instance? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-17 : 15:12:11
|
| Startup the 2000 instance, run SQL Profiler to capture what is connecting to the 2000 instance, stop whatever it is that you find, then shutdown the 2000 instance.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mdkottman
Starting Member
7 Posts |
Posted - 2007-04-20 : 07:43:59
|
| Thanks! I restarted to 2000 instance, and found the offending application. |
|
|
|
|
|
|
|
|
MS SQL SNMP Extension Agent reconnecting.