Need users list who are refreshing cube data using Ad-hoc reports
Hi,
Hope all are doing well,
I got a requirement from my client that, they need users list who are refreshing cube data through ad-hoc reports(Power pivot).
In detail,Every users had assigned a role in cube to access appropriate data through ad-hoc reports by connecting to the SSAS source.Every day they used to refresh the data to full fill their bussiness needs.
What I need is to trace out who(Users) are refreshing reports which is already connected to SSAS Cube source.
Regards,
Ram.
- Changed type Ed Price - MSFTMicrosoft employee Saturday, June 6, 2015 3:26 AM No response
Reply:
Thanks!
Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Use PowerPivot Calcuation for the attached worksheet
Hi All,
I have the worksheet below and wanted to know how I can automate the calculation for the fields below using powerpivot
If you click on cells Fund Allocated by Program and Balance Fund you will see the formula used for the calculation.
Really appreciate if this puzzle can be solved.
| | |
https://app.box.com/s/jd6e1p1o0rcxb12yoqqh9fp53tg02v7b
Thanks
- Edited by jaggy99 Wednesday, April 1, 2015 9:33 AM
- Moved by Fei XueMicrosoft employee Thursday, April 2, 2015 3:23 AM
- Changed type Ed Price - MSFTMicrosoft employee Saturday, June 6, 2015 3:26 AM No response
Reply:
Hi jaggy99,
Thanks for posting in MSDN forum.
This forum is for developers discussing developing issue involve Excel applicaiton like Excel customization, automation.
Since the issue is more relative to PowerPivot, I would like to move it to Powerviot forum.
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.
Thanks for your understanding.
Regards & Fei
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
------------------------------------
Reply:
Jaggy, is this related to your other question?
Thanks!
Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Use PowerPivot Calcuation for the attached worksheet
Hi All,
I have the worksheet below and wanted to know how I can automate the calculation for the fields below using powerpivot
If you click on cells Fund Allocated by Program and Balance Fund you will see the formula used for the calculation.
Really appreciate if this puzzle can be solved.
| | |
https://app.box.com/s/jd6e1p1o0rcxb12yoqqh9fp53tg02v7b
Thanks
- Edited by jaggy99 Wednesday, April 1, 2015 9:32 AM
- Changed type Ed Price - MSFTMicrosoft employee Saturday, June 6, 2015 3:25 AM No response
Reply:
Jaggy, can you pull out some of the info and the problem into this thread more?
Thanks!
Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!
------------------------------------
Forum FAQ: Cannot logon Windows XP Mode after changing password of the user account in Windows XP mode system
Symptom
After changing password of the user account (xpmuser) in Windows XP Mode system, you may encounter a problem that you can no longer automatically log on Windows XP Mode. Instead, you may see the following error message:
"The system could not log you on. Make sure your User name and domain are correct, then type your password again."
Cause
By default, Windows Virtual PC saved the credential last time you started Windows XP Mode system successfully. Therefore, if you change password for Windows XP Mode user account xpmuser, the automatical logon process will fail with the previously saved credentials.
Resolution
To resolve this issue, perform the following steps:
1. On Windows XP Mode screen, click Tools, choose Settings.
2. Find and highlight Logon Credentials in the left panel, click the Delete saved credentials button on the right side. Click OK.
The next time you start Windows XP Mode, it will ask for a new credential. Type the correct user name and password, check the box Remember my credentials and click OK. The new credentials will be saved. As a result, it will automatically log in Windows XP Mode next time.
Applies to
· Windows 7 Ultimate
· Windows 7 Enterprise
· Windows 7 Professional
Reply:
1) Disable Integration Features (in the XP Mode window, choose Tools | Disable Integration Features).
2) Reboot the XP Mode, and go into the boot menu (press F8 repeatedly while it's booting).
3) In the boot menu, choose Safe Mode.
4) Log in as "Administrator" with no password (unless you had previously changed the Administrator password, in which case use the password you set for it).
(When I first clicked the OK button to login, I got a message about the virtual window taking control of the mouse. Then I had to click the OK button again.)
5) Go into the User Accounts Control Panel (Start | Control Panel | User Accounts.
6) Change the XPMUser account to have a password.
(The page I referenced above also had a step to go into an Advanced tab and set the password to never I expire. I didn't see that Advanced tab.)
7) Reboot the XP Mode window into normal mode, and log into XPMUser with the password you just set.
8) Enable Integration Features (in the XP Mode window, choose Tools | Enable Integration Features).
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
FIX TO: The attempt to connect to the report server failed. Check your connection information...
If you get the error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
If you then scan the recent logfiles in C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and find the following exception: Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: .
it means that you have configured the /reportserver/ app to not be reachable via http://localhost/... - there are two options from here:
1) add the localhost hostheader to the web-site which hosts the /reportserver/ and make sure the app is then reachable via that path
2) edit the file C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\RSWebApplication.config and add the full url to the ReportServer into the ReportServerUrl tag (no ending / nessesary) AND remove the value from ReportServerVirtualDirectory (otherwise you get nasty, unprecise exceptions). THEN you must recycle the app-pool used by the Report-Manager so that config file is being reloaded.
Reply:
THANK YOU VERY MUCH FOR YOUR HELP.
------------------------------------
Reply:
Thank You for the FIX TO: message - just what I needed to implement Reporting services on a secondary web site (with different host header)
Added the complete url and removed the entry from the ReportServerVirtualDirectory and everything worked - glad I found this - wish I would have found it before I reinstalled RS 2005 a couple times..
thanks tilfried for your contribution
John F
------------------------------------
Reply:
Glad I could help :)
When one messes around a couple of hours trying to fix a problem, I think it's worth the extra 5 mins to post the solution!
------------------------------------
Reply:
------------------------------------
Reply:
Hello all,
Could some one please explain the security piece of reporting services? What type of IDs do I need, do I need to use SPN accounts if yes how and where would I put/specify this SPN account. Basically I am trying to understand how to setup security when I install reporting services.
Thanks
MA
------------------------------------
Reply:
------------------------------------
Reply:
Tilfried:
Thank you! Thank you! If you are ever in southwest Florida, look me up, and I'll buy you a beer! I mean it. And there aren't many Vangors in the phone book down here, so I'll be easy to find. Or google me.
This was the final piece of the puzzle that I needed to get SSRS 2005 working on my Win2K Server with SQL Server 2000.
In my case, I made the following changes to the RSWebApplication.config file:
From: <ReportServerUrl></ReportServerUrl>
To: <ReportServerUrl>http://www.mydomain.com/ReportServer</ReportServerUrl>
From: <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
To: <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
Thanks, again!
Van
------------------------------------
Reply:
It was very helpful. Thanks//
------------------------------------
Reply:
Thanks Tilli.
Thanks a Ton, it worked for us.
------------------------------------
Reply:
i followed your instruction but its still not connecting!
any idea?
------------------------------------
Reply:
if you want help, you should post the exact error-message from the logfile. Superman's on vacation
------------------------------------
Reply:
Same error: "The attempt to connect..."
Config file:
My Reporting Services Config is up and running with no error, just cant seem to actually log into Report Manager to config the rest.
Suggestions??
Thanks!
Robert
<Configuration>
<UI>
<ReportServerUrl>http://rlewis-lt:82/ReportDev</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
------------------------------------
Reply:
Okay, so here's where I stand. I've got Vista Business laptop. I've got Visual Studio 2008, SQL Server Dev Edit 2005 SP2, IIS 7.0 on this box. I've got Reporting Services running, everything looks great in Configuration Manager. However, I cannot hit Report Manager to save my butt. The log for reporting services is in blue. The Config file is in red.
Please shed some light on where I've got this botched. I'd really appreciate it.
Regards,
Robert
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerWebApp__05_21_2008_07_38_19.log</Path>
<SystemName>RLEWIS-VCL</SystemName>
<OSName>Microsoft Windows NT 6.0.6000.0</OSName>
<OSVersion>6.0.6000.0</OSVersion>
</Header>
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!5/21/2008-07:38:19:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!5/21/2008-07:38:25:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
w3wp!ui!5!5/21/2008-07:38:25:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Not Found.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!5/21/2008-07:38:29:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
<
Configuration><
UI><
ReportServerUrl>http://rlewis-vcl:82/reportserver</ReportServerUrl><
ReportServerVirtualDirectory></ReportServerVirtualDirectory><
ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel></
UI><
Extensions><
DeliveryUI><
Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"><
DefaultDeliveryExtension>True</DefaultDeliveryExtension><
Configuration><
RSEmailDPConfiguration><
DefaultRenderingExtension>MHTML</DefaultRenderingExtension></
RSEmailDPConfiguration></
Configuration></
Extension><
Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/></
DeliveryUI></
Extensions><
Add Key="MaxActiveReqForOneUser" Value="20"/><
Add Key="DisplayErrorLink" Value="true"/></
Configuration>------------------------------------
Reply:
In your confg file try to remove the "http://" and the port number ":82" and just leave the Alias name and see if that resolves the issue
e.g:
"<Configuration>
<UI>
<ReportServerUrl>rlewis-vcl</ReportServerUrl>"
Once you save this try accessing your RS via the following URLs:
http://rlewis-vcl:82/reportserver
Hope this helps
------------------------------------
Reply:
Just to say thanks - after waiting for the it team to resolve security problems - I did a bit of digging and found this easy fix.
------------------------------------
Reply:
------------------------------------
Reply:
how you do this
1) add the localhost hostheader to the web-site which hosts the /reportserver/ and make sure the app is then reachable via that path
------------------------------------
Reply:
I tried option one and got nowhere. I tried adding "localhost" as the hostheader in the webserver....but maybe I did it wrong. I think I just put "localhost" in the window (advanced) with the IP address.
Amazingly, option two worked for me. Important to REMOVE the virtual directory and append it to the URL in the URL tag. here's what I did:
<ReportServerUrl>http://sql01.joho.com/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
fingers crossed that my install of CRM is finally going to work...!
------------------------------------
Reply:
When I browse to http://localhost/reportserver I get the following error:
------------------------------------
Reply:
David this should be easy to fix, please follow the following steps and provide the requested information so I can further assist you: (Assuming you are running SSRS on Windows Server 2003 with IIS 6.0)
- Start -> Administrative Tools -> Internet Information Services (IIS) Manager
- Under IIS -> Click on the "+" next to the (local Computer) name
- You should now see three folders (Application Pools, Web Sites, and Web Service Extensions)
- Click on the "Web Service Extensions" folder -> and on the right pane verify what web service extensions are allowed?
Please replay with your findings so I can further help you with this issue.
MA
------------------------------------
Reply:
I ended up getting it working doing the following:
Migrated the app using -
%systemroot%\system32\inetsrv\APPCMD.EXE migrate config "Default Web Site/ReportServer"
Also turned out the isapi handler mapping was pointing to the 64bit version and needed to point to the 32bit version ...
FYI I'm using Vista 64bit.
cheers
David
------------------------------------
Reply:
I am trying to follow the example
http://www.dotnetheaven.com/UploadFile/ursbgiri/106012007065515AM/1.aspx
and when I am trying to deploy
I got this Error Message:
A connection could not be made to the report server http://samsamaster:8080/Reports.
Additional Information:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
SOLUTION:
I did and follow the steps you told me but unfortunately It did work.
I made changes the RSWebApplication.config
<ReportServerUrl>http://samsamaster:8080/Reports</ReportServerUrl>
and
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
and recycle the Application Pool named "ReportServer"
the above said url is the url of Report Manager.
and my web server worked with port 8080 as on port I got SharePoint.
I am stuck.
Please any help is highly appreciated.
Regards
S R
------------------------------------
Reply:
I am getting this same Error
- The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
- The request failed with HTTP status 404: Not Found.
I have tried to change RSWebApplication.config - <ReportServerUrl>http://localhost/ReportServer$SQLExpress</ReportServerUrl>
- ReportServerVirtualDirectory></ReportServerVirtualDirectory>
- But Still it is not working. Please help me to solve this one.
Regards,
chitra. - The request failed with HTTP status 404: Not Found.
------------------------------------
Reply:
I have Sql server Express 2005. As per your Note What should be value in ReportServerUrl tag
Which I need to use :
<ReportServerUrl>http://localhost/Reports$Sqlexpress</ReportServerUrl>
<ReportServerUrl>http://localhost/ReportServer$Sqlexpress</ReportServerUrl>
<ReportServerUrl>http://localhost/Reports</ReportServerUrl>
Right now, I tired all but nothing works. I get same error.
Also I don't know what is REPORT PATH VALUE in report viewer control ? Like I created Reports Using SSRS 2005 and Published On Website,
I can go on SSRS wevservice home page and run report like REPORT PROJECT1 / REPORT1
But where are these stored and What is Report Path Value ?
Also What should be value of Report Server URL In Report Viewer Control.
Is it full path : http://localhost/Reports$Sqlexpress ?
Please Help.
Ami
ami_sur@yahoo.com
------------------------------------
Reply:
Error
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
Home
Although saving the databse connection successded, the rport server cannot access the internal information abolut the deployment to determine whether the current configuration is valid for this edition. if you are ... bla bla bla...
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
Shift the Ctrl in our hands and we will Alt the world.
------------------------------------
Reply:
------------------------------------
Reply:
I can easy access my reports from the IE (by ReportManager). My ReportViewer Controls are configured properly (serwer and virtual directory settings).
- hostheaders added
- rsreportserver.config checked
- non of solutions above helped me.
everything seems to be ok but it' still not working...
frustrating,
lost over 3 days to find solution :(
plz somebody help
------------------------------------
Reply:
it was so easy... to easy in my case.
In the ReportViewer Control i typed wrong adress in the "ReportServerUrl" property
it was:
http://localhost/Reports_Sqlexpress
and i changed it to:
http://localhost/ReportServer_SqlExpress
-it works now!
also remember to type "/" before reports catalog in "ReportPath" property of ReportViewer Control
if You are not shure what is your ReportServerUrl go to "Reporting Services Configuration Manager" (menu start>sql server>configuration tools), select "Web Service URL" from the left menu and at the bottom You will find "Report Server Web Service Url's" - this is your ReportServerUrl value.
------------------------------------
Reply:
so give it a shot .. you never know it that works out in your case.. i am still battling i really need some one give me step by step of configuring reporting service in such odd scenario.. where os is x64 and ms sql is x86...
thanks..
Shift the Ctrl in our hands and we will Alt the world.
------------------------------------
Reply:
I have everything working in RS Configuration (Green Check Marks).
Custom tweak is a second IIS Site to handle the custom port configuration for network traffic. The default Virtual Directory is still there, unaltered. It was working, starting displaying errors, worked again yesterday, then quit again. Error is:
| ERROR |
| The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. HOME |
My RSWebApplication.config file has the following, which is the URL path to the IIS site for my Report Mangager.
<ReportServerUrl>http://192.168.2.2:8080</ReportServerUrl> <ReportServerVirtualDirectory></ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
I Changed to this and it was fixed:
<ReportServerUrl>http://192.168.2.2/ReportServer</ReportServerUrl> <ReportServerVirtualDirectory></ReportServerVirtualDirectory> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
Thanks.
have another Dr. Pepper
- Edited by Drew Coppock Tuesday, December 8, 2009 3:37 PM Found my problem
------------------------------------
Reply:
Hi - this worked like a charm, thanks very much.
------------------------------------
Reply:
You also have to be sure that you are using the right parameters:
This works fine for me, different web server than the report server.
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://yourServer/yourReportServer"); //Remember not use slash at the end
ReportViewer1.ServerReport.ReportPath = "/FaxReport"; //use the slash before the name of your report
Regards,
oskarcharles
------------------------------------
Reply:
After configuring this getting the fallowing message. Can anyone tell me why this is happening.
Under Construction
The site you are trying to view does not currently have a default page. It may be in the process of being upgraded and configured.
Please try this site again later. If you still experience the problem, try contacting the Web site administrator.
------------------------------------
Reply:
This is a serious problem and bug to go through this. I have just tried 3 hours worth of modifications to this install: Windows 2008 64 bit, SQL 2005 with SP3 and I am still get this error. Thanks for the first post though. It was good start to troubleshooting, but it doesnt fix my problem.
If anybody has any suggestions to fix this issue: "The attempt to connect to report server failed..."; please let me know.
Thanks,
RM
------------------------------------
Reply:
As most of us techie do, I finally had to reinstall everything and do some work under the hood (registry changes). I believe that IIS 7 had become corrupt so I ended up cleaning the SSRS installs, the registry, and uninstalling the IIS 7 role in Windows 2008 64 bit. Even when I reinstalled the role, I still had to delete old virtual websites and directories. BE SURE TO CLEAN EVERYTHING ABOUT THE SSRS.
Here's the link I used that helped.
http://support.microsoft.com/kb/938245
Share the knowledge... so the bleeding can stop!
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
Hey
Thanks a ton. struck there for the past 2 days.
------------------------------------
Reply:
If you have VPN, please use that VPN IP to access the report sever remotely. It should work...
------------------------------------
Reply:
------------------------------------
Reply:
I just set ReportServerUrl to TargetServerUrl of my SSRS, and its working fine..!
Example:
<rsweb:ReportViewer ID="ReportViewer1" ProcessingMode="Remote" runat="server" Width="600px"><ServerReport ReportPath="/Demo/Deparment" ReportServerUrl="http://ashish-pc/ReportServer_MSSQLSERVER2008" />
</rsweb:ReportViewer>
------------------------------------
Reply:
Maybe the answer is here:
http://dyslexicanaboko.blogspot.ro/2012/11/the-attempt-to-connect-to-report-server.html
1.Use the "Web service URL" virtual directory but not the "Report Manager URL" infos in Report Service configuration manager
2. Do not add the .rdl extension on the end of the link(report path)
------------------------------------
licensing part
Hi,
i want to know how many vm can i creat in window server 2012 std and 2012 dce
Thanks
Np
Reply:
Hi,
have a look here
Short version is 2 VMs on standard and unlimited on dce
This post is provided AS IS with no warranties or guarantees, and confers no rights.
~~~
Questo post non fornisce garanzie e non conferisce diritti
- Edited by aperelli Thursday, April 30, 2015 2:42 PM
------------------------------------
Reply:
. : | : . : | : . tim
------------------------------------
Couldn't update to Windows 10 Technical Preview
Hello!
I have tried to update to build 10041 several times, but I get the message:
Sorry, we couldn't complete the update to Windows Technical Preview. We've restored your previous version of Windows to this PC.
0xC1900101 - 0x30018.
I tried to extend C free space and to delete C:/$Windows.BT.
Here is my setuperr file.
2015-04-15 14:33:56, Error DU DU::CDUSession::Initialize: Failed to begin IUpgradeInternalSession. hr = 0x80004002[gle=0x000003f0]
2015-04-15 14:34:00, Error CDiagnosticsHelper::SetSQMDatapoint: Attempting to set a datapoint in an invalid SQM session
2015-04-15 14:34:55, Error DU DU::CDUSession::Initialize: Failed to begin IUpgradeInternalSession. hr = 0x80004002[gle=0x000003f0]
2015-04-15 14:35:31, Error SP pDUSearch: DUSearch failed. hr = 0x80070057
2015-04-15 14:35:31, Error SP CDownloadDUUpdates::DoExecuteInternal: Failed to search for updates. hr = 0x80070057
2015-04-15 14:35:31, Error SP CSetupPlatform::DownloadDynamicUpdates: Failed to download updates. Error: 0x80070057[gle=0x00000012]
2015-04-15 14:35:31, Error MOUPG DUImage: Failed to execute DUImage FOD search and download [0x80070057][gle=0x00000012]
2015-04-15 14:35:42, Error SP pDUSearch: DUSearch failed. hr = 0x80070057
2015-04-15 14:37:24, Error SP pDUSearch: DUSearch failed. hr = 0x80070057
2015-04-15 14:37:24, Error SP CDownloadDUUpdates::DoExecuteInternal: Failed to search for updates. hr = 0x80070057
2015-04-15 14:37:24, Error SP CSetupPlatform::DownloadDynamicUpdates: Failed to download updates. Error: 0x80070057[gle=0x00000012]
2015-04-15 14:37:24, Error MOUPG DUImage: Failed to execute DUImage LangPack search and download [0x80070057][gle=0x00000012]
2015-04-15 14:37:34, Error CONX WlanOpenHandle failed with error 00000426
2015-04-15 14:37:34, Error CONX Failed to initialize wireless class data 80070426
2015-04-15 14:37:43, Error CONX Failed to get class data from printer 80070057
2015-04-15 15:14:36, Error MOUPG Invalid UI subphase [0]. Progress phase arrays must be updated.
2015-04-17 19:17:56, Error SP Using current time as Recovery Timestamp.
2015-04-17 19:19:58, Error CONX ConX::Compatibility::CCompatibilityController::GetDriverBlockType: Found 0 compat info nodes for the specified driver package instead of just one.
2015-04-17 19:21:31, Error CONX ConX::Compatibility::CCompatibilityController::GetDriverBlockType: Found 0 compat info nodes for the specified driver package instead of just one.
2015-04-17 19:25:07, Error SP pSPRemoveUpgradeRegTree: failed to delete reg tree HKLM\SYSTEM\Setup\Upgrade[gle=0x00000005]
2015-04-17 19:25:37, Error [0x080831] MIG CSIAgent: Invalid xml format: FormatException: "name" attribute is mandatory for the <transforms> element. class UnBCL::ArrayList<class Mig::CMXEXmlComponent *> *__thiscall Mig::CMXEMigrationXml::LoadComponents(class Mig::CPlatform *,class UnBCL::String *,class UnBCL::XmlNode *,class UnBCL::String *,class Mig::CMXEMigrationXml *,class Mig::CMXEXmlComponent *,class Mig::CUserContext *)
2015-04-17 19:25:47, Error [0x080831] MIG CSIAgent: Invalid xml format: FormatException: Component with display name: Plugin/{566E8EC0-8A5C-4283-AD99-62004A6D128B} already loaded __thiscall Mig::CMXEMigrationXml::CMXEMigrationXml(class Mig::CPlatform *,class UnBCL::String *,class UnBCL::XmlDocument *,class UnBCL::String *,class UnBCL::String *)
2015-04-17 19:26:17, Error CSI 00000001 (F) 80220008 [Error,Facility=FACILITY_STATE_MANAGEMENT,Code=8] #718# from CWcmScalarInstanceCore::GetCurrentValue(options = 393216 (0x00060000), status = [6]"(null)", value = { type: 40972 (0x0000a00c), bytes ( 12 (0x0000000c) ): 65006e002d00550053000000 })
[gle=0x80004005]
2015-04-17 19:27:09, Error [0x0808fe] MIG Plugin {65cbf70b-1d78-4cac-8400-9acd65ced94a}: CreateProcess(s) failed. GLE = d
2015-04-17 19:27:09, Error CSI 00000002 (F) 80220008 [Error,Facility=FACILITY_STATE_MANAGEMENT,Code=8] #74376# from CWcmScalarInstanceCore::GetCurrentValue(options = 393216 (0x00060000), status = [6]"(null)", value = { type: 40972 (0x0000a00c), bytes ( 12 (0x0000000c) ): 65006e002d00550053000000 })
[gle=0x80004005]
2015-04-17 19:32:53, Error [0x0808fe] MIG Plugin {ee036dc0-f9b7-4d2d-bb94-3dd3102c5804}: BRIDGEMIG: CBrgUnattend::CollectBridgeSettings failed: 0x1, 0
2015-04-17 19:33:02, Error [0x0808fe] MIG Plugin {ff9c714f-b864-4f43-ae39-ec07d7385abe}: Unable to open service key '\Driver\ACPI_HAL'. Error = 0x000000A1
2015-04-17 19:33:18, Error [0x0808fe] MIG Plugin {526D451C-721A-4b97-AD34-DCE5D8CD22C5}: [shmig] Failed to get preferred homegroup with hr=0x80070490
2015-04-17 19:44:17, Error CSetupAutomation::Resurrect: File not found: C:\$Windows.~BT\Sources\Panther\automation.dat[gle=0x00000002]
2015-04-17 19:44:17, Error SP CSetupPlatform::ResurrectAutomation: Failed to resurrect automation: 0x80070002[gle=0x00000002]
2015-04-20 19:08:28, Error DU DU::CDUSession::Initialize: Failed to begin IUpgradeInternalSession. hr = 0x80004002[gle=0x000003f0]
2015-04-20 19:08:32, Error CDiagnosticsHelper::SetSQMDatapoint: Attempting to set a datapoint in an invalid SQM session
2015-04-20 19:09:27, Error MOUPG DUImage: Failed to execute DUImage critical search and download [0x80070091]
2015-04-20 19:09:48, Error DU DU::CDUSession::Initialize: Failed to begin IUpgradeInternalSession. hr = 0x80004002[gle=0x000003f0]
2015-04-20 19:10:02, Error SP pDUSearch: DUSearch failed. hr = 0x80070057
2015-04-20 19:10:02, Error SP CDownloadDUUpdates::DoExecuteInternal: Failed to search for updates. hr = 0x80070057
2015-04-20 19:10:02, Error SP CSetupPlatform::DownloadDynamicUpdates: Failed to download updates. Error: 0x80070057[gle=0x00000012]
2015-04-20 19:10:02, Error MOUPG DUImage: Failed to execute DUImage FOD search and download [0x80070057][gle=0x00000012]
2015-04-20 19:10:17, Error MOUPG DUImage: Failed to execute DUImage driver search and download [0x80070091]
2015-04-20 19:10:30, Error SP pDUSearch: DUSearch failed. hr = 0x80070057
2015-04-20 19:10:30, Error SP CDownloadDUUpdates::DoExecuteInternal: Failed to search for updates. hr = 0x80070057
2015-04-20 19:10:30, Error SP CSetupPlatform::DownloadDynamicUpdates: Failed to download updates. Error: 0x80070057[gle=0x00000012]
2015-04-20 19:10:30, Error MOUPG DUImage: Failed to execute DUImage LangPack search and download [0x80070057][gle=0x00000012]
2015-04-20 19:11:17, Error CONX WlanOpenHandle failed with error 00000426
2015-04-20 19:11:17, Error CONX Failed to initialize wireless class data 80070426
2015-04-20 19:11:24, Error CONX Failed to get class data from printer 80070057
2015-04-20 19:43:17, Error MOUPG Invalid UI subphase [0]. Progress phase arrays must be updated.
2015-04-20 19:45:27, Error SP Using current time as Recovery Timestamp.
2015-04-20 19:47:55, Error CONX ConX::Compatibility::CCompatibilityController::GetDriverBlockType: Found 0 compat info nodes for the specified driver package instead of just one.
2015-04-20 19:52:21, Error SP pSPRemoveUpgradeRegTree: failed to delete reg tree HKLM\SYSTEM\Setup\Upgrade[gle=0x00000005]
2015-04-20 19:52:51, Error [0x080831] MIG CSIAgent: Invalid xml format: FormatException: "name" attribute is mandatory for the <transforms> element. class UnBCL::ArrayList<class Mig::CMXEXmlComponent *> *__thiscall Mig::CMXEMigrationXml::LoadComponents(class Mig::CPlatform *,class UnBCL::String *,class UnBCL::XmlNode *,class UnBCL::String *,class Mig::CMXEMigrationXml *,class Mig::CMXEXmlComponent *,class Mig::CUserContext *)
2015-04-20 19:53:23, Error [0x080831] MIG CSIAgent: Invalid xml format: FormatException: Component with display name: Plugin/{566E8EC0-8A5C-4283-AD99-62004A6D128B} already loaded __thiscall Mig::CMXEMigrationXml::CMXEMigrationXml(class Mig::CPlatform *,class UnBCL::String *,class UnBCL::XmlDocument *,class UnBCL::String *,class UnBCL::String *)
Thanks!
Reply:
Build 10061 has been released and it is available through Windows Update in Fast ring.
What Windows version are you now using ?
------------------------------------
Reply:
------------------------------------
Reply:
Your Windows Update does not show build 10061 ?
Are you sure ?
I could be wrong. I thought Windows Update will show the most current build available regardless of whuch build you are in.
------------------------------------
Reply:
Build 10041 ISO has been release by Microsoft.
It is available to download.
Do you want to install it this way ?
http://windows.microsoft.com/en-us/windows/preview-iso-update-1503
------------------------------------
Reply:
------------------------------------
Reply:
I got the same error while trying to update to 10061. :(
Sorry to hear that.
You mentioned ......It seems to be a problem with drivers, but I didn't find it.
Did you get that message from the computer or you are guessing ?
My knowledge on drivers is limited. I prefer not to try answering that.
Please wait a bit and someone will come along to help you.
I apologize for not being helpful to you.
Good luck.
- Edited by david hk129 Tuesday, April 28, 2015 1:58 PM
------------------------------------
Reply:
This is the way I fixed it when I got this issue. This may need a little bit of technical know how. If you have a graphics card in your computer, you must change anything that is plugged into your motherboard (this can usually be identified as the one that is near all of the usb ports on the backside of your case), into your graphics card, easily identified as a few display ports further away from the backside USB ports. If you don't have any plugged in their in the first place, don't fret! Shut down and enter BIOS upon boot up, go to your Display option, and disable Integrated Graphics, this disables the graphics drivers on your CPU, this will only work if you have a graphics card. Once you do that, exit by saving. Then boot up, go to settings, and update and recovery, and install and enjoy. This should work.
- Edited by Joshua Mendoza Friday, May 1, 2015 3:13 AM Clarification
------------------------------------
Mac OSX 10.10.4: Microsoft RD stops responding during changes for Client Trust Settings
When accepting changes to the Client Trust Settings to always allow connecting to a self signed client, the MRD software hangs up on the authenicating screen. There is no way to cancel the authenication, that includes quitting MRD.
visual studio performance problem.
Asalam o alekom :
i use visual studio when i save changes in my asp.net project it need to click CTRL+S three times to be saved and every time it take a little more time.
Reply:
Hello,
This should be asked in Microsoft's ASP.Net forums:
As Microsoft's ASP.Net forums are on a different platform, we cannot move the question for you.Karl
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
My Blog: Unlock PowerShell
My Book: Windows PowerShell 2.0 Bible
My E-mail: -join ('6F6C646B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})
------------------------------------
Reply:
------------------------------------
what you guys use for production vm storage?
would you put into production some free solution with allowed commercial use (no eula violation! ) but with community only / limited vendor support?
what would be a game changer for you? say going freenas (free) -> truenas (paid) upgrade?
tnx!! :)
- Changed type MedicalSMicrosoft contingent staff Monday, May 4, 2015 1:50 AM
Reply:
Allow me to anser your question with a question:
If your storage goes down and is out of commission for an extended period of time while you wait on the "community" to respond to your post about how to fix it....will you lose your job?
If so....I think you have the beginnings of your answer.
------------------------------------
Outlook 2013 - Getting Inbox Message Count
I am using Office 365 and use Outlook 2013 for email. I have an mailbox I use and it has several shared mailboxes in its profile. I need a powershell script that will get a daily count of messages in each of the shared mailboxes, send those totals out in an email, then delete all the messages in the mailboxes. Can you help me? I am very inexperienced in powershell scripting.
Also, the platform is Windows Server 2008 R2 SP1, .NET 4.5. I am aware that I need to install ISE and WMF, but have not done that yet.
Thanks,
Mac McGhee
- Changed type Bill_Stewart Friday, June 12, 2015 9:56 PM
- Moved by Bill_Stewart Friday, June 12, 2015 9:56 PM This is not "scripts on demand"
Reply:
This forum is for specific scripting questions rather than script requests.
The script request form is here:
https://gallery.technet.microsoft.com/scriptcenter/site/requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
Hi,
Prewritten scripts can be found in the repository here:
https://gallery.technet.microsoft.com/scriptcenter
If you don't find what you're after and you can't write your own, you can request a script here:
https://gallery.technet.microsoft.com/scriptcenter/site/requests
Let us know if you have any specific questions.
Don't retire TechNet! - (Don't give up yet - 13,225+ strong and growing)
------------------------------------
I purchased a toshiba laptop in 2013. I also purchased and loaded a word 2013 software package for which I paid $139.99. This software has stopped working and all the valuable documents, presentations, and valuable family photos are now accessible.
My son is going off to college and uses this computer to apply to colleges, write essays, and verify scholarship statuses. This is a great hindrance for my son as well as our family endeavors. I feel very distraught regarding this issue it has held unbearable consequences for my family. I am just an every day mother of 7 who has striven for success and requires the same out of my seven children. My youngest son Isaiah J. Davis, has exemplary character, determined drive, and admirable enthusiasm. For him to miss out on any part of his destined future.
I also was suppose to receive Word 10 software as a bonus for purchasing the Word 2013 package. Now I'm really regretting utilizing the software system that I learned to love over the 20 year duration of employment within various customer service fields! I thought I had a company I could trust and reference to others as a reliable system to utilize.
I don't believe this is how customers, especially paying consumers should be treated and trust me I know.
Mrs. D. Jai' Davis
3611 Limestone Avenue
Dayton, OH 45417
(937) 641-1599
- Moved by Cindy Meister MVP Thursday, May 21, 2015 4:53 PM not developer related
Reply:
Hello Jamal,
The forum is for developers. I'd suggest asking non-programming questions on the Microsoft Community or Word IT Pro Discussions forums instead.
------------------------------------
Reply:
Stefan Blom, Microsoft Word MVP
------------------------------------
Current list of items that will keep me from using Windows 10 in my company.
It it is worth anything, here is the current list of items that will keep me from moving from Windows 7as of build 10041. As Windows 10 will not allow direct reporting without loging in with a Microsoft id, I am posting this list here.
Cisco Unified Personal Communicator is broke as of this release.
There is no way to remove the big blue box that is growing out of the side of the start menu. Apparently this is supposed to be used to keep icons. Just an FYI, if I wanted to use an icon I would just put it on the desktop or the taskbar where it goes.
When you right click an item and tell it to "pin to start" it puts a big icon in the big blue box instead of pinning it to the start menu. Again, why? We already have the desktop and the taskbar to hold icons. The start menu should be a comprehensive list of the programs on the computer. While we are at it, I don't need letters separating the programs. The first letter of the program is the letter.
When I click the network icon next to the clock on the taskbar, It shows me the networks available, but when I click the network to connect to, instead of giving me the option to connect, I have to wait for another window to open, then I have to click the network again in the new window, then click connect. There should not be more clicks to get to something that has been easy to this point.
Rasphone needs to be fixed. Please review how it works in Windows 7. Having to use Rasdial is not secure as the user and pass has to be stored in readable text.
The notification window by the clock shows white on startup indicating there is a notification. When you click it, there is no notification. (This is not so much a deal breaker, just annoying).
Please do more regression testing to ensure you are not breaking things when you are adding new things.
**Update**
Another issue - When the VPN connection fails, it does not automatically try to reconnect itself. There does not seem to be a setting anywhere that allows you to change this.
- Edited by primoit Friday, March 27, 2015 1:50 PM add updated info.
Reply:
When I click the network icon next to the clock on the taskbar, It shows me the networks available, but when I click the network to connect to, instead of giving me the option to connect, I have to wait for another window to open, then I have to click the network again in the new window, then click connect. There should not be more clicks to get to something that has been easy to this point.
Rasphone needs to be fixed. Please review how it works in Windows 7. Having to use Rasdial is not secure as the user and pass has to be stored in readable text.
Are you sure that you've tried this on 10041. For this screen shot I clicked the network icon in the tray, then clicked the link for the network in the window that popped up.
------------------------------------
Reply:
There is no way to remove the big blue box that is growing out of the side of the start menu. Apparently this is supposed to be used to keep icons. Just an FYI, if I wanted to use an icon I would just put it on the desktop or the taskbar where it goes.
When you right click an item and tell it to "pin to start" it puts a big icon in the big blue box instead of pinning it to the start menu. Again, why? We already have the desktop and the taskbar to hold icons. The start menu should be a comprehensive list of the programs on the computer. While we are at it, I don't need letters separating the programs. The first letter of the program is the letter.
1st, I have to inform you that start menu/screen is not yet final/finish. if you check start menu properties, you will find that customization is currently disabled.
that big blue box at the side of start menu is the live tile screen, pin tiles is place there. it is similar to start screen. the difference between desktop or taskbar and the "big blue box" is the live tiles. desktop icon and taskbar don't/can't perform content update when the app isn't running.
for the first letter of program list, I believe it is use for jump list (similar to windows phone).
------------------------------------
Reply:
Thanks for checking this Paul. But, it does work exactly like I described it in 10041. Click the network icon by the clock, click the network, wait for a window to open, click the network again in the new window, click connect.
Also the networks I am connecting to are VPN's. I should have been more specific. I do not use WIFI on this machine, so I cannot comment on how that works.
This doesn't seem to be as big a problem now as when I first reported it. The part where I was waiting for the new window to open seems to be a lot faster now. The time waiting for the box went from almost 3 seconds to less than 1. I cannot say if Windows learned the behavior and now keeps it ready or if the Windows update I got yesterday fixed the problem. Either way, as long as it moves quickly I am ok with it.
- Edited by primoit Monday, March 30, 2015 12:49 PM network clarification
------------------------------------
Reply:
Yes I am aware things are not finished. Thus the reason they call it a Technical Preview. The idea is to address the problems that exist on each build in an effort to create an operating system that is usable.
On previous releases the issues with the start menu could be addressed. In this version they cannot. I have no problems with making things usable for the most amount of people. If there are some that like the big blue box growing out of the side of the start menu, let them have it. For the rest of us that do not want it growing out of the side of the start menu, there needs to be a way to turn it off.
As far as the letters in the start menu, if they are supposed to work as a jump list, it is also broken. It is a complete waste of space, and again, it should have an option to turn it off.
------------------------------------
Reply:
I attach apps to the taskbar by dragging and dropping them to the taskbar. You can do that from the Explorer, the desktop or the blue box.
Jake
------------------------------------
Reply:
Yes I am aware things are not finished. Thus the reason they call it a Technical Preview. The idea is to address the problems that exist on each build in an effort to create an operating system that is usable.
On previous releases the issues with the start menu could be addressed. In this version they cannot. I have no problems with making things usable for the most amount of people. If there are some that like the big blue box growing out of the side of the start menu, let them have it. For the rest of us that do not want it growing out of the side of the start menu, there needs to be a way to turn it off.
As far as the letters in the start menu, if they are supposed to work as a jump list, it is also broken. It is a complete waste of space, and again, it should have an option to turn it off.
send your concern and suggestion via feedback app.
as far as start menu is concern, current state of it is incomplete. customization is no yet available. If you understand what I'm saying, wait for MS to finish start menu, before complaining.
------------------------------------
Reply:
I totally understand what you are saying. You should just move on to another thread. The feedback app is not available with a local account. If you had read the first sentence in the post you would know this. The entire purpose of the post is to bring awareness to the problems in this version (10041). The start menu is currently a big problem. If it is not a problem for you, again, just move one. Repeating the same thing over and over without offering a solution is not helpful.
------------------------------------
Reply:
Your company's acceptable use policy must be a lot more relaxed than every company I work for.
Most of what prevents you from cutting over is aesthetic or simply buggy at this time in the beta versions.
What will prevent me from migrating several hundred systems is the fact that aside from the list you provide (and the lack of a customizable and/or Classic start menu), is the simple fact that the OS comes with canned items which are serious violations of our corporate computer acceptable use policies.
These items need to be removed or easily disabled/uninstalled:
(only a partial list, I have a very short lunch break)
- XBox - Gaming on company time is a serious offence.
- One Cloud - Provides the ability for users to potentially release classified information or data.
- Live Tiles - Will likely be exploited as was the WIndows Sidebar. Unsafe
- Apps that permit live streaming of data -
- Any apps that cannot be managed by AD Group Policy.
More when I have the time but the point should be clear, the Enterprise preview in its current state will never pass our security requirements.
------------------------------------
what you guys use for production vm storage?
would you put into production some free solution with allowed commercial use (no eula violation! ) but with community only / limited vendor support?
what would be a game changer for you? say going freenas (free) -> truenas (paid) upgrade?
tnx!! :)
- Changed type MedicalSMicrosoft contingent staff Monday, May 4, 2015 1:52 AM
Reply:
The software is one thing but you need to focus more on hardware. The best storage software in the world would still give rubbish performance if you built it out of a standard desktop. You need to think about RAID level's, Input Output operations per second, disk latency, Network performance etc. There's no point having 50 VM's running of a single cat 5 cable. You need to consider bandwidth between the virtual host and the storage solution, maybe 10GB Fibre is more appropriate.
Assuming your hardware can cope with the requirements, then either of the options can work. For production environments you also need to consider support. If you have problems with FreeNAS then who can you call for support? Can your business handle being offline for however long it will take you to research / test a solution recommended by the community support? On a home lab it does not matter, if a business is relying on it's infrastructure then you need to know you can get qualified support quickly.
How much of this is relevant to yourself depends what scale you are working at and what is acceptable downtime.
------------------------------------
Month by Month Pivot Table
Hi,
I have a list of dates and data that go back a year. In Excel I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly information that is available but the one I'm looking for is the one that will separate my dates by each month similar to the quarterly function.
Is this something I can do with in the pivot table function or would I need to do something else, and if I do can you give me some advice as to how I can do this,
Thanks for your time and help
Reply:
Hi,
I have a list of dates and data that go back a year. In Excel I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly information that is available but the one I'm looking for is the one that will separate my dates by each month similar to the quarterly function.
Is this something I can do with in the pivot table function or would I need to do something else, and if I do can you give me some advice as to how I can do this,
Thanks for your time and help
1. In the Pivot Table click somewhere in the column that contains the dates then:-
PivotTable Tools
Options contextual tab
Group group
Click on:-
Group Selection
- so that the window called:-
Grouping
- opens.
2. In the window called:-
Grouping
- click:-
Months
- then click:-
OK
All your data for all the years is now sorted into months.
Does that give you what you want?
- Edited by trip_to_tokyo Thursday, April 30, 2015 1:53 PM
------------------------------------
Exception handler missing debug context
When an 32-bit application running in windows 10 64-bit (build 10041 ) receives an exception (using a vectored exception handler callback) the debug context is left empty. When compiled for 64-bit everything works just fine.
This can be an issue for some older software that make use of this feature for DRM purposes (debugger detection)
I've posted an example program that shows the issue here: http://pastebin.com/9GkEafAr
Error during Biztalk 2013 R2 configuration
HI All
Attached the error during Group Configuration ,Please advice
Reply:
Try enable FIPS compliant algorithms as shown in the following link
http://blog.aggregatedintelligence.com/2007/10/fips-validated-cryptographic-algorithms.html
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
------------------------------------
Reply:
This issue happens because in your local GPO FIPS policy has been enabled. Refer https://technet.microsoft.com/en-us/library/security/cc750357.aspx for FIPS compliance.
Refer to similar threads
Also I understand that the SN Key you use to sign your modules/dll may also be impacted because of the key strength used.
Regards.
------------------------------------
Reply:
Hi All
Unable to trace the root cause for the issue
Regards
Suresh
------------------------------------
Reply:
On the servers where BizTalk and SQL is installed, please open the Local Security Policy and look for "System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing" then if this shows "enabled" is the root cause of this issue. After you disable this, on both the servers you will not encounter the error.
Regards.
------------------------------------
ADFS in Azure fails when Site-to-Site VPN fails
We have ADFS 3.0 setup on several VMs in Azure with a Site-to-Site VPN between them and the local Network.
All works fine until the VPN goes down and although external users can access the ADFS logon screen (via the ADFS Proxy in Azure) they are unable to authenticate, even though there's a Domain Controller in Azure.
We can't understand why the DC in Azure won't authenticate the users while the VPN is down?
As soon as the VPN comes back up again it all starts working.
We've checked that the Azure VMs are using the correct DNS settings i.e. they are looking at the local DC rather than on-premise and that seems ok
Anyone else had similar problems?
Cheers for now
Russell
- Changed type Vivian_Wang Thursday, April 30, 2015 8:49 AM
Reply:
This post is provided AS IS with no warranties or guarantees, and confers no rights.
~~~
Questo post non fornisce garanzie e non conferisce diritti
------------------------------------
Reply:
Thanks for your prompt reply, I had a look at the DC in Azure and having run dcdiag, realised that it was unable to contact all the DC's on the local network!
On further investigation it seems that one of the on-premise DCs wasn't able to route to the Azure subnet, now that's sorted we should be "good to go".
Cheers for now
Russell
------------------------------------
Reply:
We managed to sort out the errors we were seeing on the DC in Azure but we're still getting the original problem of not being able to authenticate when the site-to-site VPN is down.
Looking at the ADFS server in Azure we are seeeing event IDs 342, 364 and 1000 when trying to authenticate when the VPN is down.
Looking on the Internet is seems that the 364 error can be caused by a time skew (not the case), invalid SSL certiifcate (not the case) or Certificate Revocation Checking (not the case).
Any suggestions would be much appreciated?
Cheers for now
Russell
------------------------------------
Reply:
All I can think is increasing the logging and see if it provides more information:
http://blogs.msdn.com/b/card/archive/2010/01/21/diagnostics-in-ad-fs-2-0.aspx
This post is provided AS IS with no warranties or guarantees, and confers no rights.
~~~
Questo post non fornisce garanzie e non conferisce diritti
------------------------------------
Reply:
I've increased the logging but still no helpful information as to why it only works when the VPN is in place!
I've checked all the name resolution settings to ensure that they're not pointing at the on-premise DC's and tested the same with the VPN down. Everything seems fine until you try and use the ADFS service and then the authentication fails.
I'll keep looking at let you know if/when I figure out what's going on.
Cheers for now
Russell
------------------------------------
Reply:
Just wanted to let you know that we've now implemented a fully resilient ADFS solution in Azure and triple checked all the name resolution settings.......but we're still failing authentication when the site-to-site VPN is down.
I'm not sure that there's anything else I can do except raise a support call with Microsoft and see fi they can help us troubleshoot the problem.
Cheers for now
Russell
------------------------------------
Reply:
Hi,
Azure related to issue, you could ask in:
https://social.msdn.microsoft.com/forums/azure/en-US/home?category=windowsazureplatform
Regards.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com
------------------------------------
SSIS Analysis Services Processing Task - which object is being processed?
Hi
I've just fallen down the hole dug by a gotcha in the SSIS Analysis Services Processing task (let's call it the ASPT as it's too long to type).
I was doing testing yesterday, targeting a test database. The way things are set up here is that we have two structurally-identical databases (let's call them SSASLive and SSASTest) on the same SSAS server.
The SSIS package includes an Analysis Services Processing task that processes a partition of a measure group in a cube.
So I changed the properties of the AS Connection Manager in the package to point to database SSASTest. Then, because I'm paranoid, and don't trust the Editor for the ASPT, I edited the object to be processed, by deleting the existing object from the list and re-adding it (going down the tree: database SSASTest, cube TheCube, measure group TheMassiveMeasureGroup, partition CurrentMonth).
This is an annoying necessity, because: the ASPT editor doesn't allow you to see exactly what the object(s) in the list to be processed are, by e.g. double-clicking on them. All you can see is the lowest-level object name, which could be just "Current Month". Current Month what? There's no way of telling.
Test worked fine. I made sure the AS Connection manager was reset to point to SSASLive, and deployed the package.
This morning, the package ran, and processed the partition in database SSASTest. What happened? Looking in the Code view of the package, I found the XMLA behind the Processing task: the database name is literally specified in the XMLA, and completely ignores the Catalog of the AS connection. This information is not exposed anywhere in the UI view of the package.
It's a bit like the dangerous annoyance when testing SSIS package Exec SQL tasks, where a previous developer has insisted on fully-qualifying object names: SELECT * FROM LiveDatabase.dbo.ATable. You're working with a connection to a test database, but it makes not difference...
But at least that problem is clearly visible. I know that specifying the database name is normal in XMLA tasks: but at least the SSIS editor should allow you to see what the setting is.
- Changed type sebts Tuesday, April 28, 2015 1:32 PM
Reply:
You may want to check package configuration, if you have a dynamic connection then your package will tend to get the connection attributes from configuration (XML, SQL Server, Environment variable, registry setting, parent package). Your package value will only be considered when your package fails to get the configuration values. Check this tutorial to identify which configuration is being set for your package and change the value over there.
Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.
My Profile on Microsoft ASP.NET forum
------------------------------------
Reply:
No, the point is that the Connection Manager's Initial Catalog setting (whether hard-coded or set by any of the configuration methods) has no effect on the database addressed by the Analysis Services Processing task.
Steps to reproduce:
1. Create an Analysis Services database containing a cube (or select an existing one): let's call it ASDB1.
2. Make a copy of it on the same server, e.g. by backing up and restoring: let's call it ASDB_Copy
2. Set up an SSIS package with a Connection Manager pointing to ASDB1
3. Create an Analysis Services Processing task, using the Connection Manager, processing any particular SSAS object.
4. Run the package. The SSAS object in ASDB1 is processed (not the object in ASDB_Copy). (Confirm by checking the Last Processed date in SSMS, Properties).
5. Change the Connection Manager's Initial Catalog setting to point to ASDB_Copy.
6. Run the package. The SSAS object in ASDB1 is processed, not the object in ASDB_Copy. The Connection Manager's Initial Catalog setting has no effect on the AS Processing Task. Examining the Code view of the package confirms that the XMLA behind the task specifies the database as well as the AS object. (and this database setting is still ASDB1).
The fix would be for SSIS to perform validation of AS objects referenced by the AS Processing Task whenever its Connection manager is pointed to a different database, and to update the XMLA accordingly.
Also, it would be useful to be able to see exactly what the objects listed in the Processing Task are. The information shown is just not sufficient to identify the object to the developer. I may have dozens of measure groups with a partition called Current Month - but "Current Month" is all I can see in the editor, and there's no way to e.g. double-click on an item in the list and get the full object identification (Cube X, measure group Y, partition Current Month). Sure, I can go and look at the XMLA, but that's fiddly: if there's going to be a wrapper around the XMLA (which is what the AS Processing Task is), then it should be unambiguous.
------------------------------------
How do I combine these 2 queries into query?
I have these below 2 queries. How can I convert them into one single query? please advice.
SELECT @monitoringDaysTag = t.TagID FROM tag.tag t WHERE t.TagName = 'AgentMonitoringDays' SELECT @monitoringStartTag = t.TagID FROM tag.tag t WHERE t.TagName = 'AgentMonitoringStartTime' SELECT @monitoringEndTag = t.TagID FROM tag.tag t WHERE t.TagName = 'AgentMonitoringEndTime'
I tried the following but it didn't give the desired output.
SELECT @monitoringDaysTag = CASE t.TagName WHEN 'AgentMonitoringDays' THEN t.TagID END, @monitoringStartTag = CASE t.TagName WHEN 'AgentMonitoringStartTime' THEN t.TagID END, @monitoringEndTag = CASE t.TagName WHEN 'AgentMonitoringEndTime' THEN t.TagID END FROM tag.Tag t WHERE t.TagName = 'AgentMonitoringDays' OR t.TagName = 'AgentMonitoringStartTime' OR t.TagName = 'AgentMonitoringEndTime'
mayooran99
Reply:
Are you looking for something like this?
DECLARE @TAG TABLE ( TagId INT, TagName varchar(50) ) INSERT INTO @TAG VALUES (1, 'AgentMonitoringDays'), (2,'AgentMonitoringEndTime') ,(3,'AgentMonitoringStartTime'), (4,'AgentMonitoringEndTime'), (5,'someothervalue') -- Getting tag Id for specific tag names SELECT TagId FROM @TAG WHERE TagName IN ('AgentMonitoringDays' ,'AgentMonitoringEndTime','AgentMonitoringStartTime') -- getting number of times tag name appeared SELECT COUNT(Tagid) AS MonitoringDaysTag, TagName FROM @TAG WHERE TagName IN ('AgentMonitoringDays' ,'AgentMonitoringEndTime','AgentMonitoringStartTime') GROUP BY TagName Hope this will help
Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.
My Profile on Microsoft ASP.NET forum
- Edited by Anuj Tripathi Thursday, April 30, 2015 6:32 AM
------------------------------------
Reply:
Try the below:(Used Anuj's DDL script)
DECLARE @TAG TABLE ( TagId INT, TagName varchar(50) ) INSERT INTO @TAG VALUES (1, 'AgentMonitoringDays'), (2,'AgentMonitoringEndTime') ,(3,'AgentMonitoringStartTime'), (4,'AgentMonitoringEndTime'), (5,'someothervalue') Declare @monitoringDaysTag int,@monitoringStartTag int,@monitoringEndTag int SELECT @monitoringDaysTag = CASE t.TagName WHEN 'AgentMonitoringDays' THEN t.TagID Else @monitoringDaysTag END, @monitoringStartTag = CASE t.TagName WHEN 'AgentMonitoringStartTime' THEN t.TagID Else @monitoringStartTag END, @monitoringEndTag = CASE t.TagName WHEN 'AgentMonitoringEndTime' THEN t.TagID Else @monitoringEndTag END FROM @Tag t WHERE t.TagName = 'AgentMonitoringDays' OR t.TagName = 'AgentMonitoringStartTime' OR t.TagName = 'AgentMonitoringEndTime' Select @monitoringDaysTag ,@monitoringStartTag ,@monitoringEndTag
Please mark this reply as answer if it solved your issue or vote as helpful if it helped.
[Blog]
------------------------------------
No comments:
Post a Comment