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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-06-11 : 13:13:26
|
| why can't i connect from 2000 to 2005?i get this msg.to connect to this server you must use sql server management studio or sql server management objects=============================http://www.sqlserverstudy.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-11 : 13:15:26
|
| Because you need to use SQL Server Management Studio instead of Enterprise Manager to connect to SQL Server 2005 just like the error says.You can use Query Analyzer with limited features though.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-11 : 13:15:47
|
| connect from where?enterprise manager? query analyzer?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-11 : 13:16:54
|
  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-06-11 : 13:20:29
|
| tkizer.1.what are the limited features?2.does it mean i have to upgrade every 2000 to 2005? in order to establish a connection?=============================http://www.sqlserverstudy.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-11 : 13:44:20
|
| 1. I don't know. I use Management Studio for all of my 2005 servers.2. Why don't you just have both client tools on your machine? Use Enterprise Manager and Query Analyzer for SQL Server 2000 and use Management Studio for SQL Server 2005. They run side-by-side without any problems.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-06-11 : 14:38:29
|
| tkizer.2.Because i'm connecting remotely to 2k5. Means I remotely have 2k. Use that 2k to connect to 2k5.=============================http://www.sqlserverstudy.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-11 : 14:57:15
|
| That doesn't matter. I connect remotely to all of my servers. You just need to install the 2005 tools on your client machine.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 17:17:17
|
| Do you mean you like to query sql2k5 db from sql2k? Use linked server if it's the case. |
|
|
|
|
|
|
cant connect to 2005 from 2000 weird