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 |
|
pssheba
Yak Posting Veteran
95 Posts |
 Posted - 2007-11-26 : 11:19:35
|
| Hi everyone,I've just installed my new sql express server. I've been working until now on a SQL SERVER 2000 and first thing i'd like to do, having installed the SQL EXPRESS is connecting to my old SQL 2000 databases using SQL EXPRESS. Can anyone tell me how to do it ?Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-26 : 12:54:24
|
| Go into management studio and register the 2000 server.You may want to check that remote connections are turned on in your surface area configuration first though. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-27 : 01:53:09
|
| >> connecting to my old SQL 2000 databases using SQL EXPRESSVia linked server? |
|
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2007-11-27 : 03:38:23
|
quote:
Originally posted by RickD
Go into management studio and register the 2000 server.You may want to check that remote connections are turned on in your surface area configuration first though.
Thanks a lot RickD, I managed to do it. |
|
|
|
|
|
|
connecting to sql server 2000 database