jwcolby
jwcolby at colbyconsulting.com
Sun Jan 23 07:01:52 CST 2011
I can't even do a backup. It gives me a "login failed - error 4064" John W. Colby www.ColbyConsulting.com On 1/23/2011 12:52 AM, Stuart McLachlan wrote: > When you delete a use and create a new one with the same name, that is NOT the same > user. It has a different Security ID (SID). > > You will need to give rights to the new user all over again. > > One solution would be to shut down the SQL Server service, backup the database files then > create a new instance and attach the databases to it. >