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 |
|
kowani1
Starting Member
42 Posts |
 Posted - 2006-11-15 : 18:28:47
|
| Hi All,I am currently merging two separate SQL Server 2000 boxes to one box.Lets call them DBS1, DBS2 and DBS3(new server hardware to house the merged dbs)The issue I am now having is after I merged all the databases, I need to recreate a linked server on DBS3 which used to be on DBS1 that linked a Database1 on DBS2.On DBS3, I am getting an "error 4060: Cannot open database requested in login '[Database1]'. Login fails, even though I know the password is correct coz when I change the data source in the linked server properties to DB2, it works just fine.Is it coz I cannot create a linked server on DB3 after the linked server database has been moved over.??Sorry for harping on a little, but has anyone had any similar issues when creating linked servers??Thanks. izak |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-15 : 21:17:25
|
| Why do you even want to do that - you have all your data in one place now, so use it in place? If you have code that refers to the old server name then update it, it will probably be bad for performance even if you can get it working. |
 |
|
|
kowani1
Starting Member
42 Posts |
Posted - 2006-11-15 : 22:20:25
|
| I was thinking that users who connected to the Linked Server pre-merging will need to have the same setup on the new server; in that way it becomes seemless to the clients.If they can ODBC directly to the Database, then I wont have to do that as you said.. |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-15 : 22:41:40
|
| The clients don't connect to a linked server, they connect to the local server and the local server connects to the linked server on their behalf, so unless they are using four part names to reference database objects you should be OK without it. If they are using four part names, get them to change that (not necessarily easy, but best in the long run). |
|
|
|
|
|
|
|
|
Can I create a linked server to a database within