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
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.
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...
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
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
i d/l and installed
Microsoft SQL Server 2005 Backward Compatibility Components
SQLServer2005_BC.msi
but...still got the error message
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
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
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
What order did you install SQL Server 2005 and SQL Server 2000? Installing SQL Server 2000 after installer SQL Server 2005 is not supported.
cant remember...maybe i installed sql2005express first, then sql2k
so u mean i should try to re-install sql2005 again ? ok, i'll try
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
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
has sql2k5 got a management studio ? i only find a sqlcmd.exe
