how are you changing the service account- using the "services" snap-in, or with SQL Server Configuration Manager?

Thank you- sir. That did the trick.

how about the questions I posted above?

ivan-1015146 (4/2/2012)

---

I have a 2008 server with two instances of sql server 2008 r2 running a default instance and another named. After I had a server crash the named instance...

Hmm, have you tried granting write access to the share to the computer account (ie MACHINENAME$ )

NJ-DBA (3/9/2012)

---

Sspi context problem is due to failure to register the SPN. See my previous post for the domain rights needed to do that. Also as someone else...

Sspi context problem is due to failure to register the SPN. See my previous post for the domain rights needed to do that. Also as someone else said,...

If you want every user to pass their domain credntials, you need to change the sevice acct. If you have a small group of users who need to use...

If you want every user to pass their domain credntials, you need to change the sevice acct. If you have a small group of users who need to use...

ericb1 (3/8/2012)

---

Thanks again, I really appreciate the help.

The linked server is on Server A (SQL2005):

Server Type: Other Data Source

Name: Linkedserver

Provider: SQL Native Client

Data Source: Server\SQL2008

Provider string: ...

to answer your question though, most of the local rights required are assigned when the service account is specified (hence always use SSConifuration manager to change a service account). ...

script out the linked server and post here...

nothin?

trace on the events SP:Starting, SP:StmtStarting, SP:StmtCompleted and SP:Completed. The durations of these events will give you the information you are looking for- duration of the entire proc, and...

Thanks Steve- much appreciated