Help with an InvalidCastException with Windows Media Services on Windows Server 2008 R2

We have tried to run a SQL job for SSIS Package. But it failed during the execution with the error "[364] The Messenger service has not been started - NetSend notifications will not be sent". But in the job, no notifications have been configured and in windows server 2008/Windows-7 there is no messenger service at all.

When we search for the the messenger service in windows 7/windows server 2008, we found that service is not in both the OS and it was replaced by msg.exe. 

Any help or workaround would be appreciated.

Thanks in advance.

PS: The normal SQL jobs other than SSIS are working fine without any error.

Hi all, I'm stuck here.

I'm installing a TFS2010 with Reporting Services (SQL Server 2008).

The account is a domain account who is a local administrator, the box is a Windows Server 2008 R2, I just installed Reporting Services in the box (no database engine, no Analysis Services), in the setup I choose "Install, but do not configure the report server".

In the Connect to a report server Instance I choose the local server and the default instance and i can connect succesfuly.

The services account is network service, and in the Web service Url I click apply.

Then in the Database Tab I click create database, then select create new server database and here is where my problems start.

I cannot logon to the server with the current user, I already tried changing from "network service" to the current account but that did not help, the error I get is this:

---------------------------
Test Connection
---------------------------
Could not connect to server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow

No matter What I do, I can't seem to authenticate to SSRS using a local windows account unless that account is a member of administrators. Is there some sort of special role that local users need to be a member of to authenticate properly?

When I attempt to access reporting services, am prompted with a login window asking for login as password. If is use a local admin account it works fine, if I use a local user account, it prompts me again two times and then just shows a blank page. 

NOTES:

• I've tried adding the local non-admin user account to all of the SQLServer groups but no luck.
• I've tried deleting and creating a new local user account with the same group membership as above, but no luck.

• Word Automation Issue in Windows Server 2008 Hosting

    

  Hi,

  The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

  Word Automation in sample ASP.NET(C#) application.

  I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.
  

  When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

  But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

  Data: System.Collections.ListDictionaryInternal
  Message: Word has encountered a problem.
  Source: Microsoft Word

  The code gets failed in the following line:

  ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

  Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line
  

  I cannot able to proceed further. Can anybody please help me in solving this issue?
  

  Thank you.

  
  

  With Regards,

  Ashok