Hi;

This is on Sql Server 2005

I am copying a database from work to home. Both computers are
workstations on seperated domains (at home I have a Small Business
Server).

So I do a backup at work where the owner of the database is
WORKDOMAIN\david and restore it on my work system where I am the user
HOMEDOMAIN\david.

I have to do the restore as Overwrite the existing database because
otherwise it fails telling me that the backup file does not match the
system I am restoring to.

So I do the restore and get all the tables, data, etc. But when I go
to the database, Security, Users and then properties on dbo - the
radio button for Login name is checked - but the edit box is empty.
How do I set the user for this user/login?

thanks - dave

david@at-at-(E-Mail Removed)
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

Hi Dave,

Based on the scenario you described, you're likely running into a "orphaned
user" issue. Here are some existing kb article mentioned some means to
resolve oraphaned users cases:

#How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546

#PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/kb/274188

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(E-Mail Removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subs...#notifications.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: David Thielen <(E-Mail Removed)>
>Subject: How do I set the login for user dbo in a database
>Date: Wed, 22 Oct 2008 21:09:27 -0600
>
>Hi;
>
>This is on Sql Server 2005
>
>I am copying a database from work to home. Both computers are
>workstations on seperated domains (at home I have a Small Business
>Server).
>
>So I do a backup at work where the owner of the database is
>WORKDOMAIN\david and restore it on my work system where I am the user
>HOMEDOMAIN\david.
>
>I have to do the restore as Overwrite the existing database because
>otherwise it fails telling me that the backup file does not match the
>system I am restoring to.
>
>So I do the restore and get all the tables, data, etc. But when I go
>to the database, Security, Users and then properties on dbo - the
>radio button for Login name is checked - but the edit box is empty.
>How do I set the user for this user/login?
>
>thanks - dave
>
>david@at-at-(E-Mail Removed)
>Windward Reports -- http://www.WindwardReports.com
>me -- http://dave.thielen.com
>
>Cubicle Wars - http://www.windwardreports.com/film.htm
>

Hi Dave,

How are you doing?

Does the "resolve orphaned user" info in my last reply help you on this
issue?

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we

can improve the support we provide to you. Please feel free to let my
manager know what you think of

the level of service provided. You can send feedback directly to my manager
at: (E-Mail Removed).

--------------------

>Date: Thu, 23 Oct 2008 09:22:50 GMT
>Subject: RE: How do I set the login for user dbo in a database

>Hi Dave,
>
>Based on the scenario you described, you're likely running into a
"orphaned
>user" issue. Here are some existing kb article mentioned some means to
>resolve oraphaned users cases:
>
>#How to move databases between computers that are running SQL Server
>http://support.microsoft.com/kb/314546
>
>#PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
>http://support.microsoft.com/kb/274188
>
>Sincerely,
>
>Steven Cheng
>
>Microsoft MSDN Online Support Lead
>
>
>Delighting our customers is our #1 priority. We welcome your comments and
>suggestions about how we can improve the support we provide to you. Please
>feel free to let my manager know what you think of the level of service
>provided. You can send feedback directly to my manager at:
>(E-Mail Removed).
>
>==================================================
>Get notification to my posts through email? Please refer to
>http://msdn.microsoft.com/en-us/subs...#notifications.
>==================================================
>This posting is provided "AS IS" with no warranties, and confers no rights.
>--------------------
>>From: David Thielen <(E-Mail Removed)>
>>Subject: How do I set the login for user dbo in a database
>>Date: Wed, 22 Oct 2008 21:09:27 -0600
>>
>>Hi;
>>
>>This is on Sql Server 2005
>>
>>I am copying a database from work to home. Both computers are
>>workstations on seperated domains (at home I have a Small Business
>>Server).
>>
>>So I do a backup at work where the owner of the database is
>>WORKDOMAIN\david and restore it on my work system where I am the user
>>HOMEDOMAIN\david.
>>
>>I have to do the restore as Overwrite the existing database because
>>otherwise it fails telling me that the backup file does not match the
>>system I am restoring to.
>>
>>So I do the restore and get all the tables, data, etc. But when I go
>>to the database, Security, Users and then properties on dbo - the
>>radio button for Login name is checked - but the edit box is empty.
>>How do I set the user for this user/login?
>>
>>thanks - dave
>>
>>david@at-at-(E-Mail Removed)
>>Windward Reports -- http://www.WindwardReports.com
>>me -- http://dave.thielen.com
>>
>>Cubicle Wars - http://www.windwardreports.com/film.htm
>>
>
>

Still trying - I had to wipe my hard drive and reinstall everything
(because I got an error running ildasm and the error code did not say
what was wrong so there was no other way to fix it). I'm now trying to
get the Sql Server Administrator installed so I can try this. Some of
Microsoft's programs are very frustrating to use...

thanks - dave


On Mon, 27 Oct 2008 09:55:00 GMT, (E-Mail Removed)
("Steven Cheng") wrote:

>Hi Dave,
>
>How are you doing?
>
>Does the "resolve orphaned user" info in my last reply help you on this
>issue?
>
>Sincerely,
>
>Steven Cheng
>
>Microsoft MSDN Online Support Lead
>
>
>Delighting our customers is our #1 priority. We welcome your comments and
>suggestions about how we
>
>can improve the support we provide to you. Please feel free to let my
>manager know what you think of
>
>the level of service provided. You can send feedback directly to my manager
>at: (E-Mail Removed).
>
>--------------------
>
>>Date: Thu, 23 Oct 2008 09:22:50 GMT
>>Subject: RE: How do I set the login for user dbo in a database
>
>>Hi Dave,
>>
>>Based on the scenario you described, you're likely running into a
>"orphaned
>>user" issue. Here are some existing kb article mentioned some means to
>>resolve oraphaned users cases:
>>
>>#How to move databases between computers that are running SQL Server
>>http://support.microsoft.com/kb/314546
>>
>>#PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
>>http://support.microsoft.com/kb/274188
>>
>>Sincerely,
>>
>>Steven Cheng
>>
>>Microsoft MSDN Online Support Lead
>>
>>
>>Delighting our customers is our #1 priority. We welcome your comments and
>>suggestions about how we can improve the support we provide to you. Please
>>feel free to let my manager know what you think of the level of service
>>provided. You can send feedback directly to my manager at:
>>(E-Mail Removed).
>>
>>==================================================
>>Get notification to my posts through email? Please refer to
>>http://msdn.microsoft.com/en-us/subs...#notifications.
>>==================================================
>>This posting is provided "AS IS" with no warranties, and confers no rights.
>>--------------------
>>>From: David Thielen <(E-Mail Removed)>
>>>Subject: How do I set the login for user dbo in a database
>>>Date: Wed, 22 Oct 2008 21:09:27 -0600
>>>
>>>Hi;
>>>
>>>This is on Sql Server 2005
>>>
>>>I am copying a database from work to home. Both computers are
>>>workstations on seperated domains (at home I have a Small Business
>>>Server).
>>>
>>>So I do a backup at work where the owner of the database is
>>>WORKDOMAIN\david and restore it on my work system where I am the user
>>>HOMEDOMAIN\david.
>>>
>>>I have to do the restore as Overwrite the existing database because
>>>otherwise it fails telling me that the backup file does not match the
>>>system I am restoring to.
>>>
>>>So I do the restore and get all the tables, data, etc. But when I go
>>>to the database, Security, Users and then properties on dbo - the
>>>radio button for Login name is checked - but the edit box is empty.
>>>How do I set the user for this user/login?
>>>
>>>thanks - dave
>>>
>>>david@at-at-(E-Mail Removed)
>>>Windward Reports -- http://www.WindwardReports.com
>>>me -- http://dave.thielen.com
>>>
>>>Cubicle Wars - http://www.windwardreports.com/film.htm
>>>
>>
>>


david@at-at-(E-Mail Removed)
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

Thanks for your reply Dave,

I'm sorry to hear that, sounds quite a serious issue. Anyway, if you need
further assistance on this, please feel free to post here.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we

can improve the support we provide to you. Please feel free to let my
manager know what you think of

the level of service provided. You can send feedback directly to my manager
at: (E-Mail Removed).
--------------------
>From: David Thielen <(E-Mail Removed)>
>Subject: Re: How do I set the login for user dbo in a database
>Date: Mon, 27 Oct 2008 07:39:05 -0600
>
>Still trying - I had to wipe my hard drive and reinstall everything
>(because I got an error running ildasm and the error code did not say
>what was wrong so there was no other way to fix it). I'm now trying to
>get the Sql Server Administrator installed so I can try this. Some of
>Microsoft's programs are very frustrating to use...
>
>thanks - dave
>
>
>On Mon, 27 Oct 2008 09:55:00 GMT, (E-Mail Removed)
>("Steven Cheng") wrote:
>
>>Hi Dave,
>>
>>How are you doing?
>>
>>Does the "resolve orphaned user" info in my last reply help you on this
>>issue?
>>
>>Sincerely,
>>
>>Steven Cheng
>>
>>Microsoft MSDN Online Support Lead
>>
>>
>>Delighting our customers is our #1 priority. We welcome your comments and
>>suggestions about how we
>>
>>can improve the support we provide to you. Please feel free to let my
>>manager know what you think of
>>
>>the level of service provided. You can send feedback directly to my
manager
>>at: (E-Mail Removed).
>>
>>--------------------
>>
>>>