April 22, 2007 at 10:25 pm
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.
Catherine Eibner
cybner.com.au
April 22, 2007 at 10:27 pm
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
Catherine Eibner
cybner.com.au
July 3, 2007 at 1:42 am
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
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!
Catherine Eibner
cybner.com.au
July 3, 2007 at 7:39 am
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