I am geeting error GetSQL2008BlockingSPIDs.vbs : Cannot login to database error , but my database is SQL 2005 Database on Windows 2003 server. Why is it coming and how to reoslve it. Also i checked that my Local system has sysadmin Role in Instance Any help apprecaited.

Hi SCOMfilmy, Are there more databases where you have the same issue? If not you might want to check your port settings. If you are installed the SCOM agent and at a later point changed the port for SQL this problem can occur. This is resolved when you reinstall the agent. regards, Marthijn.

Hi Marthijn, I tried uninstall and did fresh install, still getting the error

Hi Can you double check the versions of SQL that you have installed on the server? http://support.microsoft.com/kb/321185 Are there any SQL 2008 components? E.g. SQL Management Studio? Cheers GrahamNew SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Hi Ghram, Confirm its SQL 2005 Version is 9.00.5000 There is no SQL 2008 compnenet installed.

What version of the SQL Management Pack do you have installed? The latest is: http://www.microsoft.com/download/en/details.aspx?id=10631 Does the error include a database name. I have seen general "failed to login" errors when a database is set to autoclose (and hence is closed when SCOM tries to access it). This wouldn't however, explain why you are getting a SQL 2008 discovery error against a SQL 2005 database .... Just a thought ... if you go to the SQL Computers state view in the Operations Manager console (monitoring, microsoft sql server, computers) - does this server show up as SQL 2005 DBEngine and \ or SQL 2008 DB Engine?New SCOM 2012 Blog! - http://www.systemcentersolutions.com/blog/ View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Thanks Gram its showing under SQL 2005 DB engine in SQL Computer state view Autoclose option is also set faulse But i see lot a event id 18456 in Application log, i think thats might be causing the issue. Wwill check wil SQL DBA and update on the status

Thanks Gram its showing under SQL 2005 DB engine in SQL Computer state view Autoclose option is also set faulse But i see lot a event id 18456 in Application log, i think thats might be causing the issue. Wwill check wil SQL DBA and update on the status

Hi, I am writing to check if there is any update on this issue.Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.