yostnet
asked on
SQL BACKUP - 2008 R2
I am trying to access and backup a couple of databases from 2008 R2 SQL SMS /
looks like it is in mixed mode - the current windows users is getting a Security context error...
They do not know the SA password so that I can log into SMS and do the backup.
looks like it is in mixed mode - the current windows users is getting a Security context error...
They do not know the SA password so that I can log into SMS and do the backup.
ASKER
Login as Windows Administrator and then you should also have all rights for SQL Server. Mixed mode allows it.
ASKER
I am administrator
That's not enough. You have to login on the SQL Server machine under the local Administrator account. In such case you have access to all databases as Trusted login user. (Of course this feature is possible to switch off.)
ASKER
this is a small business server 2011 / there is no local admin as it is technically a domain controller.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx
ASKER
I see something call single mode access? would that work?