Link to home
Start Free TrialLog in
Avatar of yostnet
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.
Avatar of yostnet
yostnet

ASKER

Also - getting this when trying to expand ....

I see something call single mode access?  would that work?
Avatar of Pavel Celba
Login as Windows Administrator and then you should also have all rights for SQL Server. Mixed mode allows it.
Avatar of yostnet

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.)
Avatar of yostnet

ASKER

this is a small business server 2011 / there is no local admin as it is technically a domain controller.
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yostnet

ASKER

thx