Event Forwarding - Error Code is 2150858895

I noticed a problem today where my Event Collector server stopped receiving any forwarded events a few weeks ago. I'll skip to the condensed resolution below as all the WinRM and Wecutil troubleshootings steps returned positive results.

The EventCollector log contained:
The Subscription <subscription name> could not be activated on machine due to an error. Error Code is 2150858895. Subscription will remain inactive on this target until subscription is resubmitted / reset.

The subscription itself was listed as inactive and when attempting a retry I received "The client could not start a valid listener to receive subscription events based on the specified input settings".

I used winrm e winrm/config/listener and saw that the WinRM settings were coming from GPO. I took away the server's apply rights to that specific GPO applying WinRM settings, ran a gpupdate /force, used winrm e winrm/config/listener again and confirmed that GPO was no longer configuring those settings. Once this was complete, I could successfully re-enable my subscriptions

Reply:

Good one. Thanks for sharing with us.

------------------------------------

Windows 8 acceleration improvements vs. Windows 7

http://news.cnet.com/8301-10805_3-57478350-75/microsoft-explains-how-windows-8-smokes-windows-7/?part=rss&subj=news&tag=title

Hey, just 'Point or Interest'... Don't shoot the messenger

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Reply:

Funny thing that in this day and age, where CPUs have finally gotten so hugely fast that even the most basic GDI stuff is just instantaneous, we're seeing more development on the GPU side.

Speed is good, but I didn't see one mention of any advances in color-management, unfortunately. I was hoping maybe someone's been working to make it easier for apps to ensure they're displaying accurate color, but that front doesn't seem to have gotten much attention. Notably IE10, one of the "poster children" for DirectX implementation, doesn't do color-management properly (it assumes every monitor is sRGB, just like its predecessor, IE9).

-Noel

Detailed how-to in my eBooks:

Configure The Windows 7 "To Work" Options
Configure The Windows 8 "To Work" Options

------------------------------------

Calendar(s) Syncing

It is kinda neat how Calendar APP, Outlook Calendar & Hotmail Calendars are in step w/ each other. Put an entry for an appointment or whatever in, say, the Calendar APP & it goes in the Outlook & Hotmail Calendars, as well.

No biggie, just kinda neat.

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Mail Merge - Word 2007 & Outlook 2007 - Permissions, multiple addresses, attachments

Hi,

Three mail merge questions. I generally prepare the mail merge in Word 2007, using an excel spreadsheet with the recipient list and the Word mail merge wizard. I then click the final button on the wizard (Merge > Electronic Mail) to do the merge in Outlook 2007.

1. Right now, when I do it, I have Outlook and Word open at the same time. Outlook notifies me that another program is trying to access outlook and asks me to ALLOW and give Word permission to complete the merge. This happens even when I selected ALLOW for 10 minutes. This is highly annoying, since I often have a large number of emails on the merge and Outlook asks me to individually approve each one. Is there a workaround for this?

2. Is it possible to use mail merge to copy people on the same email? For example, let's say I want to email Adam and Bob, who are on the same team at a company I'm contacting. My understanding is that it's not possible to send them the same email (i.e., one email, two recipients); Outlook typically can't read the email address when I try this. Is this true?

3. It seems like it's not possible to add attachments in mail merge. Is that correct?

Thanks,

Ken

Reply:

If this is a common scenario for you you might be better off looking for a dedicated mass emailing program. One among many is this: http://www.emailsmartz.com/asp/sender.asp.

------------------------------------
Reply:

We are also encountering this in Outlook 2010. Did you ever find help from another source for your issue?

Thanks,

Rob

------------------------------------
Reply:

This appears to be a issue when you antivirus is not up to date. I experienced the same problem and found this:

Change this setting or update your anti-virus and that should do it.

------------------------------------
Reply:

I use this link, and is fine but I cannot run de Macro... even when I verified the Outlook library:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

If someone can help :)

Thanksss!!!!!!!!

------------------------------------
Reply:

Ken,

In my experience, it is even worse than what you describe in #1. I have to click "Allow" for each and every email in my merge file, like you do. But my anti-virus software is up to date, so that's not the problem. AND, the warning message clearly says, "For more information about e-mail safety and how you might be able to avoid getting this warning, click Help." Which is a false statement. Clicking "Help" take you to a generic page where you have to search for the answer, which does not appear to exist. All I get is this forum, where there are questions but no answers.

Tim

------------------------------------
Reply:

TJR,

I have had the exact same issues. I have McAfee on my work computer that is completely up to date. I still have to click "Allow" for each and every email. The biggest annoyance, though, is that you have to wait a second or two in between while it transfers the document. While it is doing that, the "Allow" button is disabled. I would like to get an answer for this.

I also agree that is is quite annoying that the "help on this topic" is the generic online help page for Outlook.

------------------------------------
Reply:

This is a security issue which used to be common in previous versions of Office. Try Click Yes - a free tool which you can use to prevent the security prompt. See: http://www.contextmagic.com/downloads.htm

Cathy Allington You Grow Pty Ltd

------------------------------------
Reply:

could u resolve the issue?

------------------------------------

SSP Silverlight Replacement

Does anyone know of any 3rd party products that would replace the SSP? The issue we have is with Sliverlight not working on several platforms we need the portal available on. I've looked at Cireson but their tools seem more for the analyst, not the end user.

Reply:

Hello Jon,

I only have seen a mobile client from the guys at Link Development, but that's about it.
http://fawzi.wordpress.com/2012/06/26/service-manager-2012-new-solution-service-manager-mobile-client-for-windows-phone-7/

The rest was unfortunately Silverlight based.

- Dennis | Netherlands | Blog | Twitter

------------------------------------

hotmail

trying to close my hotmail account because i have been hacked and i cant read anything on there because its a different language what do i do? please help

Moved by JOshiro Tuesday, July 24, 2012 5:47 PM Hotmail question (From:Live Connect)

Reply:

Please ask this on the Hotmail forum instead:

http://answers.microsoft.com/en-us/windowslive/forum/hotmail

------------------------------------

SSRS 2005 Dataset execution failure..

Hi,

Can anyone help me please..

I have below stored procedure and when i try to preview the report using ssrs 2005 i get this error "An error occurred during local report processing.an error has occurred during report processing.Query execution failed for data set "test" incorrect syntax near xyz(report name)"

USE [test]
GO
/****** Object: StoredProcedure
[dbo].[xyz_001]    Script Date: 07/21/2012
14:59:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER
ON
GO
/*
This procedure returns data for a reporting services
commission report. Specifically it returns data for Percent
commisisons.

Check to make sure that the post process that populates the
reporing table is not running.
Check to make sure that the current date is at
least 6 days into the month following the requested report month.
Utilize a
series of queries and table variables to generate the commission report. This
report returns the following data:
    Cruise Line ID
    Cruise
Line
    ShipID
    Ship
    ContractID
    Contract Start
Date
    Contract End Date
    Report Start Date
    Report End
Date
    Chargeable MOU
    SMS MO count
    Data MB
    Total
Revenue
    Voice Revenue
    SMS Revenue
    Data Revenue
    Voice
Commission Rate (%)
    SMS Commission Rate (%)
    Data Commission Rate
(%)
    Voice Commission
    SMS Commission
    Data Commission

Voice Mimimum In Service Ships for rate
    Voice Maximum In Service Ships
for rate
    Voice Ships In Service
    SMS Mimimum In Service Ships for
rate
    SMS Maximum In Service Ships for rate
    SMS Ships In
Service
    Data Mimimum In Service Ships for rate
    Data Maximum In
Service Ships for rate
    Data Ships In Service
*/
ALTER PROCEDURE
[dbo].[xyz_001]
    @pMonth    int --
Month number for which the commission report should be generated. e.g. 12 =
December
    ,@pYear int -- Year for which report should be generated

,@pUserName as varchar(256) -- Name of xyz user for which the report should
be generated.

AS
BEGIN

IF (SELECT
dbo.fnDailyPostProcessRunningCheck()) > 0
BEGIN
    RETURN
0
END

DECLARE
    @vStartDate    datetime
    ,@vEndDate
datetime
    ,@vDaysInMonth int
    ,@vBytesPerKb int
    ,@vKbPerMb
int
    ,@vUserId as uniqueidentifier

SET @vBytesPerKb = 1024
SET
@vKbPerMb = 1024
SET @vStartDate = cast( cast(@pMonth as varchar(2)) + '/1/'
+ cast(@pyear as varchar(4)) as datetime)
SET @vDaysInMonth =
dbo.fnGetDaysInMonth(@vStartDate)
SET @vEndDate = cast( cast(@pMonth as
varchar(2)) + '/' + cast(@vDaysInMonth as varchar(2)) + '/' + cast(@pyear as
varchar(4)) as datetime)

IF DateAdd(dd,6,DateAdd(mm,1,
@vStartDate)) > GetDate()
BEGIN
    RETURN -1
END

DECLARE
@UserShips TABLE
(
    ID int
    ,Name varchar(256)

,CruiseLineID int
    ,ServiceDate datetime
    ,ServiceEndDate
datetime
)

--SET @vUserId = dbo.fnUserIdGetByUserNameandApplication
(@pUserName,'/')

/*
Create a list of all of the ships that this user
has been provisioned to see.
*/
INSERT INTO @UserShips
(Id,Name,CruiseLineID,ServiceDate,ServiceEndDate)
(SELECT    Us.ShipID as ID,
s.name, s.cruiselineid, s.ServiceDate, s.ServiceEndDate
       FROM userShip
us
       JOIN ship s
         ON s.Id = us.ShipId
     -- WHERE
us.UserID = @vUserId
     UNION
     SELECT    s.Id, s.name,
s.cruiselineid, s.ServiceDate, s.ServiceEndDate
       FROM ship s

JOIN userCruiseline ucl
         ON s.cruiselineId = ucl.cruiselineId

         --AND ucl.UserId = @vUserId
     UNION
     SELECT    s.Id,
s.name, s.cruiselineid, s.ServiceDate, s.ServiceEndDate
       FROM ship
s
       JOIN cruiseline cl
         ON cl.ID = s.cruiselineId

JOIN userCompany uc
         ON uc.companyId = cl.companyId
           --
AND uc.UserId = @vUserId
)

--SELECT * FROM
@UserShips

DECLARE @ContractShips TABLE
(
    ContractID int

,ContractStart datetime
    ,ContractEnd datetime
    ,CruiseLineId
int
    ,IsChargeableOnly tinyint
    ,ShipID int
    ,ShipName
varchar(100)
    , ServiceDate datetime
    , ServiceEndDate datetime

)

/*
Get a complete list of all contracts and all ships "active"
at some point during each contract
*/
INSERT INTO @ContractShips (

     ContractID
        ,ContractStart
        ,ContractEnd

        ,IsChargeableOnly
        ,CruiseLineId

,ShipID
        ,ShipName
        ,ServiceDate

        ,ServiceEndDate
)
(
    SELECT
cc.ID,cc.StartDate,cc.EndDate,cc.IsChargeableOnly, s.cruiselineid,s.id, s.name,
s.ServiceDate, s.ServiceEndDate
    FROM commissionContract cc
    JOIN
CommissionType ct on ct.Id = cc.CommissionTypeID
    LEFT JOIN
CommissionContractShip ccs on ccs.CommissionContractID = cc.id
    LEFT JOIN
CommissionContractCruiseLine cccl on cccl.CommissionContractID = cc.id

LEFT JOIN ship s on (s.cruiselineid = cccl.cruiseLineID OR ccs.shipid =
s.id)
    WHERE cc.StartDate <= @vEndDate
          AND cc.EndDate
>= @vStartDate
          AND s.ServiceDate <= @vEndDate

AND s.ServiceDate <= cc.EndDate
          AND (s.ServiceEndDate IS NULL OR
s.ServiceEndDate >=@vStartDate)
          AND (s.ServiceEndDate IS NULL OR
s.ServiceEndDate >=cc.StartDate)
          AND ct.Name ='Percent'

GROUP BY cc.ID,cc.StartDate,cc.EndDate,cc.IsChargeableOnly,
s.cruiselineid,s.id, s.name, s.ServiceDate,
s.ServiceEndDate
)

--SELECT * FROM @ContractShips

DECLARE
@ContractReportBreaks TABLE
(
    ContractID int
    ,ReportingDate
datetime
)

/*
Build up a complete list of date ranges that need to
be reported on for each ship based on Contract Dates and Ship Service
Dates
This includes contract start and end dates and any dates on which ships
under a contract have either a start or end of service date
*/
INSERT INTO
@ContractReportBreaks (
        ContractID
        ,ReportingDate

)
(
    SELECT ContractID
    ,(CASE WHEN (ContractStart >
@vStartDate) THEN ContractStart
           ELSE @vStartDate
      END) AS
ReportingbreakDate
    --, 'ContractStart' as DateType
    FROM
@ContractShips
    GROUP BY ContractID
    ,(CASE WHEN (ContractStart >
@vStartDate) THEN ContractStart
           ELSE @vStartDate
      END)

    UNION

    SELECT ContractID
    ,(CASE WHEN
(ContractEnd < @vEndDate) THEN ContractEnd
           ELSE @vEndDate

   END) AS ReportingbreakDate
    FROM @ContractShips
    GROUP BY
ContractID
    ,(CASE WHEN (ContractEnd < @vEndDate) THEN
ContractEnd
           ELSE @vEndDate
      END)

UNION

    SELECT ContractID, dateadd(dd,-1,ServiceDate) -- we add
subtract a day because the break in report needs to happen the previous
day
    FROM @ContractShips
    WHERE ServiceDate > @vStartDate -- use
> instead of >= because we are subtracting a day for the reporting
event
        AND ServiceDate > dateadd(dd,1,ContractStart) -- add a day
because we don't want to add a date equal to or prior to the contract
start
        AND ServiceDate <= ContractEnd -- use <= as we will be
subtracting the end date so a servicedate = contractend will result in a break
one day earlier
    GROUP BY ContractID, ServiceDate

UNION

    SELECT ContractID, ServiceEndDate --we don't need to do any
date tweaking with the end dates because it is inclusive so the break point be
on the enddate
    FROM @ContractShips
    WHERE ServiceEndDate <=
@vEndDate
        AND ServiceEndDate > ContractStart
        AND
ServiceEndDate < ContractEnd
    GROUP BY ContractID, ServiceEndDate

--ORDER BY contractid, reportingbreakdate

)

--SELECT * FROM
@ContractReportBreaks

DECLARE @ContractReportDates TABLE
(

ContractID int
    ,StartDate datetime
    ,EndDate datetime

,ActiveShips int
    ,ContractType varchar(100)
)

/*
Using the
@ContractReportBreaks, create the list of start and end dates for which
will
define the reporting date range breaks for each contract.
Build up
a complete list of date ranges that need to be reported on for each ship based
on Contract Dates and Ship Service Dates
*/
DECLARE @vLastContractId
int
        ,@vLastEndDate datetime
         ,@vCurrentContractId
int
        ,@vCurrentReprtingDate datetime
        ,@vCurrentStartDate
datetime
        ,@vCurrentEndDate datetime
        ,@vContractType
varchar(100)

SET @vLastContractId = -1

DECLARE
AllContractReportDateCursor CURSOR FOR
    SELECT ContractID,ReportingDate

    FROM @ContractReportBreaks
OPEN AllContractReportDateCursor

FETCH NEXT FROM AllContractReportDateCursor
    INTO
@vCurrentContractId,@vCurrentReprtingDate

WHILE @@FETCH_STATUS =
0
BEGIN
            IF @vLastContractId != @vCurrentContractId

         BEGIN
                    SET @vLastContractId =
@vCurrentContractId
                    SET @vCurrentStartDate =
@vCurrentReprtingDate
                    SET @vContractType = 'New BEFORE
FETCH'
                    FETCH NEXT FROM AllContractReportDateCursor

                     INTO @vCurrentContractId,@vCurrentReprtingDate

             SET @vCurrentEndDate = @vCurrentReprtingDate

SET @vLastEndDate = @vCurrentEndDate
                    SET @vContractType
= 'New AFTER FETCH'
                END
            ELSE

     BEGIN
                    SET @vCurrentStartDate =
DateAdd(dd,1,@vLastEndDate)
                    SET @vCurrentEndDate =
@vCurrentReprtingDate
                    SET @vLastEndDate =
@vCurrentEndDate
                    SET @vContractType = 'Existing'

             END

            INSERT INTO @ContractReportDates

            (
                ContractID
                ,StartDate

                ,EndDate
                ,ContractType

--,ActiveShips
            )
            VALUES

(@vCurrentContractId
             ,@vCurrentStartDate

,@vCurrentEndDate
                ,@vContractType
            )

        FETCH NEXT FROM AllContractReportDateCursor
            INTO
@vCurrentContractId,@vCurrentReprtingDate
END
CLOSE
AllContractReportDateCursor
DEALLOCATE AllContractReportDateCursor

--SELECT * FROM @ContractReportDates

/*
Now identify the
active ships for each one of the contract reporting dates
*/
DECLARE
@ContractRates TABLE
(    ID int identity(1,1)
    ,ContractID int

,ContractStart datetime
    ,ContractEnd datetime
    ,IsChargeableOnly
tinyint
    ,MinActiveShips int
    ,MaxActiveShips int

,ActiveShips int
    ,ReportStartDate datetime
    ,ReportEndDate
datetime
    ,Rate money
    ,CallCategoryId int
    ,CallCategoryName
varchar(5)
)

/*
Build up the list of contract rates, report dates,
active ships and voice,sms,data rates for the final reporting
*/
INSERT
INTO @ContractRates( ContractID
                ,ContractStart

                ,ContractEnd
                ,IsChargeableOnly

                ,MinActiveShips
                ,MaxActiveShips

                ,ActiveShips
                ,ReportStartDate

                ,ReportEndDate
                ,Rate

                ,CallCategoryId
                ,CallCategoryName

            )
(
    SELECT    cc.ID
            ,cc.StartDate as
ContractStart
            ,cc.EndDate as ContractEnd

,cc.IsChargeableOnly
            ,ccr.MinActiveShips

,ccr.MaxActiveShips
            ,criteria.ActiveShips

,criteria.StartDate as ReportStartDate
            ,criteria.EndDate as
ReportEndDate
            ,ccr.Rate
            ,ccat.ID

,ccat.CallCategoryName
    FROM CommissionContractRate ccr
    JOIN

(
        SELECT crd.ContractID
               ,crd.StartDate

        ,crd.EndDate
               ,SUM(CASE WHEN (cs.ServiceDate <=
crd.StartDate
                               AND (cs.ServiceEndDate IS NULL
OR cs.ServiceEndDate >= crd.EndDate)) THEN 1
                         ELSE
0
                    END) AS ActiveShips
        FROM
@ContractReportDates crd
        JOIN @ContractShips cs on cs.ContractId =
crd.ContractID
        GROUP BY crd.ContractID

,crd.StartDate
               ,crd.EndDate
    ) criteria ON
(criteria.ContractID = ccr.CommissionContractID
                    AND
(criteria.ActiveShips >=ccr.MinActiveShips or ccr.MinActiveShips IS
NULL)
                    AND (criteria.ActiveShips <= ccr.MaxActiveShips
or ccr.MaxActiveShips IS NULL)
                   )
    JOIN CallCategory
ccat on ccat.ID = ccr.CallCategoryID
    JOIN CommissionContract cc on cc.ID
= ccr.CommissionContractID
)

--SELECT * FROM
@ContractRates

/*
Create a composite list of all of the report dates
for each ship and the appropriate rates
*/
DECLARE @ContractShipRates
TABLE
(
    CruiseLineID int
    --,CruiseLine varchar(50)

,ShipID int
    ,Ship varchar(50)
    ,ContractID int

,ContractStartDate datetime
    ,ContractEndDate datetime

,ReportStartDate datetime
    ,ReportEndDate datetime

,ShipServiceDate datetime
    ,ShipServiceEndDate datetime

,IsChargeableOnly tinyint
    ,CallCategoryName varchar(5)
)
INSERT
INTO @ContractShipRates (
                        CruiseLineID

                     --,CruiseLine

,ShipID
                        ,Ship

     ,ContractID
                        ,ContractStartDate

                        ,ContractEndDate

,ReportStartDate
                        ,ReportEndDate

                 ,ShipServiceDate

,ShipServiceEndDate
                        ,IsChargeableOnly

                 ,CallCategoryName
)
(
SELECT

cs.cruiselineid
            --,dra.cruiseline

,cs.shipId
            ,cs.shipName
            ,cr.ContractID

     ,cr.ContractStart
            ,cr.ContractEnd

,cr.ReportStartDate
            ,cr.ReportEndDate

,cs.ServiceDate
            ,cs.ServiceEndDate

,cr.IsChargeableOnly
            ,cr.CallCategoryName
    FROM @UserShips
s
    JOIN @ContractShips cs on cs.ShipId = s.Id
    JOIN @ContractRates
cr on cr.ContractId = cs.ContractId
    WHERE cr.ReportEndDate >=
s.ServiceDate
        AND (s.ServiceEndDate IS Null OR cr.ReportStartDate
<= s.ServiceEndDate)
)

-- SELECT * FROM @ContractShipRates order
by cruiselineid, shipid,reportstartdate

/*
Get the usage and
revenue totals for each ship for each reporting period
*/
DECLARE @rawsums
TABLE
(
    CruiseLineID int
    ,CruiseLine varchar(50)

,ShipID int
    ,Ship varchar(50)
    ,ContractID int

,ContractStartDate datetime
    ,ContractEndDate datetime

,ReportStartDate datetime
    ,ReportEndDate datetime

,ShipServiceDate datetime
    ,ShipServiceEndDate datetime

,ChargeableMOU int
    ,SMSMO int
    ,DataMb float
    ,TotalRevenue
money
    ,VoiceRevenue money
    ,SmsRevenue money
    ,DataRevenue
money
)
INSERT INTO @rawsums (

CruiseLineID
                        ,CruiseLine

                     ,ShipID
                        ,Ship

                        ,ContractID

,ContractStartDate
                        ,ContractEndDate

                     ,ReportStartDate

,ReportEndDate
                        ,ShipServiceDate

                 ,ShipServiceEndDate

,ChargeableMOU
                        ,SMSMO

                     ,DataMb

,TotalRevenue
                        ,VoiceRevenue

                     ,SmsRevenue

,DataRevenue
)
(
SELECT
            dra.cruiselineid

     ,dra.cruiseline
            ,dra.shipId
            ,dra.ship

         ,csr.ContractID
            ,csr.ContractStartDate

,csr.ContractEndDate
            ,csr.ReportStartDate

,csr.ReportEndDate
            ,csr.ShipServiceDate

,csr.ShipServiceEndDate
    , (CASE WHEN
                SUM(CASE

                   WHEN dra.CallType ='Voice'   THEN dra.ChargeDuration

                   ELSE 0
                    END) IS NULL

THEN 0
            ELSE
                SUM(CASE

   WHEN dra.CallType ='Voice'    THEN dra.ChargeDuration

   ELSE 0
                    END) / 60
        END) AS
'ChargeableMOU'
        , SUM(CASE
                  WHEN dra.CallType
='SMS' AND dra.OriginationCode = 'MO'    THEN RecordCount

ELSE 0
              END) AS 'SMSMO'
        , SUM(CASE

WHEN dra.CallType ='Data' THEN

ISNULL(CONVERT(FLOAT,ChargeDuration)/(1024*1024),0)
            ELSE 0

       END) AS 'DataMb'
    , SUM(CASE
                  WHEN Charge
IS NOT NULL THEN Charge
                  ELSE 0
              END) AS
'TotalRevenue'
    , SUM(CASE
                  WHEN dra.CallType
='Voice' THEN Charge
                  ELSE 0
              END) AS
'VoiceRevenue'
    , SUM(CASE
                  WHEN dra.CallType ='SMS'
THEN Charge
                  ELSE 0
              END) AS
'SmsRevenue'
    , SUM(CASE
                  WHEN dra.CallType ='Data'
THEN Charge
                  ELSE 0
              END) AS
'DataRevenue'
    FROM rptDailyRevenueAggregates dra
    JOIN
@ContractShipRates csr on (
                                    csr.ShipID =
dra.ShipID
                                    AND dra.CallType =
csr.CallCategoryName
                                    AND dra.RevenueDate
<= csr.ReportEndDate
                                    AND
dra.RevenueDate >= csr.ReportStartDate

AND (csr.IsChargeableOnly = 0 OR dra.IsChargeable = csr.IsChargeableOnly)

                                 )
    WHERE dra.RevenueDate > =
@vStartDate
    AND dra.RevenueDate < dateadd(day,1,@vEndDate)

GROUP BY dra.cruiselineid
            ,dra.cruiseline

,dra.shipId
            ,dra.ship
            ,csr.ContractID

     ,csr.ContractStartDate
            ,csr.ReportStartDate

,csr.ReportEndDate
            ,csr.ContractEndDate

,csr.ShipServiceDate

,csr.ShipServiceEndDate
)

--SELECT * FROM
@rawsums

/*
Finally Calculate the revenue share for each of the
cruiseline, ship, contract date, report date combinations.
*/
SELECT
rawsums.CruiseLineID
            ,rawsums.CruiseLine

            ,rawsums.ShipID
            ,rawsums.Ship

            ,rawsums.ContractID

,rawsums.ContractStartDate
            ,rawsums.ContractEndDate

            ,rawsums.ReportStartDate

,rawsums.ReportEndDate
            ,rawsums.ChargeableMOU

            ,rawsums.SMSMO

,rawsums.DataMb
            ,rawsums.TotalRevenue

            ,rawsums.VoiceRevenue

,rawsums.SmsRevenue
            ,rawsums.DataRevenue

     ,crv.rate/100.0 as VoiceRate
            ,crs.Rate/100.0 as
SmsRate
            ,crd.Rate/100.0 as DataRate

,rawsums.VoiceRevenue * crv.rate/100.0 as VoiceCommission

,rawsums.SmsRevenue * crs.rate/100.0 as SmsCommission

,rawsums.DataRevenue * crd.rate/100.0 as DataCommission

,crv.MinActiveShips as VoiceMinShips
            ,crv.MaxActiveShips as
VoiceMaxShips
            ,crv.ActiveShips as VoiceActiveShips

,crs.MinActiveShips as SmsMinShips
            ,crs.MaxActiveShips as
SmsMaxShips
            ,crs.ActiveShips as SmsActiveShips

,crd.MinActiveShips as DataMinShips
            ,crd.MaxActiveShips as
DataMaxShips
            ,crd.ActiveShips as DataActiveShips
FROM @rawsums
rawsums
LEFT JOIN @ContractRates crv ON (crv.ContractId = rawsums.ContractId
AND crv.ReportStartDate = rawsums.ReportStartDate AND crv.ReportEndDate =
rawsums.ReportEndDate AND crv.CallCategoryName = 'Voice')
LEFT JOIN
@ContractRates crs ON (crs.ContractId = rawsums.ContractId AND
crs.ReportStartDate = rawsums.ReportStartDate AND crs.ReportEndDate =
rawsums.ReportEndDate AND crs.CallCategoryName = 'SMS')
LEFT JOIN
@ContractRates crd ON (crd.ContractId = rawsums.ContractId AND
crd.ReportStartDate = rawsums.ReportStartDate AND crd.ReportEndDate =
rawsums.ReportEndDate AND crd.CallCategoryName = 'Data')

END

Can anyone let me know what might be causing that error and for the report i am passing three input parameters..pMonth,pYear and pUserName.

Thanks in advance!!

Changed type Nicholas Li Monday, August 6, 2012 9:21 AM

Reply:

when i try to run using dataset in report builder i get

SQL Execution error .

Executed SQL Statement: xyz

Error Source: .Net sqlClient Data Provider

error Message: Procedure or functiob 'xyz' expects parameter 'pMonth' which was not supplied.

Why do i get this when i provide 'pMonth','pYear' and 'pUserName'

------------------------------------
Reply:

i tried to refresh and report designer gives:

could not generate a list of fields for the query.

check the query syntax or click refresh fields on the querry toolbar

------------------------------------
Reply:

Hi,

May I know if the issue occurs when authoring report for SCOM?

I just suspect this issue is about SSRS; for SQL Server related issue, it is recommended that you go to the corresponding forum for help:

SQL Server Forums
http://social.msdn.microsoft.com/Forums/en/category/sqlserver

Hope this helps.

Thanks.

Nicholas Li

TechNet Community Support

------------------------------------
Reply:

can anyone help??

i have the above stored procedure and write now this procedure gets all the ships details for a particular user but i want a particular user to get specific ship details based on username???

Thanks!!

------------------------------------

Disabling policy on NPS has no effect

When we disabled the only NPS policy with "grant" access, users can still connect via wireless. Log files shows new connections using this policy while disabled (!)

When we stop the NPS service users can no longer connect.

Why is does the disabled policy not reject connections?

Policy is used by Cisco WLC.

Thank you,

-Bob

Changed type Tiger LiMicrosoft employee Tuesday, July 24, 2012 2:10 AM

Reply:

Hi Bob,

Thanks for posting here.

The RADIUS clients (WLC) in this case should immediately reject the connection once no policy is match on RADIUS server when authenticate .

Network Policies

http://technet.microsoft.com/en-us/library/cc754107.aspx

We not sure why this happened if system does be configured as what you mentioned. but do we have other RADIUS server? And is this the one WLC is using now ? after we re enable the NPS service and keep the policy disabled, will get same issue again ?

Thanks.

Tiger Li

TechNet Community Support

------------------------------------
Reply:

I discovered the problem: What happened, from memory because it has been a few days, is the radio-button check box to override the dial-in property was not selected. Newbie error

------------------------------------

Search Problems on newly created list after installing a new license

I restarted OFFICE SHAREPOINT SERVER SEarch on SERVICES, Do a full Crawl and did an IISRESET. But still I cant find the words im searching.

What i did previously was I Convert the license of my Sharepoint to Office SharePoint Server with Enterprise Client Access License. Then when i did searching, Sharepoint cannot search the items inside my newly created list. Any ideas?

cal_bonjovi

Reply:

Have you checked your web application url available in the content source

It it is available then check the items are crawled from any scope ?

also tried after Index Reset and do full crawl.

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.

------------------------------------
Reply:

i checked the content source and the site is available in there.

I also checked the Scope and Rules are

All COntent - Include Behavior

Contentclass= urn:content-class:SPSPeople - behavior Exclude. So I guess there is nothing wrong in the scope.

How can i do Index Reset? Is it similar to IISRESET

cal_bonjovi

------------------------------------
Reply:

the item count are displayed as shown in 2nd screen shot ?

you can do the Index reset by from the left section as shown in both above images.

you can see the Index reset link in the left section.

iis reset and Index reset is totally different.

If you do the index reset then previous crawled data will no more longer available.

also can you please provide the screen shot from ur side as i gave previously to it will be help ful to indentify the issue.

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.

------------------------------------
Reply:

Im using SharePoint 2007. I dont have Index Reset.

cal_bonjovi

------------------------------------
Reply:

hello,

from your screen i can see the Successes after last crawl = 0,

and Error after last crawl = 53842.

so thats mean your content is not crawl properly.

can you please see the Crawl Log.

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.

------------------------------------
Reply:

I guess my error was that. Ill try to fix these errors then.. But if you have an advise for this, kindly share. Thanks so much.

cal_bonjovi

------------------------------------
Reply:

i think,

some security related issue is there.

can you please check the account for the serch service as suggested in below post

http://social.msdn.microsoft.com/Forums/hu/sharepoint2010general/thread/e3136c92-6f8a-49fe-8c40-52c04ba7e3e0

Hiren Patel | Please click "Propose As Answer" if this post solves your problem or "Vote As Helpful" if this post has been useful to you.

------------------------------------
Reply:

This seems not to work for me. It is already included in all my accounts the domain name.

cal_bonjovi

------------------------------------

how to set expression for sharepoint source adaptor in SSIS.

i am using SSIS Source/destination adaptor to import data from sharepoint 2007 but i want to set list name or KML query dynemically using SSIS expression. as of now i have not found any expression in this control so any idea guys?

Reply:

The trick might be to set this in the Control flow. If you highlight the data flow task in the control flow, in the properties of the Data Flow you may see properties for the Connection Manager that you can set via an expression at that level.

Cheers, James

James Beresford @ www.bimonkey.com
SSIS / MSBI Consultant in Sydney, Australia
SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

------------------------------------
Reply:

thanks James for your reply but i have not found expression for list name in share point connection manager, Could you please put some more details?.
But anyways i am using multiple sharepoint list in one DataFlow so i have to configure list name at DFT level.

thanks

Mukesh

------------------------------------
Reply:

Hi Mukesh & James,

I'm also facing the same issue, any pointer or reference in the same direction will be appreciated.

Thanks,

Manish Patil http://patilmanishrao.wordpress.com Posting is provided AS IS with no warranties, and confers no rights.

↑ Grab this Headline Animator

------------------------------------
Reply:

Which connection manager & source are you using? Are they out of the box or custom?

James Beresford @ www.bimonkey.com & @BI_Monkey
SSIS / MSBI Consultant in Sydney, Australia
SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex

------------------------------------
Reply:

i am using Connection Manager for sharepoint connection (SPCRED) version 1.0.0.0.

this is default connection manager provided by microsoft for sharepoint connectivity.

for source

i have used Sharpoint List source, which is downloaded from codeplex .

only problem is for List name and SiteURL configuration?

thanks

Mukesh

------------------------------------
Reply:

I am also facing same problem and we have hardcoded the configuration values.Every time when we are moving from Development to PROD or UAT environment we manually update the confiruations.

Samay

samay

------------------------------------

Force an attribute to the MV

Hi,

can you suggest me a method to save a value (calculated in the MV Extension dll) in a MV attribute from the code of this dll? Is there any example of this method?

I need to use this method to save a random initial password calculated in the MV Extension dll and then export them to the Portal for the user notification.

Thanks in advance.

Francesca

Reply:

Francesca-

You can't write to the metaverse from a metaverse extension. You'd need to do this on import from an MA, perhaps the HR one. You could look for a marker attribute to see if an AD account exists, adn if not, set the password attribute in the metaverse.

My Book - Active Directory, 4th Edition
My Blog - www.briandesmond.com

------------------------------------
Reply:

I can only think of two ways to get data from your MV extension into an attribute export. One is to capture it in a Utils.TransactionProperty, and use a rule extension for the export to flow it out. Unfortunately you can't use rule extensions with the FIM MA directly, and the fact that there's a value in memory wouldn't trigger a given EAF rule to be evaluated on a delta sync on its own...it requires a lot of thought about the sequence of events and what import attribute flows trigger other export flows and generating the U.TP in the middle.

If you created a new connector (say to an MA for a SQL table just for this purpose) in your provisioning code, you could set the value of the password in an attribute before committing the new connector, export it to your SQL table, import it into the metaverse attribute of your choosing and then flow it out to the portal. Theoretically you could write the password to a file and then import that with a file MA, but I wouldn't do it that way if I had any other option.

It seems like it would be more straightforward to do the provisioning from the portal and generate the password in a custom workflow activity. However, if you're like me you're just not up for writing that kind of code (yet). It is a major shift if you've already got everything else working with a classic design.

Chris

(Follow-up note: As the second can of caffeine takes its effect this morning and I begin to understand what I read, Brian's solution is much simpler with fewer steps.)

Edited by Chris Clayton - STLCC Tuesday, July 24, 2012 2:18 PM

------------------------------------

How to prevent a delegated Windows 2003 Active Directory account from seeing some OUs in a single domain Active Directory Forest

Hello all,
I have a scenario here:
I have a single active directory forest organization with multiple OUs (about 30 OUs). I delegated an administrator for the administration of
one of the OUs (with Read/Write permissions).
As it is now, the delegated account can only see objects in the other OUs (the reamining 29 OUs) but can not modify/alter the attributes of such objects.
What I really want to achieve is a scenario whereby the delegated account will only be able to see objects in the OU to which the account
has been delegated for administration only and not others.

Please how can I achieve this?

Waiting anxiously for your professional advices and lead.

Changed type Andy Qi Wednesday, July 25, 2012 1:42 AM
Changed type Andy Qi Wednesday, July 25, 2012 1:44 AM
Changed type Andy Qi Wednesday, July 25, 2012 2:42 AM

Reply:

Hi,

By default, all users have the READ permissions to view all Active Directory objects in a domain. You need to configure Security ACLs on OUs to deny/allow users to view only specific Active Directory objects they need to see.

However, please be informed that, it's not recommended to change the security ACLs on OU until and unless you know what you are doing ! A slight mistake in changing ACLs might cause unforeseen issues.

Before doing anything on prod domain, test the approach in a lab setup.

Following article might help in your case.

Hide objects in Active Directory from specific users

http://certcollection.org/forum/topic/52853-hide-objects-in-active-directory-from-specific-users/

HTH

I do not represent the organisation I work for, all the opinions expressed here are my own.

This posting is provided "AS IS" with no warranties or guarantees and confers no rights.

- .... .- -. -.- ... --..-- ... .- -. - --- ... ....

------------------------------------
Reply:

Hello,

agree with Santosh Bhandarkar here. Do NOT mess around with security inside AD UC, if done wrong you may kick out yourself from the domain. And if you still will do it built a lab and TEST everything

Best regards

Meinolf Weber
MVP, MCP, MCTS
Microsoft MVP - Directory Services
My Blog: http://msmvps.com/blogs/mweber/

Disclaimer: This posting is provided AS IS with no warranties or guarantees and confers no rights.

------------------------------------
Reply:

Thanks a lot guys...i really appreciate your contributions.

------------------------------------

Minimum permission to administration of Microsoft forefront TMG Console ???

I have installed Micrsoft forefront TMG 2010 in my company.

I'm administrator.and I want to grant TMG administration to another one but I dont know how can I do that?

by the way I want to grant some permission to 4 persons to read only access to configuration of TMG.

Reply:

Hi,

Remote Management concepts:
http://technet.microsoft.com/en-us/library/bb794770.aspx
Role based Administration:
http://technet.microsoft.com/en-us/library/dd897006.aspx

regards Marc Grote aka Jens Baier - www.it-training-grote.de - www.forefront-tmg.de - www.nt-faq.de

------------------------------------

Data Mining of Groups

Dear All,

I have asked this question in another DM forum but nobody could help me so I hope somebody can help me here and give me a hint where to look for further information.

I want to Data Mine groups, like the following example.

I have some groups with two or more person. These Persons have attributes like Age or different Skills.

Group 1
Person A, Age, Skill-1-A, Skill-2-A, Skill-3-A
Person B, Age, Skill-1-B, Skill-2-B, Skill-3-B
Person C, Age, Skill-1-C, Skill-2-C, Skill-3-C

Group 2
Person D, Age, Skill-1-D, Skill-2-D, Skill-3-D
Person E, Age, Skill-1-E, Skill-2-E, Skill-3-E

Group3
..

In the past the different groups could have been ranked according to their performance.

For example Group 3 was 1st, Group 2 2nd, Group1 3rd (More rankings available)

Every time the Person in the groups have changed. Now I want to predict how a new group performs in future.

At the moment I have no clou what concept to use. The only thing that comes in mind is to aggregate the persons
into "group measures" for example

Group1, MeasureSkill1, MeasureSkill2, MeasureSkill3 --> 3rd
Group2, MeasureSkill1, MeasureSkill2, MeasureSkill3 --> 2nd
Group3, MeasureSkill1, MeasureSkill2, MeasureSkill3 --> 1st

Is it possible to handle this problem in another way?

Thanks

Reply:

Since there has nobody posted anything yet.

I would be thankful for just an hint to look for further information for example any term/method which i can type in in a search engine. I am not looking for a complete solution.

best regards

Edited by kane2k4 Tuesday, July 24, 2012 10:12 AM

------------------------------------

How long do you keep database backups for?

In my last places it was 14 days with full backup once a week and daily differentials - this new company I'm at takes a full backup every day - no backups retained!

What's the policy where you all work?

Jonj

Reply:

depends on job needs.

I recommned you to keep a backup last month and also if possible last 6 months ( never know when a user need it )

A short but clear doc about this

http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp?topic=/com.ibm.aix.baseadmn/doc/baseadmndita/backpol.htm

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

------------------------------------

LOGITECH WEBCAM

I installed logitech webcam C110 on windows 7 machine. everything seems right but i can not run it to capture pictureS just as i did in WINDOWS XP Machine.

Reply:

Hi,

Please ensure that the application came with the webcam is compatible with Windows 7. You may go to Logitech website to double check it.

http://www.logitech.com/

Please Note: Microsoft provides third-party information to help you find technical support. This information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information

Kim Zhou

TechNet Community Support

------------------------------------

RBS on sharepoint 2010 with SQL Server enterprise edition R2

Dears,

we need your assistance while impelemting RBS using Sharepoint 2010 and SQL server enterprise eidtion R2

Does FileStream provider for sql server allows to store BLOB data on any local hard drive using SQL server 2008 R2 Enterprise Edition not on any network connected drive or san storage? without any third party provider?

Can we use mirroring/Clustering while using RBS?

does RBS support sql native backups?

In case of RBS when we are taking backup so it will take backup of blobs as well so it will take same time so only benefit is to exculde it from sql db backup

Blobs should be moved to faster hard drive what are the recommendations?

regards

Shahid Siddique

Reply:

Hi,

Thanks for your post.

However, I am not an expert about SharePoint server. Hope the following article helps.

Plan for RBS (SharePoint Foundation 2010)

http://technet.microsoft.com/en-us/library/ff628569.aspx

For best resource, I would recommend that you post this issue at SharePoint forum. You can get more effective suggestion by other experts who familiar with this topic.

SharePoint Forum

http://social.msdn.microsoft.com/forums/en-US/category/sharepoint/

Best Regards,

Aiden

Aiden Cao

TechNet Community Support

------------------------------------
Reply:

Thanks for your help Aiden, We have configured the RBS on local disk

we have following queries

(1)We want to use Remote Blob Storage ,currently we are considering file stream provider for sql server 2008 R2 while implementing ecm solution using SharePoint 2010

(2)We want to know can we use RBS with file stream on SAN storage?

(3)As we are using Symantec NetBackup can we take backup and restore while using RBS on SAN?

(4)Do we require third party tool for storing blob remotely or for backup and recovery ?

Regards

Shahid siddique

MCTS,ITIL

------------------------------------

RBS on sharepoint 2010 using SQL Server 2008 R2 Enterprise eidtion

Dears,

we need your assistance while impelemting RBS using Sharepoint 2010 and SQL server enterprise eidtion R2

Does FileStream provider for sql server allows to store BLOB data on any local hard drive using SQL server ENTERPRISE EDITION 2008 R2 not on any network connected drive or san storage? without any third party provider?

Can we use mirroring/Clustering while using RBS?

does RBS support sql native backups?

In case of RBS when we are taking backup so it will take backup of blobs as well so it will take same time so only benefit is to exculde it from sql db backup

Blobs should be moved to faster hard drive what are the recommendations?

regards

Shahid Siddique

MCTS,ITIL

Edited by Shahid Siddique Saturday, July 14, 2012 7:49 AM

Reply:

Hi,

Does FileStream provider for sql server allows to store BLOB data on any local hard drive using SQL server ENTERPRISE EDITION 2008 R2 not on any network connected drive or san storage? without any third party provider?

read this post

http://blogs.msdn.com/b/opal/archive/2010/03/24/faq-sharepoint-2010-remote-blob-storage-rbs.aspx

Can we use mirroring/Clustering while using RBS?

You can use RBS with SQL Server Cluster but not with Mirroring because it does not support filestream

http://msdn.microsoft.com/en-us/library/bb895334.aspx#DatabaseMirroring

does RBS support sql native backups?

Yes

read this post

http://blogs.msdn.com/b/opal/archive/2010/03/24/faq-sharepoint-2010-remote-blob-storage-rbs.aspx

Blobs should be moved to faster hard drive what are the recommendations?

check these posts

http://blog.bugrapostaci.com/2010/10/01/sharepoint-2010-server-with-filestream-rbs-provider/

http://sharepointintheprivatecloud.wordpress.com/2010/12/23/sharepoint-2010-rbs-on-emc-storage/

Note: here steps to follow to configure RBS for SharePoint 2010

http://www.knowledgecue.com/pdf/ConfiguringRemoteBlobStorageforSharePointKnowledgeCue.pdf

Regards,
Fadi Abdulwahab, SharePoint Consultant
http://blogs.msdn.com/b/fabdulwahab
http://sqlgoogler.blogspot.com/

Edited by Fadi Abdulwahab Saturday, July 14, 2012 8:27 AM

------------------------------------
Reply:

"Blobs should be moved to faster hard drive what are the recommendations?"

No, this isn't necessarily the case. In fact, this can impact one of the key reasons for implementing Remote Blob Storage in the first place - using cheaper disk storage to store documents that are not being used.

Typically SQL Server disk storage is expensive because you want the best I/O from your disk system. When implementing Remote Blob Storage you can decide what sort of storage you want to use (Local disk, direct attached, NAS, NTFS, Cloud, etc) and more importantly you can move content to "cheaper" disk systems as content ages on your SharePoint site.

For example, if you have 5 years worth of data, it is common to split the data up into <30 days old, 31-90 days old, and 90+ days old. You can therefore purchase high-performance storage for your <30 days old (smallest number of disks), medium performance storage for your 31-90 days old, and high-capacity storage for your 90+ days old documents. The idea being that as content is accessed less and less, it can be moved to cheaper disk storage for long-term retention. You save money on your storage purchase by buying more bigger, cheaper disks and less small, fast disks.

Return On Investment can then be calculated by the total cost of storage for your SQL Server database *without* Remote Blob Storage, against the cost of some high-performance, some medium-performance, and majority high-capacity storage.

There are a number of 3rd-party Remote Blob Storage (RBS) providers for SharePoint 2010, most of which provide this functionality (and more):

Stepwise (Invizion)

Storage Maximiser(Quest)

Microsoft Filestream Sample (Microsoft)

StoragePoint(Metalogix)

Avepoint (DocAve)

Gavin McKay Invizion Pty Limited Makers of Stepwise, Remote Blob Storage for SharePoint w: www.invizion.com.au

Edited by Gavin McKay - Public Profile Monday, July 16, 2012 9:24 AM

------------------------------------
Reply:

Thanks for your help fadi and gavin, We have configured the RBS on local disk

we have following queries

(1)We want to use Remote Blob Storage ,currently we are considering file stream provider for sql server 2008 R2 while implementing ecm solution using SharePoint 2010

(2)We want to know can we use RBS with file stream on SAN storage?

(3)As we are using Symantec NetBackup can we take backup and restore while using RBS on SAN?

(4)Do we require third party tool for storing blob remotely or for backup and recovery ?

Regards

MCTS,ITIL

------------------------------------

Question - Mapping a drive hosted in other domain

Hi,

I have an issue I'd like some directions on how to achieve this.

In my domain I have a GPO that automatically maps some network shares to some users. This shares are in my domain, so everything is ok.

A few months ago we've setup an environment where the domain users have to map drives to network shares hosted on other domains. The same script in this case doesn't work, because it has no authentication options. There is no trust between the two domains.

I can't give the option to the users to save their password, since on the other domain I have no management whatsoever and their account every now and then gets locked.

So, I need to know if there is any way that I can use a mapping mechanism that, whenever a user logs, the drives are automatically mapped. Even if I have a popup window asking me for authentication. I assume the need for authentication in this process.

One other information, the path to the shared folder, is on a user basis:

\\servername\username1$

\\servername\username2$

\\servername\username9999$

Any ideas?

Thanks,

Nuno Silva

Edited by Nuno Pedro Silva Monday, July 16, 2012 9:43 AM
Changed type Niki Han Tuesday, July 24, 2012 6:37 AM

Reply:

For automatic login

net use * \\server\share user_password /user:remote_domain\user_name

Credentials in remote domain: user_password & user_name

* means the first free letter, unless you want to specify fixed one

Regards

Milos

------------------------------------
Reply:

Hi Milos,

Yes, that would be a possible solution, but I'd prefer something that asks me for authentication.

Maybe I can only achieve this if I develop a tool to do this. This way it asks me for the domain, user and password, and does the mapping itself.

Thanks,

Nuno Silva

------------------------------------
Reply:

Hi,

I suggest you post in server forum to get more insights.

http://social.technet.microsoft.com/Forums/en-US/winserverNAP/threads

Niki Han

TechNet Community Support

------------------------------------
Reply:

Hi,

This is solved for me now... I ended up by developing a tool that maps the network shares that the user wants to choose from a list.

This way, they only have to authenticate once. For me is enough, since there can be no Domain trust to overcome this...

Thanks,

Nuno Silva

------------------------------------

PC running Windows 8 RP intermittently hangs when running VMs using Hyper-V?

Hi!

I have laptop with 8GB RAM running Windows 8 RP Hyper-V. My problem is sometimes it just suddenly hangs. It is weird because sometimes I'm able to run 5-6 VMs simultaenously (around 512 - 1024MB RAM each) and other times I'm just running 3 then when I do something, my computer just stops responding then eventually hangs.

Previously I was using Dynamic Memory but now I just set to static memory, however the problem still appears.

Any tweak or suggestion I could do so that I can prevent it from happening? I always remember to allocate sufficient RAM so I don't think it is an issue of overloading?

Thanks!

Changed type Nicholas LiModerator Thursday, August 9, 2012 8:50 AM

Reply:

See if your hard disk is suddenly active when this happens.

I have noticed that there are background tasks that all of a sudden generate a bunch of disk activity and that would cause the symptom you describe.

Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.
Disclaimer: Attempting change is of your own free will.

------------------------------------
Reply:

Are you running all the VMs on the same hard drive? Is it an SSD, 5400rpm, 7200rpm, etc? 5-6 VMs is a lot for one spindle to manage. As Brian suggested, I'd suspect hard drive contention.

------------------------------------
Reply:

Hi,

Did you have antivirus software installed on Hyper-V host machine? Please check the following blog.

Antivirus and Hyper-V (or: Why can't I start my virtual machine?)
http://blogs.msdn.com/virtual_pc_guy/archive/2009/03/17/antivirus-and-hyper-v-or-why-can-t-i-start-my-virtual-machine.aspx

------------------------------------

Ms Support forum

Friday, February 25, 2022