Post reply

xp_fileexists post SP 2 upgrade

  • April 22, 2007 at 10:25 pm

    #173094

    Hi All,

    I have a problem since upgrading to SP 2 for SQL 2005. My xp_fileexists statement no longer works for any network files. I was checking successfully for their existence on Friday (although the users had to be members of the sysadmins role for this to work) but now post SP2 upgrade – the function returns 0 for all network based files.

     Has anyone had the same problem? How have you resolved it?

    Thanks so much,

    Catherine

    Kindest Regards,

    Catherine Eibner
    cybner.com.au

  • April 22, 2007 at 10:27 pm

    #701869

    I should also mention that the SQL user is a network user that has permission to access the network share. This worked prior SP2 upgrade.

    Thanks,

    Catherine

    Kindest Regards,

    Catherine Eibner
    cybner.com.au

  • July 3, 2007 at 1:42 am

    #716772

    are you sure that sql services runs under network service i just had a reading that few service account gets changed on SP installation. check if the account remins same as before.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 3, 2007 at 1:54 am

    #716777

    Thanks for the suggestion! It was actually that the user I was using was locked out on the computer the file was located on. When I tested i was using admin account - SQL was using a restricted permissions user that had been locked on the other server. The Computers are not on a domain so just using same username & password to authenticate. All of which combined so it wouldnt work! When I eventually logged into the remote server and checked the user permissions, it had the password never expires checkbox unclicked - so was expecting a change of password. The three other servers had that check box checked so the password hadnt expired on them. Was a pain to find but once located all worked well!

     

     

    Kindest Regards,

    Catherine Eibner
    cybner.com.au

  • July 3, 2007 at 7:39 am

    #716875

    The best way if you don't have a domain is to place all the servers in the workgroup so that they can have network accesses. What you said is possible and and easy solution to haev a local user and password same across all servers but it would pain in situations that you faced. There are few other risks too.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 5 posts - 1 through 4 (of 4 total)

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