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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2004-05-17 : 04:43:24
|
| Can I connect to SQL server 2k using sql 7 EM? currently it is not allowing me to connect, but some one told me that there is a work around.Anyone aware of it?regards,Harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.com |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-05-17 : 10:57:05
|
| I know that you cannot see named instances from a SQL 7 EM. As I recall, you can get to the default instance of a SQL 2K box.HTH*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2004-05-18 : 08:19:24
|
| Hi,There's also some new webadmin client available from Microsoft. It's called the "SQL Server Web Data Administrator" and runs on IIS. But I haven't got it working yet...Gr., Jeroen |
|
|
|
mahesh
Starting Member
6 Posts |
Posted - 2004-05-18 : 14:56:26
|
| You can do it.You make the DSN which points to your SQL2K.Then use this DSN in link server.for more information see books online for LINKED SERVERSMahesh ParanjpeSQL DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-18 : 14:58:49
|
| You wouldn't want to use a linked server for admin work though.Harshal, why can't you install the 2000 SQL client tools? With these tools, you'll be able to use 7.0 and 2000.Tara |
|
|
|
|
|
|
Connecting to sql 2k thru sql 7 EM