J
jason
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 can go into the database window and
execute any and all of them manually. However, calling
them from code with the docmd errors out stating it
doesn't exist. I think the (dbo) issue is related to the
sql user account since the migration. 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
since I have migrated the database it connects to. It
connects fine, but all of the server objects show (dbo)
after them. I can go into the database window and
execute any and all of them manually. However, calling
them from code with the docmd errors out stating it
doesn't exist. I think the (dbo) issue is related to the
sql user account since the migration. 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