RE: Help with database transfer
From: dagrom (dagrom_at_discussions.microsoft.com)
Date: 10/13/04
- Next message: cwendover: "Re: SQL Server error when attempting to delete a record"
- Previous message: ChrisR: "what to search for in Profiler"
- In reply to: David: "Help with database transfer"
- Next in thread: David: "Re: Help with database transfer"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 13 Oct 2004 12:31:01 -0700
"permissions issues" is a pretty broad question any more details as to what
types of things are executing? select? updates? drops?
if using windows authentication you just need to look at the users and roles
and set these up manually.
by default sql will allow local admins on the box to have dbo priveledges on
the sql server (you might want to remove this local admin group) but the
easiest way to make the permission errors go away is to add the user causing
the failure to the windows administrators group. but this of course makes
the user an admin on the entire box so be careful.
"David" wrote:
> HI, I am moving my SQL 2000 databse to a new server on a different network.
> I have backup my datbase and then copied it over to the new server. I do a
> restore and everyting seems to be there.
> I am having permissions issues now. Are there some steps that I might have
> missed as far as permissions is concerned that can cause problems?
>
> I believe the original database was using the SA account. I have switched
> over to Windows Authentication.
>
> Thanks
> David
>
>
>
- Next message: cwendover: "Re: SQL Server error when attempting to delete a record"
- Previous message: ChrisR: "what to search for in Profiler"
- In reply to: David: "Help with database transfer"
- Next in thread: David: "Re: Help with database transfer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
