This is how I do it.
- Copy the original db and log files to the new server
- Enterprise Manager: Attach database.
- SQL Query Analyzer: Change owener of all tables/view to dbo. In Query
Analyzer, choose "Query/Results in text". Run the following query:
select 'sp_changeobjectowner [bmssa.' + name + '] , [dbo]' + Char(13) +
'GO'
from sysobjects
where xtype = 'u' or xtype = 'v'
order by name
Use the result of this query, copy in to a new query. The new query does
the actual job of changing the object names.
- Ent. Man: Chose axdb/users. Delete bmssa.
- Ent. Man/Security: Make new login bmssa, make it db_owner of axdb.
- Repeat step from Query analyzer, just replace dbo with bmssa and
bmmssa with dbo.
Thats it :)
Regards,
Morten
-----Original Message-----
From: hilda cabrejos [mailto:[EMAIL PROTECTED]
Sent: 5. januar 2005 14:24
To: [email protected]
Subject: [development-axapta] restore sql server, user bmssa problem
Hello everybody, happy New Year
We have the following problem; we did a transfer of DB SQL SERVER 2000
from one server to another, when it is doing the transfer it says it has
failed because de user bmssa in the destiny server doesn't exist.
We have done the following we do a restore of the DB in another server
that has another server name and when the restore finishes, we try to
enter AXAPTA and get an error because bmssa does not exist. After the
restore in the table SYSUSER we find the user bmssa that has not been
created in the new restored DB and in the security, login. When we try
to create bmssa he doesn't let us.
What are we doing wrong?
Thank you for any help
Hilda Cabrejos
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
