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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2004-09-30 : 10:39:37
|
| Can we register sql 6.5 database on 2000 instance?If yes!! How? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-30 : 11:09:09
|
| If you mean can you register a SQL 6.5 database in a SQL 2000 Enterprise Manager the answer is no. You need to use the EM that came with SQL 6.5 to register and administer a 6.5 database.-ec |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-09-30 : 11:13:42
|
| That was exactly what i meant. But, is there any other way, i can administer 6.5 database not using Enterprise Manager? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-30 : 11:31:14
|
| I'm not aware of any other tool. Keep in mind that 6.5 is no longer supported by microsoft. It is doubtful that any other developer would be making tools for it because of this. The lack of 3rd party support might also have to do with the fact that only a handful of people actually use 6.5 these days.-ec |
|
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-09-30 : 11:34:22
|
| Thanks ecI have an application in portland which uses 6.5. But wondering how to Administer it from my computer? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-30 : 11:44:03
|
quote:
Originally posted by ricky_newbee
Thanks ecI have an application in portland which uses 6.5. But wondering how to Administer it from my computer?
You'll have to get a copy of the install so you can put the 6.5 client tools on your system. They will co-exist with the SQL 2000/SQL 7.0 tools without any problem.Another option would be to use a remote console tool like VNC. I am assuming that the system is NT 4 based, but that might be a bad assumption. If it is win2k you can use remote desktop to remotely connect to the server for admin purposes. btw, NT4 doesn't have remote desktop capabilities (unless terminial server edition which is a special version). VNC might be your best choice as it is very stable and pretty lightweight.Although it is not a best practice to run the admin tools directly on the server, you are sort of between a rock and a hard place. I think best practices go out the window in these situations.best of luck.-ec |
|
|
|
|
|
|
Registering SQL 6.5 on SQL 2000 Instance