Reporting Services issue on SP1

From my install of SP1 on Vista x64 I seem to only have had one problem. This was that reporting services no longer worked.  After some digging around I found that the script permissions had been removed from the ReportServer virtual folder.

 

To fix this manage the computer and go to Internet Information Services. Open the web site and click on the ReportServer virtual directory. In the center panel double click on Handler Mappings and click on the Action "Edit Feature Permission".  Enable the Script option.

 

If you cannot get any settings options when browsing to the Reports web site then you may need to run the brower as administrator.  You can then add the local administrators group to the site security settings.

Execute DTS package: permisson issues?

 

Hi guys,

 

I'm [trying to] execute a SSIS project (.dtsx file)... from a web service.

I find that if i do package.Execute() from a test or console app it goes just fine. But when I try to execute the package from within a web service, it says it failed.

I presume is a permisson issues (and that would make perfect sense). Is it right?

Is there a way to circunvent this?

 

Thanks a lot!

 

Code, using C# .NET 2.0:

 

 

Code Snippet

using Microsoft.SqlServer.Dts.Runtime;

 

namespace Biz

{

public class Helper

{

public static String YadaYada()

{

DTSExecResult _result = DTSExecResult.Failure;

Application app = new Application();

Package package = new Package();

package = app.LoadPackage("C:\\YadaYada.dtsx", null);

_result = package.Execute();

return _result.ToString();

}

}

}

 

 

Reply:

Please post the details of the exception (error type, error message, stack trace), for it is the most basic as well as most important information to diagnose a problem. 

 

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

 

We are changing the issue type to "Comment" because you have not followed up with the necessary information. If you have more time to provide more information, please feel free to change the issue type back to "Question" by editing your initial post and changing the radio button at the top of the post editor window. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

 

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

Windows Live Sign-In Assistant Support

The forums' login page should support the Windows Live Sign-In Assistant.

---

Franklin Tse (whale)

Reply:

Good idea, we'd definitely like to make sign-in easier. I'll check to see what's required.

---

Andrew Brenner, Forums Product Planner

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

I've added this to our list to consider for a future release.

---

Andrew Brenner, Forums Product Planner

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

Thanks!

---

Franklin Tse

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

Links from profile to posts & search forum member

I think it would be very useful to have links from user profile to all posts this user has made. This is a very common functionality in many non-Microsoft communities.

For example, I just clicked on the name of user currently listed as #1 for expression posting

http://profile.msdn.microsoft.com/en-us/?view=Expression+Newsgroup+Migrator&referrer=http%253A%2f%2fforums.msdn.microsoft.com%2fen-us%2fForums%2f

I'd love to see his/her other answers as they are likely 'good'. I can only do that if I search for that exact name.

If I just search for 'migrator' at 'Browse Users' at http://forums.msdn.microsoft.com/en-US/users/ I don't get anything.

So 2 suggestions

1. Link to 'find all user's posts'
2. Improve search to allow for partial user name search

Thanks

Sasha

---

SashaK

Reply:

Actually, if you click on the user name there is a "XXX's Threads" link in the banner near the top left of the page. Alternatively, if you select Browse Users, you can Find User By Name and there is a View Threads link for each user from there. The Browse Users search does support a wild card * at the end.

HTH

---

Rob J, Forums Dev

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

That is a nice feature.

Now to be able to set an Alert on the User as well as the thread.

Sometimes, it is useful to follow a specific user.
If the user is exemplary, I may wish to read everything he/she posts.
Othertimes, as a Moderator, I may need to track a users participation -either to validate that he/she deserves having an 'upgraded' status -perhaps even being promoted to a Moderator, or in some situations, mentor the user about better and more appropriate ways to interact with the Forums.

---

You may be only one person in the world, but you may also be the world to one person.

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

Once you are in the "XXX's threads view", you can subscribe to an RSS Feed for that user. While this may not be as convenient as the alerts, it can be done now. And of course we'll definitely be looking at ways to enhance the alerts functionality in future releases.

Keep the great suggestions coming!

---

Rob J, Forums Dev

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

Rob,

Thanks for the info on the RSS feeds by User name.

I will still prefer an Alert be made available on the User level -as well as the thread level.

---

You may be only one person in the world, but you may also be the world to one person.

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

DVD Encoding in Vista

I have had nothing but trouble using vista to Create/ Encode DVD Video's. It doen't matter which program I use, I have used all the Window Vista Programs and Nero 8, and about 5 others.

 

The only luck I have had is downloading from freecodecs.com updated codecs and that only works for a while. I am hoping Microsoft comes up with a solution because it is traceable back to Vista.

Sftp Adapter released on CodePlex

"sftp is an interactive file transfer program, similar to ftp, which performs all operations over an secure encrypted ssh transport".

www.codeplex.com/sftpadapter

0x80072EFD

 

I have the Samsung Blackjack. I tried a number of the suggestions - even reinstalled activesync and I still could not sync. I realised it was bombing out while trying to synchronise NotePadSync so I deselected to synchronise this and it all seems to be working now.

Win an Xbox for finding Spatial Bugs

 

I wanted to highlight that in the ongoing SQL Server 2008 February CTP Bug Bash there is a specific prize for spatial bugs.  Spatial entries have been a little light so far which is hopefully good news for me but it's also good news for you as you have very good chances to win.

 

Number of reproducible non-duplicate SQL Server 2008 Spatial bugs submitted during Entry Period

1^st Place - One Xbox Elite

 

More information about the contest is available here:

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7734

 

The deadline is 11:59 PM PST on March 15, 2008

 

Make sure you remember to mark the checkbox "This entry is for the SQL Server 2008 February CTP Bug Bash Contest."  If your entry does not include this option, it will automatically not be counted.

 

 

 

Nice article about AI 1.5 (beta)

 

Take a look at this very nice article:

http://searchwincomputing.techtarget.com/tip/0,289483,sid68_gci1301339,00.html

 

 It also has screenshots, so you can see how the new UI looks-like and read more about the different features.

Reply:

Feel free to post any follow-up feedback or questions on this thread.

 

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

Last post by ...

I dunno if this is suggested before but maybe its possible to add in wich thread the last post is posted. Now it is:
Last post: 2 hours ago by Rick Postmus. This is at forum index. Maybe it would be more powerfull with adding the thread title?

Alerts based upon OP'er

It would be great to be able to flag a specific poster such that you are alerted with any posts that they make. It would be useful, both to enable you to encourage new contributors who have just begun to post, and to allow you to follow the posts of a particularily adept poster. I imagine that it would be useful to moderators in order to track posters they have had problems with (aggressive, etc.).

Reply:

For more information about this request, see my post in this thread:

http://forums.msdn.microsoft.com/en-US/thread/c0330dc2-7769-4a6f-9865-e6cb8482f502

---

You may be only one person in the world, but you may also be the world to one person.

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

Geez! I had searched for that, thinking that you might have posted it! Guess I have to search harder next time.....

Edited to say: Nevermind...I didn't check your post time. I would have been searching pretty hard to find it!

• Edited by Aaron Alton Wednesday, March 5, 2008 4:07 AM Late night brain

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

Aaron

I didn't mean to imply that your post was somehow subsequent to mine.
Only that my post, which was made before seeing that you had posted on the same topic, went into a bit more depth.

---

You may be only one person in the world, but you may also be the world to one person.

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

No, the assumption was mine! That's why I was kicking myself for not reading it properly.....your post was definitely very fitting, and I do believe that such a feature would be a very valuable benefit for posters and moderators alike. I realize that there are still a lot of bugs to work out with the new forums, but hopefully we can see it in a later release.

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

Navigation When Replying

The Preview feature is good, but I have found an issue that is fairly irritating, and have a couple of suggestions as to how it might be remedied.

In order to reply to a thread being previewed, one must click on the Title link, which navigates to a page containing the single entry. After replying, one must then navigate back to the page with all of the thread headers. One thing I've noticed is that if I filter this page by "No Replies," when I navigate back it is unfiltered again. So, that would be helpful, to persist the filter when navigating back from an answer.

In order to avoid this issue, I can open the link to the single message in a new tab. Of course, after replying, the message thread header page is not updated. Now, there are 3 approaches (I can think of outright) which might solve this issue. One would be to include a "Reply" button in the preview, and allow a message to be replied to in the same page with the message headers. Another would be to have each individual message open in its own tab or window. I realize with IE this is problematic, since tab configurations are client-side user-controlled, and having a web page open a window raises security issues with IE (although those can generally be overcome). The third approach would be to use a target frame attribute in the link which would specify a new page. Of course, this would not remedy the message header page updating after replying, but that is not as severe a problem as the other, in terms of the time it takes to navigate the forum.

The use of Ajax in these forums has been a real time-saver. I'm sure that Ajax could also be used to improve the issue I'm discussing here.

---

Kevin Spencer, Chicken Salad Alchemist

Install files "stop working"

Every time I try and install an application file that I have downloaded from the internet (driver software, itunes, etc.)  I get an error message the the program file has "stopped working"  I've only just installed Vista Ultimate (32) a few days ago and have not been able to figure this out so I turn to the boards for help.  I literally can not install anything at all.  I've turned off DEP and that doesn't solve the problem. 

 

I've also encountered a lot of problems trying to install updates.  Error code 80200053 seems to come up on most of them and I haven't really been able to find any useful information on this.  I find it hard to believe I'm the only one having these types of problems and I since my computer is rated a 4.2 on the Windows scale (what kind of scale goes from 1 - 5.9 anyway) I don't think it's a hardward issue.

 

Any help you can provide will be greatly appreciated and any further information I can give you I'd be happy to pass along.

 

Thanks in advance

 

Vista Ultimate Pain in the ***

 

Joe

Reply:

Hi Joe,

Which software did you tyr to install?  Can you install some Microsoft Products like Office 2007 or MSN?

--------------------
Regards,
Eric Zhang
Microsoft Online Community Support

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

Hi,

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

Thanks!

--------------------
Regards,
Eric Zhang
Microsoft Online Community Support

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

 

I've had similar problems and been getting the exact same error code (80200053) along with error code (80240022) but I receive it while trying to run windows updates or update the definitions for windows defender.  The updates are listed, but they don't install at all.

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

I am currently having the same issue. I have been attempting to install the optional drivers provided by Microsoft updates for my Nvidia 8800 GTX video card, and each time the install fails and I recieve the error code 80200053.

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

Correcting Incorrect Joins

Hi there,   if you are looking for a method to correct incorrect joins, you should read our new document called " Correcting Incorrect Joins".   We are happy to announce the release of this document to the download center. Here is the link to the download center page.   For helping to drive the development of this document, I would like to extend a big thank you to   ·         Mike Dube, Microsoft Corp. ·         David Conners, Microsoft Corp. ·         Bill Mathers, Microsoft Corp. ·         Joe Stepongzi, independent IdM specialist.     We welcome any feedback on this document. Please feel free to post comments to this forum.   Also, if you have ideas for additional documentation topics, please don't hesitate to contact us!   Cheers, Markus   /////////////////////////////////////////////////////////////////////// Markus Vilcinskas Technical Writer Microsoft Identity Integration Server mailto:markvi@microsoft.com.NO_SPAM This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/copyright.htm ///////////////////////////////////////////////////////////////////////

 

 

Link to current thread

Hi,

the bread crump above the current thread should contain a link to the current thread to ease reloading the thread after adding a new post.

Alex

Reply:

When you say "easy reloading", I think you mean the ability to refresh the page easily. Or are you meaning something different?

In that case, our forums are ajax based, and so they don't need to be refreshed – new posts show up automatically without refreshing.

---

Andrew Brenner, Forums Product Planner

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

volume idriver and sound

 

I never had a problem until the update from msn then all this *** happened and they don't seem to want to help.  I unistalled the driver for the sound still nothing so hp helped me and down loaded a new driver fior the sound but the volume driver is still messed up windows vists updates are no good if they mess up peoplse pcs. will think twice before updating the windows update next pc may be a IMB

Reply:

Hello Vicki,

 

Please reinstall the updated driver provided and check if some utility delivered with the driver has muted the sound.

 

Regards,

Lionel Chen

Microsoft Online Community Support

 

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

I did reinstall the driver and no it's not muted. still don't work.  I have tried everything.  I unistalled the driver and now there is nothing for the volume driver. WHen i click on the driver it says the driver is working but yet it has the yellow mark saying it is not there.  I don't know what else to do but thanks.

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

Hello Vicki,

 

If possible, please let me know:

 

1.    the model of your computer;

2.    the KB number of the Windows update that possibly caused this problem;

3.    In Device Manager, what mark is with your video device?

4.    When right-clicking the item and select Properties, what is displayed in the Device Status in General tab.

 

Based on those answers, we will check what else we can assist.

 

Regards,

Lionel Chen

Microsoft Online Community Support

 

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

Hello,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

 

Regard,

Lionel Chen

Microsoft Online Community Support

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

First bulk catalog update for SMS 2003 SP3 set for Jan '08

 

Folks,

 

We are happy to announce the release date of our first bulk catalog update for Asset Intelligence 1.0 (SMS 2003 SP3).

 

This update includes several updated software titles (both Microsoft and 3^rd parties) as well as several fixes for data related bugs. The update will be available in the form of an MSI package, which will contain a wizard to walk you through the catalog update process. We will post this on the Microsoft website as a free download. You can expect to find this latest update on or before January 31st, 2008

 

Please note that a link to the download site will be provided in this post when the update goes live.

 

Notes:

1.       This update is specific to SMS 2003 SP3.

2.       An update for SCCM 2007 will be provided in SCCM 2007 SP1.

3.       Post SCCM 2007 SP1 updates will be provided via System Center Online (SA customers) and bulk updates (the rest of our customer base).

 

Reply:

Just a short update to let you know that we are on track for this release. We are currently wrapping up the final set of tests for this package and we will be able to post the update as promised (i.e. on or before 1/31/2008).

 

Again, this update is only designed for AI 1.0 (i.e. SMS 2003 SP1) and it will not work on SCCM 2007. We will update the SCCM 2007 catalog with SP1.

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

 

This download link will go live in about 48 hours:

http://www.microsoft.com/downloads/details.aspx?FamilyId=3653E00B-6A0F-4226-87D7-02D3DF2147D7&displaylang=en

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

Hi Dan

 

I have just installed the update on my site server but have encountered several errors in the log despite one of the earlier entries reporting '207189 rows affected'.  I have a number of the following entries.

 

Msg 170, Level 15, State 1, Server xxxxxxxx, Line 4

Line 4: Incorrect syntax near '('

 

Msg 1776, Level 16, State 1, Server xxxxxxxx, Line 1

There are no primary or candidate keys in the referenced table

'LU_Category' that match the referencing column list in the foreign

key 'LU_SoftwareList_Category_FK1'.

 

Msg 1750, Level 16, State 1, Server xxxxxxxxx, Line 1

Could not create restraint. See previous errors.

 

I do not have an entry to say that the installation operation was completed successfully.

 

 

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

I've seen these errors in the log on my side as well.  It does seem like the tables in SQL got updated, but I don't if the update was really successful.  I also got an error message when I tried to run the update again.  Something about the update that cannot be uninstalled.  Looks like once you ran the update you can't change it again.

 

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

Thanks folks, we are investigating and will post a follow-up solution as soon as we figure it out.

 

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

Please use this post to keep up-to-date or post any feedback (so we have a single point of contact to keep everyone up-to-date) --> http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2789734&SiteID=17

 

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

Here's the new link http://www.microsoft.com/downloads/details.aspx?FamilyID=3653e00b-6a0f-4226-87d7-02d3df2147d7&displaylang=en

 

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

Folks have been asking where to apply this update.

 

The short answer is on the central site and any other primary site the you or customer use for reporting purposes. In SMS 2003 SP3 we don't replicate these changes down the hierarchy.

 

We replicate any catalog updates in SCCM 2007 SP1 (see coming soon posts for more information on AI 1.5)

 

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

Just tried to install AICU.msi on the site server and got this error:

Internal Error:25001.80004005

 

Windows 2003 Server, SMS 2003 with SP3 installed and SQL 2000.

 

Any suggestions?

 

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

No replies from Microsoft on these errors?  I have not have much luck either.  My logfile has lines about number of rows affected but no success message and no total.  Cannot rerun the MSI either as it says that uninstall is not supported.

 

Is there supposed to be visible Asset Intelligence node in the MMC in SMS2003 or is that only for SCCM?

 

 

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

Only for Configuration Manager (and actually only for SP1) will you see an Asset Intelligence node. For SMS 2003 SP3, it is just sms_def.mof data and reports.

 

Dan was out this week, so I'm sure he'll be back on these questions when he comes back to the office.

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

Thanks, Wally - I'm back after being out sick for two weeks.

 

Folks, I saw this was already addressed and was caused by incorrect parameters. In you run into any issues during the update, please start a new thread on it, so it will be easy to track. Thanks for your patience and feedback.

 

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

Implementing a Lightweight Metaverse Search

Hi there,

 

if you are looking for a simple and supported method to do metaverse searches for troubleshooting, you should read our new document called "Implementing a Lightweight Metaverse Search".

We are happy to announce the release of this document to the download center.

Here is the link to the download center page.

 

For helping to drive the development of this document, I would like to extend a big thank you to  

·         Ahmad Abdel-wahed, Microsoft Corp.

·         David Conners, Microsoft Corp.

·         Bill Mathers, Microsoft Corp.

·         Joe Stepongzi, independent IdM specialist.

 

 

We welcome any feedback on this document.

Please feel free to post comments to this forum.

 

Also, if you have ideas for additional documentation topics, please don't hesitate to contact us!

 

Cheers,

Markus

 

///////////////////////////////////////////////////////////////////////
Markus Vilcinskas

Technical Writer
Microsoft Identity Integration Server
mailto:markvi@microsoft.com.NO_SPAM

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/copyright.htm
///////////////////////////////////////////////////////////////////////

Incorrect URL causes Reporting Services Printing to hang

 

Hi -

We recently solved the mystery of why reporting services printing was failing in our production web environment.Returning a report to the screen worke just fine but when we want to print it, it would sit for a while and then return the standard print error.

 

In our production web environment there are reverse proxies in the DMZ that direct requests thru the second firewall to protected zone in the internal network.   It is a routine thing to have the proxy translate an incoming request's domain name to a short host name.  It allows the same domain to be used for many applications across multiple servers and allows the each application to be setup as its own website.    An example would be   http://www.mydomain.com/app1/default.aspx    would be sent to the webserver as http://myhost/app1/default.aspx

 

Problem is that Reporting Services on the server side uses the domain name from the inbound request to create a URL that is embedded in script and sent back to the client to tell the RSClientPrint control where to get its data from.  And of course "myhost" is not a valid DNS or wins entry - its just a name in the hosts file of the proxy and the web server.

 

You cannot see the URL on the rendered pages, you need a tool like Wireshark (Ethereal) to trap the traffic either on the client or the server side.

Here is the pertinent line from the Wireshark trace:

 

...RSClientPrint.Print("http://dnrwwisard:80/wwisard/Reserved.ReportViewerWebControl.axd", "ReportSession=dlloysmt4j130lmoqlk5of45&ControlID=2bfa1b75-bbbb-4e72-b23a-01a77ce49e56&Culture=1033&UICulture=1033&ReportStack=1&OpType=PrintRequest", "WW - To-Do List")

 

While our preference would be to have the ability to tell the ReportViewer what domain to use,  (maybe in the next release?),  our solution was obvious.  We reconfigured the proxy and websites to use the domain name.

 

 

Hope this helps someone else shorten the search for resolution.

SQL Server 2008, February 2008 CTP

Download the February CTP here:
http://www.microsoft.com/sql/2008/prodinfo/download.mspx

 

Updated Books Online for February CTP are available here:
http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en

What's new in Reporting Services February CTP (compared to the previous November 2007 CTP):

• Support for Microsoft Word Rendering
  This allows users to render reports as Word documents that are compatible with Microsoft Word 2000 and greater.
   
• Data Visualization Enhancements
  Data Visualization Enhancements provides significantly improved support for Chart and adds support for Gauge controls directly within reports.  
   
• SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
  The SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2008 report rendering, processing and management capabilities in SharePoint Integrated mode.  This version includes Data-driven subscriptions.
   
• Report Design Enhancements in Business Intelligence Development Studio (BIDS)
  BIDS overall has been migrated from a Visual Studio 2005 to Visual Studio 2008 platform.  In addition, the report design tools found in BIDS were significantly updated for Reporting Services.  Updates include:
  - the more powerful Tablix based Tables, Lists, Matrices
  - the Report Data window for easier interaction with data fields
  - the integration of data visualization enhancements (Chart, Gauge)
  - new dialogs throughout the design experience
   
• Throughput Enhancements
  Further improvements in report rendering throughput, the number of reports rendered in a given amount of time for several types of workloads.

Enjoy!

 

We are looking forward to your feedback!

 

 

-- Robert

Reply:

Hi Robert,

 

I haven't tried the Feb CTP yet but could you confirm if there are any report scheduling improvements based on externally triggered events?

 

I had posted this in another post here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2851915&SiteID=1

 

Copied and pasted below:

 

Report Scheduling

Another thing which is possibly there in SSRS but I didn't see much about is triggering batch reports based on certain events in addition to the time-based calendar. This allows the batch reports to run when an external event is triggered. For example, you create an event on the report server called myVendorLoadEvent01. You then schedule 10 reports that you specify to run when this event is triggered. A separate process on the data warehouse receives some data from a vendor every morning (time varies) and after data mart update is complete, it calls the API/service to trigger the report server event called myVendorLoadEvent01. When this is done, the report server runs all the reports (you could specify how many can run concurrently) scheduled to run based on this event. This way they run only after the data update is complete!

 

It would be great if this feature to easily create "named non-time based events" is added to next CTP/release. Also, an easy way for any "authenticated external application" to trigger this event.

 

This would allow a batch of scheduled report to run and export/email data based on data availability or other needs rather than just depending on the time clock schedule.

 

The key here is making it easy. A report administrator should be able to easily create such custom events and they should be available to authenticated/authorized users to use if these users want to schedule their reports to run off-peak hours or when such events are triggered. These schedule reports can then export the report/data to network share or email to the users.

 

TIA.

 

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

Thank you for your feedback and suggestion. 

 

There is no change in Feb CTP in that particular area.  As you are probably aware however, you can achieve this with some amount of work already today in RS 2000/2005/2008, by manually firing a schedule (all RS schedules are created as SQL Agent jobs).  The tricky part though is to figure out the mapping between the job name (which is a Guid) and the RS schedule. 
So, I definitely agree we should make this scenario a lot easier and more customizable - a suggestion that is indeed on our radar for a future major release.

 

-- Robert

 

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

Thanks Robert. That would be awesome. I am looking forward to this feature. This will make report scheduling and delivery much more useful and easier to maintain.

When a batch of reports can be scheduled to run based on a named event which can be triggered via simple "authenticated" API/webservice calls and also manually (by an administrator/authenticated user) as needed, it gives much more flexibility than simple time based scheduling.

 

An administrator should also be able to allow certain users access to specific events (such as based on their department or job role) so that they can schedule these reports to run on the server based on such events.

 

One more thing that can be added as part of this process is a limit on how many scheduled reports can run concurrently to prevent server resource problems. So an administrator should be able to create a named event and specify how many reports can run concurrently based on this event.

 

So for example, if I create a named event called "Inventory update event" with cuncurrent report setting of 3 and schedule 10 reports to run based on this event or create a report group with 10 reports to run when this event is triggered, only 3 reports will run at a time and rest will be queued and then run as the ones from the first 3 are finished running.

 

One should be able to do all this easily without writing much custom code.

 

 

Thanks again.

 

-- Sanjeev

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

New Upgrade Assistant resource for Application Compatibility & Upgrade testing

 

Hi all,

On behalf of Scalability Experts, I'm excited to announce additional resources you can use to perform a tool-assisted upgrade testing process. This tool and process will hopefully enhance your results when upgrading your SQL Server 2005/2000 databases to SQL Server 2008. The tools work on upgrade to the CTP, and after the RTM is released they will work with RTM.

• Introducing both versions of the SQL Server Upgrade Assistant tool and methodology

Scalability Experts are stewards of the Upgrade Assistant tool and methodology. There exists two versions of the tool: the older version supports upgrades from SQL Server 2000 or 7.0 to SQL Server 2005. The newer version supports upgrades from SQL Server 2005 or 2000 to SQL Server 2008. The tool exercises the relational engine portions of your upgrade testing; you will still want to use other approaches to test upgrade of your Client Application Connectivity, Replication, Integration Services, Analysis Services, and Reporting Services based capabilities.

 

My colleagues and I from Scalability Experts participate in this forum and will help you the best we can to get your application compatibility and upgrade testing questions answered. We have been working with Microsoft SQL Dev closely for multiple releases and possess deep knowledge of SQL Server upgrade and application compatibility testing. Collectively, we have assisted hundreds of companies around the world – helping software vendors and customers upgrade their databases to SQL Server 2005 in the last release cycle, and helping dozens test their application upgrades to SQL Server 2008 CTP during the current release cycle. We will maintain an ongoing presence on this forum, looking to discuss questions and issues related to application compatibility testing and upgrade. We also welcome feedback and suggestions via Connect.

 

Our names are:

·        Keith Nicholson, Derek Comingore, Don Vilen, Rohit Sharma and Joe Yong

 

TIPS FOR QUICKEST QUESTION RESPONSE: To ensure your upgrade and application compatibility testing related questions are easily identifiable, we recommend:

1.      Prefix your post subject/tile with "APPCOMPAT:" followed by the specific question you have. This helps ensure the most expedient response from Scalability Experts SMEs.

2.      If you experienced an install/uninstall/upgrade or repair failure, include your logs (ALL OF THEM if possible but zip/rar them up first).

 

We hope this new Upgrade Assistant tool and methodology will help you in your upgrade testing efforts and improve your overall upgrade experience with SQL Server 2008.

The following are additional resources that may be useful to you in your upgrade and application compatibility testing.

·       Upgrade and Application Compatibility Blog
URL: (http://blog.scalabilityexperts.com/category/upgrade/)

·       SQL Server 2008 (Katmai) Setup and Upgrade Forum
URL: (http://forums.microsoft.com/MSDN/ShowForum.aspx?siteid=1&ForumID=1627&SiteID=1)

·       SQL Server (released versions) Setup & Upgrade Forum  
URL: (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1)

 

 

Regards,

Joe Yong 

Scalability Experts

Reply:

This Forum is probably an ideal place to discuss Application Compatibility issues, in addition to Setup & Upgrade issues. And if the outcome of the discussion causes you to desire an App Compat related product enhancement, you can visit the Microsoft Connect site to provide product suggestions.

 

There are many programs, events and resources available to different audiences to assist with upgrade efforts, including this Scalability Experts Upgrade Assistant tool and methodology just mentioned. There are several people at Microsoft who own various program aspects related to SQL Server Upgrade and Application Compatibility. These people are:

• Roger Doherty, Zach Owens, Kuleen Bharadwaj, Amy Lewis, Tamara Tan and Rebecca Laszlo

 

Roger, Zach, Kuleen, Amy, Tamara and I will periodically provide guidance on both technical and business related queries so you may leverage programs and resources you would find helpful. We are essentially subject matter experts about Microsoft-sponsored programs and activities and will do our best to highlight those which might interest you most.

-Rebecca Laszlo [MSFT]

 

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

Portuguese(Portugal) Version Select All (Ctrl+T) don't work

In Portuguese(Portugal) Version (pt-PT), we have a similar bug in "Select All", neither Ctrl+T (neither Ctrl+A) work.

But don't work in 6000, neither 6001.X neither this last build 6001.18000

Reply:

but Ctrl+X and Ctrl+C work very well.

Using 6001.18000

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

Ctrl+T works on some computers running Portuguese version of Vista Home Premium. I think it's a computer thing.... Those I've seen that don't work are HP's, it might be because of the personalized Windows install they have. In the other hand, used the shortcut on an Acer and it worked as it should.

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

BizTalk Adapter Pack Released

BizTalk® Adapter Pack Launches at Office Developers Conference

 

On Monday February 11th, we announced availability of the BizTalk® Adapter Pack at the Office Developer Conference.  The BizTalk® Adapter Pack provides a single solution to easily and securely connect to Line of Business (LOB) data from any custom-developed .NET application, SQL Server-based business intelligence solution, or an Office Business Application (OBA).  The three adapters available in this release are Siebel, SAP and Oracle DB.  

  

The BizTalk Adapter Pack will be generally available on March 1st.  Please contact your Microsoft representative for the pricing details. The Adapter Pack license is also included with BizTalk Server 2006 R2 Developer, Standard, and Enterprise editions. It is not included in the Branch edition. Customers that have already purchased BizTalk Server 2006 R2 with Software Assurance will also have access to the BizTalk Adapter Pack through the Software Assurance program. 

 

We also announced the BizTalk Adapter Pack: Office Developer Program.  This program provides participants with access to code, support and direct access to the product team for bug fixes and change requests.  By working with Office developers directly we will be validate additional Office/SharePoint scenarios. If you are interested in validating your SharePoint and Office scenarios, please visit the following site to register (note that you mean need to log in using Windows Live ID to access this site).

Key Benefits

·         Single infrastructure for connectivity.  Whether connecting to LOB systems from custom-developed applications, SQL Server, or rich Office applications, customers can use a consistent approach to connectivity.  This enables a simplified approach to interoperability that lowers total cost of ownership and reduces training requirements.

·         Simple to learn.  Built on top of the WCF programming model, the BizTalk® Adapter Pack is easy for .NET trained developer to begin using and building connected applications.  The BizTalk Adapter Pack provides enhanced extensions to WCF that enable dynamic metadata discovery and generation – making it fast and easy to access data in corporate systems. 

·         Secure and reliable.  The BizTalk Adapter Pack tightly integrates with the security models provided by the individual business applications, ensuring that users have access only to data which they are permitted to see. 

·         Improves real-time visibility to your business data.  The BizTalk® Adapter Pack allows customers to access valuable corporate information when and where they can use it most productively, increasing visibility and enabling faster, better informed decision making.

 

- The BizTalk Adapter Pack Team

Reply:

Does anyone knows when the candidate scenarios (especially MOSS 2007) will be released?

 

Thanks,

Roger

 

 

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

Imaging

Hello, Pretty new to Essentials..... is there any way you can image desktops using it?

Reply:

Hi,

 

I am not quiet sure what the word "image desktops using it" means? What the function of SCE you want to have on desktops?

 

 

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

Hi,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!
-----------------------------
Sincerely,
Guozhen Wang
Microsoft Online Community Support

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

Out-Of-Box Drivers not Show Drivers

 

Hello everyone, I need the help of you, my Deployment WorkBench not show the drivers, and terminating all time.

This log:

 

Faulting application mmc.exe, version 5.2.3790.3959, stamp 45d6a11d, faulting module kernel32.dll, version 5.2.3790.3959, stamp 45d70ad8, debug? 0, fault address 0x0000bee7.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Reply:

 

I don't think there is enough information there to determine the cause.  What are you doing when Workbench crashes? 

 

-Michael Niehaus

 Microsoft Deployment Toolkit 2008/BDD 2007 dev lead

 mniehaus@microsoft.com

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

 

Hi

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

 

Tim Quan - MSFT

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

Windows Vista Power Management

Hi All,

 

I recently bought Vista Home Premium.  My initial install was utilizing the Upgrade option and that didn't fare too well.  But, to be honest, I'm a power user, my program files were practically filling the screen on the start menu.

 

In any event, I recouped and went with a clean install.  Installation time was much less and the results much better.

 

Actually, I'm a pretty happy camper, the video and sound are just mind boggling.  And the clean install has my Visual Studio 2008 Pro humming.

 

One snafu, sleep mode.  It was causing the system to reboot when it emerged.  Today I came home and all was well.   I had adjusted the power settings to Performance Mode.  And now all appears well.

 

I don't know if this is a question or a comment, but I'm a programmer, and I rarely use sleep mode, because it interferes with utilizing the scheduled tasks.

 

In any event, The OS has a lot going for it.  This Aereo is really something.  I look forward to delving under the hood and seeing what I can find in the future.

 

Thanks,

 

John.

Flawed - SP1 a failure for the ordinary PC user

 

 

You can remove SP1 by using either Programs and Features or the command line. Note, however, that you cannot uninstall SP1 offline using any method

 

So did the genius who released to auto update  have any idea of what ordinary, non software/computer savvy people are going to do when the upgrade nukes their internet connection?

 

If so would it be to much trouble for that genius to tell Microsofts own technical people how to fix it.

 

Because after over 8 hours on the phone to both MS tech support and my ISP tech support (costing £1 a minute) I still have no internet access.  It took over 3 hours of arguing before MS support would even recognise thet SP1 had mistakenly nuked my copy of Vista home premium tagging it non-genuine and not allowing me to validate.

 

Now all you on here may be technical bods, and a small issue like losing your prime source of income for a day due to an unprofessionaly released flawed update may be a bit of an adventure, sorting out the glitches may even be a source of fun. But for the vast majority of PC users we have no knowledge of what happens behind the keyboard, and trust the manufacturer to only automaticaly download to our PC's stuff that isnt broken.

 

Of course we do have system restore, but there is the mnor issue in that you cannot restore back past the instalation of SP1, Another great brainwave..

 

so we cant uninstall, cant roll back, cant use our PC's ....

 

Good service pack MS great job  if your going to screw something up do it well and make sure that it cant be simply undone</ends sarcasm mode>

 

This release isnt just flawed, it is for the ordinary computer user a complete and utter nightmare.

 

 

Sp1

 

I hate to sound like a sycophant but I've just installed Sp1 on two very different machines and the result was the same.  An apparent speed boost of around 50%.

 

Now this might just be my imagination, running away with me, but everything seems more responsive and I can't click quickly enough to keep up with the system.  Have Microsoft got it right?

 

Ok I'll shut up now (waits for flames...)

Prv Bld for new known issue with correlating Batch with AS2 with EDI with BizMetaData

In BTS2006 R2, while attempting to send AS2 session with EDI content via Batch mode of o/b transmission, using underlying BAM architecture for end-to-end message tracking, realized that records inserted into standard MS activities / views in DB BAMPrimaryImport were insufficient for correlating Batch with AS2 session with EDI envelope with BizMetaData (eg: PO# for EDI 850 o/b,  Invoice# for EDI 810 o/b, etc...).  This is because of a missing record in table bam_AS2InterchangeActivity_Completed in batch mode of o/b transmission whereas a record is in fact inserted in real-time mode of o/b transmission.  MS has sent us a Prv Bld which resolved this issue, and could release a official hot fix soon (after completing their internal approval process).

Pre-Requisites for being a Moderator

Are there any?

 

I ask because I was just in the Vista Setup section of the forums and noticed a moderator telling a poster that if they do not want to enter passwords when they switch users they should blank the passwords out for the 2 affected users.

 

Do you have any idea how counter-productive that is?

 

In a day and age where ID Theft is becoming more and more frequent, that moderator needs to excercise a little better judgement when dealing with situations like this...

 

 

Microsoft user research study requesting participants!

Microsoft User Research is inviting IT professionals in the contiguous US to participate in a user research study.  We are looking to learn from those who perform IT services for their company; such as routine server maintenance tasks, various levels of troubleshooting, daily server, network or desktop management, and the planning and implementation of technology.  We want to meet at your office to learn from you, the experts, so that we can determine what needs to be improved in our software.  This gives you the chance to tell us what your needs are and meet with some members of our product team.  We highly value your feedback and will be offering Microsoft software in appreciation of your time and participation.  If this is something that you or others at your company would be interested in, please reply to ms_sitev@microsoft.com at your earliest convenience.  We are scheduling site visits to start in mid-April.

SP1- Fails spectactularly

 

downloaded the service pack last night booted up this morning  to find my legit version of Vista home premium was considered dodgy, 3 hours of phone calls , a lot of quite hard pushing to get passed the customer service reps and actually get to talk to a tech support and then a lot of keyboard pressing by this complete computer dunce, at the direction of Microsoft tech support and we finally get the activation to rework.

 

Then I cant get  on-line Vista will not identify a network or connection, 5 hours later after long calls to my ISP tech support (at a £1 a minute)  and another 3 hours with microsoft technical support, I am being refered to Microsoft research team, who will try to call tomorrow.

 

You cant uninstall SP1 off line, and SP1 removes all restore points created before its installation, so you cant roll back when it screws up your ability to connect  to the web

 

So I am using my laptop, who would have thought in the early days of XP we would be grateful for its stability

 

 

 

 

Query Performance Tuning topic in BOL, is there a mistake?

(1) Topic referred http://msdn2.microsoft.com/en-us/library/ms172984(SQL.100).aspx,

 

A tried out the next Index sample showed above:

Code Snippet
CREATE INDEX Emp_Name ON Employees ("Last Name" ASC, "First Name" ASC)
 
 
 With northdwind.sdf (3.5) sample database. After created, I've executed the follow selects:

Code Snippet
-- SELECT A
SELECT DISTINCT [Last Name], [First Name] FROM Employees;
-- SELECT B

SELECT DISTINCT [First Name], [Last Name] FROM Employees;
-- SELECT C
SELECT DISTINCT [Last Name] FROM Employees;
-- SELECT D
SELECT DISTINCT [First Name] FROM Employees;
 
 

Including actual execution plan in SQL Server Management Studio. I noticed that Select A,B,C begins with index scan on Emp_Name and Select D doesn't.

 

(I screenshoted it)

 

This topic (1) say:

 

For a DISTINCT operation to consider a multiple-column index, the projection list must match all index columns, although they do not have to be in the exact order. The previous index can help optimize the following queries:

... DISTINCT "Last Name", "First Name" ...

... DISTINCT "First Name", "Last Name" ...

It will not help optimize:

... DISTINCT "First Name" ...

... DISTINCT "Last Name" ...

 

It should say:

 

For a DISTINCT operation to consider a multiple-column index, the projection list must match all index columns, although they do not have to be in the exact order, or could match the first one. The previous index can help optimize the following queries:

... DISTINCT "Last Name", "First Name" ...

... DISTINCT "First Name", "Last Name" ...

... DISTINCT "Last Name" ...

It will not help optimize:

... DISTINCT "First Name" ...

 

Am I wrong?? or actually is there a mistake in BOL, Query Performance Tuning topic (1)??

 

regards,,,

Transfer Binary Data (image data type) with XML

 

Transfer Binary Data (image data type) with XML

 

 

I try to transfer binary data ( it's Image data type) with XML but in destination when I convert  xml into my table every data type is fine except of image (image data type).

please look at below T-SQL code , I try to convert Data into XML then again convert xml into a table as normal data and it works fine for every thing except of image data type.

 

 

-- a sample for transfer binary data with XML

declare @Source as table ( ID int

, myDate smallDateTime

, Credit decimal(10, 3)

, name varchar(20)

, myData image

)

insert into @Source

(ID , myDate , Credit , name , myData )

values (25 , getdate() , 28.258 , 'Farzad Jalali' , 0x00ffee2345 )

insert into @Source

(ID , myDate , Credit , name , myData )

values (26 , getdate() , 35.671 , 'Chris Evans' , 0x004575F4B212EBA3467E43A376EC3)

declare @XMLString as xml

-- select * from @source

 

set @XMLString = (select * from @source for xml path('Customer') , root('myList') )

 

 

-- select @XMLString

-- we are going to convert xml to normal data and insert into a table

declare @Destination as table ( ID int

, myDate smallDateTime

, Credit decimal(10, 3)

, name varchar(20)

, myData image

)

 

DECLARE @idoc INT

EXEC sp_xml_preparedocument @idoc OUTPUT, @XMLString

 

insert into @Destination

SELECT ID

, myDate

, Credit

, name

, myData

FROM OPENXML (@idoc, '/myList/Customer', 2)

WITH ( ID int

, myDate smallDateTime

, Credit decimal(10, 3)

, name varchar(20)

, myData image

)

-- select * from @Destination

select * from @source

select * from @Destination

 

Reply:

 

See this http://www.xml.com/pub/a/98/07/binary/binary.html that talks about workaround on using Binary data with XML.

http://www.topxml.com/xml/articles/binary/XML%20and%20Binary%20Data2.asp one too

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

 

Hi  Satya SKJ ,

 

Thanks for links , I read them and they are close but Can you fix the above T-SQL code to works fine in SQL 2005 (or 2008) ?

 

* I look at database ( in this case SQL Server but what ever SQL server or Oracle or DB2 or mySQL) as a black box that should deal with my data and return same data that I passed into it. In my case as veiw of my application when my application send a recored like (25 , getdate() , 28.258 , 'Farzad Jalali' , 0x00ffee2345 )

into database then when database try to transfer data as xml  (via biztalk server or any thing else) to another server , it suppose to return same data exactly like   (25 , getdate() , 28.258 , 'Farzad Jalali' , 0x00ffee2345 ) to my application.

 

* Do you think maybe microsoft provide an special way for transfer image data type with XML ? ( I mean something except of that way that I used in above code)

 

 

* if SQL Server can't keep data safe in duration of a simple operation like dealing with xml (  inside of SQL server) , I really really affraid to call it database  .

 

 

 

Thanks again for link , they don't have a solution for this problem of SQL Server but I really enjoyed to read them. 

frzJalali

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

Everbody before installing Windows Vista Sp1

Before installing windows vista sp1 everbody just do a clean install of vista before installing vista sp1 it could work or not work but try that first before posting on here it could help and reformat the pc not just delete OS and call that reformat do a clean install everbody.

 

P.S.

If anybody is using nvidia video cards vista is not going to work for them ATI video card work on vista i have no problems with it when i am using my ATI card so what ever MS did for ATI is a good job. I also have a nvidia video card and it calls a lot problems for me it half to be the drivers for it thats calling the problems for nvidia because i was always getting bsod all the time for it.   

Reply:

woot - if that's the case ima make my vista think it has sp1 lol but I think this is a big fat lie... lol

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

What a load of tosh, do you really think people are gonna follow that ***.

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

bluetooth

My bluetooth is not woking and its made by .......wait .....wait

 

 

 

 

 

 

Microsoft haha Vista is *** and microsoft the game is up

Reply:

Hello,

 

If you're still looking for a solution for this issue, let me know the model of your Bluetooth device and more details about the problem.

 

Regards,

Lionel Chen

Microsoft Online Community Support

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

Hi,

 

As this thread has been quiet for a while we will be changing the issue type to 'Comment'.

 

If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.

 

If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.

 

Thanks!

 

Regards,

Lionel Chen

Microsoft Online Community Support

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

Vista SP1 error 80041315

With McAffee security centre (virus and firewall) Error 80014315 when installing Vista SP1 (100% complete and then roll back) including remaining error with miniport. After removing McAffee completely, SP1 installed flawlessly and the miniport was gone as well. Hence uninstall (remove) McAffee security centre prior to installing SP1.

Warning if You Have Creative X-Fi

I tried to install SP1 via Win update today.  The system blue-screened everytime it attempted to reboot.  I started it in Safe mode, but that only allowed SP1 to continue running.  Finally when it was done, Windows reported that SP1 was not installed and attempted to revert to the old code.  After watching it churn for a while, I became bored with the whole thing and loaded a clean Ghost image.  I visited Creative's web site and discovered they recently posted a new X_Fi driver dated 3-14-08.  The first fix it mentioned was a correction of issues with 4GB of memory -- which I have. I read no further and updated the driver.  I revisted Win Update and installed SP1 in about 20 minutes with absolutely no problems.

 

I frequently check for new sound and video drivers and checked Creative last week.  I guess the moral of this story is I should check five minutes before I attempt to load a Service Pack.  By the way, Creative has a driver for XP to correct the same 4GB issue.    

Microsoft spokesperson gives info about Win Xp SP3 Build 5503 : Don't use it!!!

Here's an excerpt from this article about Win XP Sp3 Build 5503 which is said to be from an actual Microsoft person

http://www.crn.com/software/206904757 :

 

"A Microsoft spokesperson, perhaps weary from the months-long barrage of Vista SP1 related inquiries, said the final version of XP SP3 is still on target to be released the first half of calendar year 2008, and the XP SP3 5503 build was a minor interim build released to address one specific issue for a subset of private beta testers.

"This build was not intended for public release, and anyone who has that build and is not part of the private beta is working with bits that Microsoft can't verify the integrity -- it's possible the bits may have been modified with malware or other bad code that Microsoft hasn't tested," the spokesperson said in an email." "

 

 

Reply:

WinUser42 wrote:

Here's an excerpt from this article about Win XP Sp3 Build 5503 which is said to be from an actual Microsoft person http://www.crn.com/software/206904757 :   "A Microsoft spokesperson, perhaps weary from the months-long barrage of Vista SP1 related inquiries, said the final version of XP SP3 is still on target to be released the first half of calendar year 2008, and the XP SP3 5503 build was a minor interim build released to address one specific issue for a subset of private beta testers. "This build was not intended for public release, and anyone who has that build and is not part of the private beta is working with bits that Microsoft can't verify the integrity -- it's possible the bits may have been modified with malware or other bad code that Microsoft hasn't tested," the spokesperson said in an email." "

 

WinUser42,

 

You're unlikely to get a confirmation or official words from SP3 developers/Microsoft regarding leak versions of SP3 later builds. What the spokesperson said is correct though, "it's possible the bits may have been modified with malware or other bad code that Microsoft hasn't tested".

 

Regards,

Thomas

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

Multi-platform migrations to Exchange

If you are planning a migration to Microsoft Exchange from Novell GroupWise, Lotus Notes, Scalix or any IMAP complaint mail platform, take a look at the GeM Solutions Email Shuttle.  Our tool can migrate mail, calendar, contacts and tasks from a variety of mail platforms and have been in the email migration business for over 8 years.

Find out more at http://www.gem-si.com.  Thank you.