hi,

Please check in services.msc and click on sql server to check it has been given permissions of network service or local

Windows installer 4.0 is installed or not

Hi,

enable it through services.msc

use tempdb

go

dbcc shrinkfile (tempdev, 'target size in MB')

go

-- this command shrinks the primary data file

dbcc...

Hi,

Ur doing this for sql server 2005 or 2008

Hi,

All permissions are set please provide info we need to give any special permissions on server, the error comes if logged in through admin account.

I'm trying to take backup for the database.

ya

i am doing all things through admin access...

Screen shot of error is attached.

Thanx for the reply i needed to set thedbowner to dbo and i managed to do it

it's a live application the query fetches info from other srvr's the thing i got it's a query which is in loop,any idea

hi Grant Fritchey

Have done everthing to solve the issue even moved db from 2005 to 2008 but still the issue persists