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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore database to new computer by using attach function. Error pop out when replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-21 : 14:25:51
Horace writes "Dear SQL expert:

My company is using MS SQL 7 as our database. REcently, we BOUGHT a new database server.
I use attach database method to copy every database to our new server. However, problem has come. When i try to do replication on the server, error pops out and said that "old server name\sysadmin" does not have permission or something.
I believe i need to alter some in the master table in order to get that fixed. PLease Help me!!

Anyways, what is the proper way of transfer one database to another and what is the configuration of the new server.

Best REgards,
Horace
"
   

- Advertisement -