Follow-up;

I was able to login to the sql server after adding my user ID to this group SQLServer2005MSSQLUser$SERVERNAME$INSTANCENAME and SQLServer2005SQLAgentUser$SERVERNAME$INSTANCENAME.

I still have not figured out why windows authentication does...

Thanks for the tip, I'll give that a try and let you know.

A colleague of mine had the same problem after running the transfer db package but was able to recover as he had the sa account and password.

My ID is part of the administrator group on the server and sql server as well.

I am able to login to the server but unable to connect to the master db, same authentication issue.

Thanks for the reply. To my knowledge the accounts that have these rights are domain user accounts which require the windows authentication.

Hey, thanks Jack, I'll give these a try and let you know. I really appreciate the input.

Brian

Ahh, thanks, this does look like a better tool.

Okay, I have found the control guid files. In the MS doc http://technet.microsoft.com/en-us/library/aa964124.aspx there is a link Data_Access_Tracing.exe sample code that gives you all the files. Now I'll...

Thanks Chuck for checking it out, if I come across an answer I'll be sure to post it.

Brian

This is a disconnected process where upon a date change, the trigger is fired and the process of the XML generation is invoked. XML is then sent as a notification...

First , thanks so much for all the input and comments. Since I'm new to development but not to IT some of the comments or explanantions may be vague, sorry....

Sorry for the delayed response, that work thing gets in the way sometimes. So, the work around to the issue was to create a second executable (B.exe) that was fired by...

Thank you for the reply, it appears that a redesign is the best option at this time so we've began this. We are now focusing on having the trigger fire...