Friday, March 9, 2012

problem migrating db

I have an access database project that is having problems
since I have migrated the database it connects to. It
connects fine, but all of the server objects show (dbo)
after them. I think the (dbo) issue is related to the
sql user account setup. The user account no longer maps
to a domain account as it had been with the previous
server.
Here is some background information about the migration
and installation of sql server:
I am trying to migrate a database to a new server that is
running windows 2003 and sql server 2000 sp3. I have
copied a backup from the old server to the new server,
and performed a restore. However, when I restore the
database, the users in the database no longer have the
login name (the domain account associated with the user)
mapped. I can delete the accounts and recreate them, all
except the dbo user, which has a lot of objects owned by
it. Is there a way to remap this dbo user to the domain
account that I previously had it mapped to?
During the installation of sql server 2k, I do get an
error stating that sql server sp2 and less is not
supported on the version of windows I am running. I
doubt this is the problem, because I have updated it to
sp3.
Any help you can provide would be greatly appreciated.
Thanks,
Jason
Hi
dbo is the database owner if you do
sp_helpdb dbname
Then it will show the database owner. In general it is usually better to
have dbo as the owner of the objects in the database.
If you want to change the database owner look up the stored procedure
sp_changedbowner in Books Online.
For granting access to the database server check out sp_grantlogin and for
the database see sp_grantdbaccess. It is usually better to grant access to
Windows Groups (which your users belong to) rather than to individual
accounts.
The error message regarding SP3 is normal, upgrading straight away to SP3
means that you will be ok.
John
"jason" <anonymous@.discussions.microsoft.com> wrote in message
news:d9a701c43abb$9b48c770$a601280a@.phx.gbl...
> I have an access database project that is having problems
> since I have migrated the database it connects to. It
> connects fine, but all of the server objects show (dbo)
> after them. I think the (dbo) issue is related to the
> sql user account setup. The user account no longer maps
> to a domain account as it had been with the previous
> server.
> Here is some background information about the migration
> and installation of sql server:
> I am trying to migrate a database to a new server that is
> running windows 2003 and sql server 2000 sp3. I have
> copied a backup from the old server to the new server,
> and performed a restore. However, when I restore the
> database, the users in the database no longer have the
> login name (the domain account associated with the user)
> mapped. I can delete the accounts and recreate them, all
> except the dbo user, which has a lot of objects owned by
> it. Is there a way to remap this dbo user to the domain
> account that I previously had it mapped to?
> During the installation of sql server 2k, I do get an
> error stating that sql server sp2 and less is not
> supported on the version of windows I am running. I
> doubt this is the problem, because I have updated it to
> sp3.
> Any help you can provide would be greatly appreciated.
> Thanks,
> Jason

No comments:

Post a Comment