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 |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2008-03-31 : 13:55:55
|
| Our Production server is Windows 2003 and SQL 2000 Enterprise. The server name is VB-GP.I dumped 2 of the databases from the production server and restored them to server name SQL2K5-Pub (a TEST server) which was a fresh install of Windows 2003 and SQL 2000 Enterprise. I then upgraded this "TEST" server to SQL 2005 Enterprise. All is fine so far.Now I'm setting up Transactional Replication in my test environment. I configured SQL2K5-Pub as a Distributor which went well. I created a a Publication of 1 database which went well. I attempted to create a Publication of the second database and received the following error.Error Message*********************************************************************Could not find server 'VB-GP' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. Could not use view or function '[dbo].ContractBillingStatus_*********************************************************************Remember - server name VB-GP is the production server but I have restored to a test server with a different server name. I do not want the production server to have any part of my test environment.Any ideas?Thanks,Terry |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 14:03:01
|
| Confused!!!! Which server is your publisher and subscribers? Is it replication from SQL 2000 to SQL 2005? |
 |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2008-03-31 : 14:54:18
|
| Sorry. I never made it to configuring the subscriber so I didn't list it in my post.Production: VB-GP (No replication)Test EnvironmentPublisher/Distributor: SQL2K5-PubSubscriber: SQL2K5-SubReplication is only being tested in the test environment between SQL 2005 servers.Hope this helps.Thanks,Terry |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 15:01:37
|
| So why your replication has relation to Production: VB-GP ? you should be fine. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 22:59:35
|
| Run 'select @@servername' on SQL2K5-Pub, what do you get? |
|
|
|
|
|
|
sp_addlinkedserver