testing backups; all fail; looks like a rights iss

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

testing backups; all fail; looks like a rights iss

Author

Topic

byterbit
Starting Member

9 Posts

Posted - 2011-05-31 : 22:08:10

SQL server 2008 R2 on WIN 7

Using Management Studio
Trying to learn backps; all fail with:

Backup failed for Server 'WIN7\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The server principal "win7\Administrator" is not able to access the database "testdb" under the current security context. (Microsoft.SqlServer.Smo)

I've logged into the computer as administrator and run this using WIndows Authentication.
When I try to log in with SQL server admin I get:

"A connection was successfully established with the server, but then an error"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-31 : 22:31:19

I think you'll need to start SSMS in administrative mode as Windows 7 is locked down.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

byterbit
Starting Member

9 Posts

Posted - 2011-06-01 : 14:07:23

Tara:

I tried running the EXE from a command prompt with the -m switch.
sqlservr -m does nothing; I get a square inch pop up window with a big red X and nothing happens.
Is this due to the "SQL express " issue ? does the real thing work ?
Should I give up tying to make this work and just buy the real thing ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-01 : 14:38:51

sqlservr.exe is the engine, not your client tool. Run Management Studio in admin mode and see what you get.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

byterbit
Starting Member

9 Posts

Posted - 2011-06-01 : 19:07:40

I ran it as admin; I get the same failure as I try to backup; "The server principal "win7\Administrator" is not able to access the database "testdb" under the current security context. (Microsoft.SqlServer.Smo)"
I gave up before and am installing a demo of the full product. It's taking all day but perhaps it will work.
Very kind of you to help. Any other ideas ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-01 : 19:12:32

The demo version will almost certainly have the same error.

You need to install service pack 1 as this appears to be a bug (when I googled your error message).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

byterbit
Starting Member

9 Posts

Posted - 2011-06-01 : 23:26:43

Tara:

To share a humorous incident : The new install fails to run :" FCB open failed; could not open file e:\" etc.
It's a well known bug; there on follow pages of fixes; This from a demo MS offered me, and that I pulled down today(these bugs are years old) . I think this is about it with MS SQL and I; perhaps tomorrow I'll try again, but I think I'd rather work on my sailboat.
How can MS behave this way ? I was once puzzled but now have a theory: http://networkscc.wordpress.com/2011/05/16/if-microsoft-were-run-by-people-trying-to-ruin-it/

I know you do MVP for free, and surely help people, and I know "anti" MS is in bad taste thus... but I read your blogs (and they scared me with their trials) and so I thought I'd see what you thought of this one.
It also comes to mind that I had similar issues the prior time I played with SQL Server and MS Access ; they next day I installed MYSQL (20 minutes) and Access saw it's tables more easily than those of SQL Server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources