Post reply

Permissions problem after upgradation to 2005

  • February 16, 2009 at 1:25 am

    #127835

    Hi.. We have done one upgraded SQL server 2000 to 2005 this saturday and we are facing with the permissions problem.

    As we upgraded the prodction server, we took backup of all DBs,logins,jobs,settings.

    The Upgradation was successful but client was ubable to transfer the pdf files from Production server to another server.

    We tried by giving permissions to all other folders. But it didnt help.

    Any help??

    Thanks in advance

  • February 16, 2009 at 1:42 am

    #944354

    I'm guessing you mean you can't copy files with a direct sql command or by the agent. The service account used to run either/or the sql server engine and/or sql agent has to have correct permissions to the folder(s) concerned. Generally within a domain you'll need this account to be a domain account if you want to move files from one server to another.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 16, 2009 at 4:38 am

    #944418

    Thanks for ur help

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply