what is [SQL-DMO]

what is [SQL-DMO]

• nkabirwa

  What order did you install SQL Server 2005 and SQL Server 2000 Installing SQL Server 2000 after installer SQL Server 2005 is not supported.
  
  

• Dennisfa

  has sql2k5 got a management studio i only find a sqlcmd.exe
  
  

• Alexcs786

  This version of DMO can't connect SQL Server 2005, including SQL Server Express. The Express install (I am thinking), does not update SQL-DMO. You can obtain the latest version of SQL-DMO, which is compatible with SQL Server 2000 and SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. Look for the "Microsoft SQL Server 2005 Backward Compatibility Components " download.
  
  Please let me know if this does not resolve your issue.
  
  Peter
  
  

• Colin Hardie

  Now I am able to repro the problem that you are seeing.  This MMC snap-in must be detecting a new SQL Server instance is installed, but this MMC snap-in is the old SQL Server 2000 Enterprise Manager, which is blocked from connecting to SQL Server 2005 (any edition).  The error that I am seeing is very clear on this blocking, I am not sure if you are seeing the same error.  To connect to a SQL Server 2005 instance, you should use an edition of Management Studio.
  
  Peter
  
  

• Kal_Torak

  i know what is SQL-DMO now, u think i am programming with it NO...
  
  my sql server 2005 was installed with vs2005, and i can access it in vs2005.
  
  my problem is, i cant access it in Computer Management( u get it by right-click 'My Computer->Managenet'
  
  with SQL Server Configuration Manager, which is installed accompanied with SQL Server 2005 Express, i lunached the server easily. but in Microsoft SQL Servers\...
  when i try to access it, it popup a message saying the Cause:[SQL-DMO], and it suggested me to check the setings in SQL Server Register Attribute, then i dont know what to do...
  
  

• LMiranda

  What do you mean by "in Microsoft SQL Servers\...", where are you looking   Can you provide the exact error message if one is there Check the version of SQLDMO.dll, which is located at C:\Program Files\Microsoft SQL Server\80\Tools\Binn (if your program files is on the c:\ drive)
  
  Peter
  
  

• ghawkesford

  This will never work.  You need to use Management Studio (full or Express) to connect to SQL Server 2005.  We have a bug file on our side to determine why the server is being registered.  If we fix the server registration problem, you still will not be able to connect to SQL Server 2005 through this means.
  
  Peter
  
  

• Linda-De

  i uninstalled both sql2k and sql2k5, and then installed sql2k followed by sql2k5.
  
  but still got the error message :(
  and it costed me a lot of time

  
  
  

• jonsanity

  SQLDMO.dll version = 8.05.1054
  
  error message:
  cant built connection with SQL Server
  Cause:[SQL-DMO]
  plz check if the SQL Server is running, and check SQL Server register attribute, then re-try
  
  

• Thomas Moore

  The only bug here is that the MMC snap-in is registering an unsupported SQL Server version. As this shipped with SQL Server 2000, it is very unlikely that anything more will be done than to write a knowledge based article. Unless more customers encounter this issue, we problably would not even write an article as the error message clearly says this is not supported.
  
  Peter
  
  

• rajuraju

  With which tool do you want to admister SQL Server Express SQL-DMo sounds like you are using VS2003 or another program to gain access to that.
  
  Whats the actual error message
  
  jens Suessmeyer.
  

• Balaji Thiruvenkataraju

  i d/l and installed
  Microsoft SQL Server 2005 Backward Compatibility Components
  SQLServer2005_BC.msi
  
  but...still got the error message
  
  

• ETor

  cant remember...maybe i installed sql2005express first, then sql2k
  
  so u mean i should try to re-install sql2005 again ok, i'll try

  
  
  

• nigelborrill

  so u will report this problem as a bug
  i think u should also know that i am using a chinese xp+sp2, with sql2000 installed
  
  
• what is [SQL-DMO]