| Author |
Topic |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2008-10-14 : 11:38:13
|
| Hi Gurus !!I have sqlserver 2005 developer edition on one server and now the requirement arises to connect sqlserver 7.0 from SSMS (sqlserver 2005). Please advice and guided me through the steps required to undertake to connect to sql 7.0 from SSMS.Thanks in advance.RegardsChander |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 11:48:45
|
| Use Linked Server. |
 |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2008-10-14 : 12:24:58
|
I am still not able to connect to the server, please advice some other work around.quote:
Originally posted by sodeep
Use Linked Server.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 18:44:31
|
| Did you setup linked Server Correctly? What error did you get? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-14 : 19:56:48
|
| Yes you can.The only issue I see is Compatibility issues:http://sql-server-performance.com/Community/forums/t/28315.aspx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-16 : 04:01:40
|
| You cannot use SSMS to connect to SQL 7 |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-10-16 : 05:00:35
|
| According to the microsoft site you are unable to connect to any database lower that 2000 from SSMS, but if there is a way round i would love to know! |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-16 : 09:38:06
|
| You can use OPENROWSET without setting up linked server. If you set up a DSN to the SQL Server 7, then:SELECT *FROM OPENROWSET('MSDASQL','DSN_NAME';'username';'password','select * FROM xxx.xxxxx ') AS a |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Need to connec to Sql 7.0 from SSMS 2k5