Any luck with your testing?

Yes, setting your database to simple will break the chain. You can only take log backups when you database is in Full or Bulk Logged.

You will need to set...

I don't know if this answers your question or not but I run 3 different jobs.

The databases I want to be part of my transaction log shipping is set...

If the user is in IIS5 which runs in Win2k trusted for delegation is not valid because Delegation comes with Win2003 some of the reasons creating an account to use...

Great set of scripts! But...I am having one issue and I want to see if anyone else is having the same problem.

The problem I am having is with...

I figured out what the problem was.

ServerName\SQLServerMSASUser$ServerName$MSSQLSERVER Account did not have access to the D:\MSAS10.MSSQLSERVER\OLAP directory. Once I grated full control to that directory the user was able to...

I am going to update my post. If I grant the user access to Server-Wide Security they can view all of the data. and I don't want...

Thanks for the reply! BTW, great article on setting permissions. I typcially set my permissions that way. But for this user in there role I have set them up...

I use this.

Select Case

When SERVERPROPERTY ('InstanceName') Is Null Then @@SERVERNAME

Else SERVERPROPERTY ('InstanceName')

End

Thanks for the update. Don't take this the wrong way but typically what you just did is the way most DBA's deal with the issue. It's easy and it gets...

If I remember correctly you need to trust your accout that is running your SQL Service for delegation.

Add your SQL Service Account to SeEnableDelegationPrivilege under user rights.

I would only...

I would be willing to put lunch on it that it is a kerberos issue.

That link that I sent you helped me with SSRS and using pass thru authentication...

Also, This is the way I run all of my SQL Instances and I don't have any problems with login issues. It may or may not be correct but it...

Is this a web application?

Does the SQL Server you are trying to reach on the server or is it on another server?

If it is on another server I bet...

I know this thread is old, but I am going to share what worked for me.

Disable all network Protocols execpt TCP/IP on the instance you are trying to make...