what is [SQL-DMO]

in computer management, when i expand the branch of my sql2005 express, i got a error message. it seems i cant register my server, but i cant login in sqlcmd

i also installed sql2000, and it works fine...

could anybody help really strange

Answer this question

what is [SQL-DMO]

KARINA GAMEZ
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...
chris_dk
What order did you install SQL Server 2005 and SQL Server 2000 Installing SQL Server 2000 after installer SQL Server 2005 is not supported.
RookieBalbo
i d/l and installed
Microsoft SQL Server 2005 Backward Compatibility Components
SQLServer2005_BC.msi

but...still got the error message
BatesManty

cant remember...maybe i installed sql2005express first, then sql2k

so u mean i should try to re-install sql2005 again ok, i'll try
Ubon94
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
dafan
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
MikeGB621234
has sql2k5 got a management studio i only find a sqlcmd.exe
weaselcoder
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
adam kromm

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
Lenitcha
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
norsd
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
D. Guillermo Avilez
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
Azoth
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
thecodingmo
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.
what is [SQL-DMO]

Answer this question