Tag | server Posts

Problem As the DBA, you need to determine if there are any databases in your production environment which have not had a full backup in the last 24 hours. In this tip we cover the step by step process for setting up a policy to identify all the databases which are not backed up in the last 24 hours. Solution Database Administrators can use Policy Based Management (PBM) to identify databases which have not backed up in the last 24 hours. You can follow the below steps to create and evaluate the policy. ...
Features A SharePoint feature is a collection of SharePoint elements that can help to accomplish a particular functionality. Features reduce the complexity involved in making simple site customizations, and are robust when upgrades are applied to a deployment.Definition of a site or a template can be easily transformed by simply toggling a particular Feature on or off in the user interface. For example :- Publishing features of MOSS provide all the required functionality like publishing layouts, ...
Any ramblings and blog posts associated with the UNISA ICT 2622 tag should be considered study notes for my lectures… Objectives of Chapter 17 Explain the foundations for the adaptive development methodologies List and describe the features of the Unified Process system development methodology List and describe the features of Agile Modelling Compare and contrast the features of Extreme Programming and Scrum development Explain the importance of Model-Driven Architecture on enterprise-level development ...
Any ramblings and blog posts associated with the UNISA ICT 2621 tag should be considered study notes for my lectures… Objectives of Chapter 9 Discuss the issues related to managing and coordinating the activities of the SDLC Explain the major components and levels of design Describe each major design activity Develop a simple network diagram Describe common deployment environments and matching application architectures Key Words & Definitions architectural design – broad design of the overall ...
Microsoft has recently been informed of a security vulnerability in ASP.NET and they have a fix for it. Please see ScottGu’s blog post for details: http://weblogs.asp.net/scot... In addition to providing a work-around for developers, they also have a script to run on the server to find non-compliant Web sites. Joe ...
It's been a long time... I am very busy in my new project in Switzerland. Zürich is great! :-) On one of our testing-environments the EventViewer of BTS Admin Console suddenly didn't show events anymore. All categories (Application, System, etc.) were just blank. The EventViewer of Windows Server 2008 still worked but I prefer the one in BTS as it is much faster. It took me a bit to find out what happend. Someone had connected the EventViewer to another computer. The caption still said "Classic Event ...
Any ramblings and blog posts associated with the UNISA ICT 2622 tag should be considered study notes for my lectures... Objectives of Chapter 14 Describe the difference between user interfaces and system interfaces. Explain why the user interface is the system to the users Discuss the importance of the three principles of user-centred design Describe the historical development of the field of human-computer interaction (HCI) Describe the three metaphors of human-computer interaction Discuss how visibility ...
*Moved to: Team Foundation Server 2010 Event Handling with SubscribersThere is a lot of references and blog posts on how to handle SOAP events raised by Team Foundation Server 2005, 2008 and 2010 but is there anything new in 2010 that supersedes this? Even though I knew it was there, n o amount of google-fu brought back any results relevant to anything new, so hopefully this will fill that gap. Read more...Follow my new blog on http://blog.hinshelwood.com ...
Sorry for not posting on a more regular basis, but we were migrating a server for a local police department. Overall it went well except for the an issue between Symantec anti-virus and the main application that the officers use for their ticketing system. One hard lesson we learned was that if SBS 2008 takes an hour to boot up with lots of Exchange errors, it isnt exchange but rather that IPv6 had been uninstalled by accident. Thanks to a Technet article we found, this was resolved with just a few ...
smtp4dev is a greate smtp server that listens for smtp traffic and displays the emails sent, but it doesn't send the emails (you can see them, but they don't are received). I use this tool to tests and debugging, it's really good ;) Download: http://smtp4dev.codeplex.co... ...
Model Functionality · Support for Enums for property types from lookup tables · Allow default date = DateTime.Now - The only way to set a default date in the entity data model is to put a hard date in there, a string. If you have a known default date (e.g. 1900-01-01) this is fine. But often we want NOW to be the default and there's no way to indicate that in the model. · Support for System.IO.Stream instead of Byte[] for varbinary type of fields · Support GUID as Entity Key -http://leedumond.com/blog/... ...
Integrate RIA and Data Services why do we need 2 high level service abstractions? DataSources · Aggregate and expose entities from multiple sources including other RIA / Data Services OData · Navigation Properties on Derived Types · Any / All LINQ Operators · OData Binary Serialization Format - Provide support for a binary wire format (to supplement JSON/ATOM). · Containment / Hierarchical Models - If I have a schema that has Orders and OrderDetails, I dont want /OrderDetails to be direclty accessible. ...
Merge Wpf and Silverlight to single framework · Merge both frameworks to use the same assemblies and controls (with optional functionality in separate assemblies) make a .net silverlight profile that would be a subset of .net client profile and used by partially trusted xaps. · Conditional compilation within Xaml - stopgap solution: for Silverlight/WPF differences in shared markup. · Support the direct hosting of Silverlight – stopgap solution: support the direct hosting of Silverlight in a WPF application ...
I can't pass up passing this along even though it's not Silverlight or WP7 or Lightswitch or ... One thing I've been dealing with is the 'Edit top 200' rows thing in SQL Server 2008, and have just been dealing with it for a few weeks since I uninstalled everything else in favor of this full-up. Well, Senthil Kumar has instructions on how to modify that sucker... I didn't even *think* to look around... figured it was baked in... awesome post, Senthil! SQL Server 2008 – Change Edit Top 200 Rows and ...
New KnowledgeBase article "No Microsoft Message Queuing 4.0 components are enabled after you use the Turn Windows features on or off wizard in Windows Vista" The user interface rules for the "Turn Windows features on or off" part of the Control Panel do not seem to have been followed for enabling MSMQ. Here is the screen before you decide to install MSMQ. As expected the box next to "Microsoft Message Queue (MSMQ) Server" is empty: Now click on the box to select MSMQ and you get this: Tradition would ...
There's a KB article for MSMQ 4.0: 935498 A Message Queuing 4.0-based server runs in Workgroup mode after you install the Message Queuing Active Directory Domain Services Integration feature This problem may take you by surprise as it's not how previous versions worked. In the past a reinstallation of MSMQ in Active Directory Integrated Mode would go as follows: MSMQ installed first time MSMQ object is created under the computer object in AD MSMQ uninstalled MSMQ object is deleted from AD MSMQ installed ...
A few companies pack huge amounts of useful information into their queue names so that it is very easy to work out what each queue is for. A downside of this is that some Windows applications inconsistently display the queue names. Take the following sample public and private queues I created for test, each 70 characters in length: Performance Monitor can only display 64 characters for the MSMQ queue object which includes the computer name (and "\private$" for private queues) as documented here: ...
First, before going into preventing duplicate messages, we need to investigate where they come from. In most cases there is a problem getting data from A to B which results in messages being resent and therefore potentially delivered muliple times. For example, if there is a complicated/unreliable system of routers (and multiple paths) between sender and receiver, you could see the following happen: Message is sent down route A A network bottleneck appears for some reason so message is delayed en ...
There are several ways of load balancing MSMQ with varying levels of support and efficiency, including: A hardware load balancer (load-balancing on the wire) DNS Round Robin (load-balancing at the outgoing queue) Software-implemented Round Robin (load-balancing within the sending application) Hardware load balancing This KB article covers MSMQ and hardware load balancing very well: 899611 How Message Queuing can function over Network Load Balancing (NLB) Basically use NLB for sending non-transactional ...
I get this question now and then from customers who think it will help them work out how many servers they need for their clients. To me it sounds like "How many people can you fit in a Mini?" - although you can probably fit 21 people into one, the car is no longer any use as a transportation device. For MSMQ, if the theoretical limit was 1,000,000 (for argument's sake) you wouldn't want that many clients as the poor server would have been dragged to its knees long before then. But luckily there ...
MSMQ is a protocol that can benefit from the odd tweak to the registry. Unfortunately it is not always obvious what you can change to improve performance so I've tried to pull together the various sources of documentation. The first place to look is the Resource Kit Registry Reference which is pretty comprehensive. The Windows 2003 version is here but is dated "March 28, 2003" so doesn't include any new registry values introduced through hotfixes. Also, not every registry value is included for whatever ...
Due to the decision to exclude MSMQ from Windows XP Home edition, there is obviously a question over what Microsoft has done in Windows Vista. Way back in time a tiny note was put in Windows XP's Read1st.txt (which no-one reads): 3.3.1 Message Queuing ---------------------------... Products: Windows XP Home Edition only Message Queuing is not supported on Windows XP Home Edition. If you are upgrading from Windows 95, Windows 98, or Windows Millennium Edition ...
With lots of customers developing systems that use MSMQ across WANs, I find that I get a number of calls on problems getting messages through. Usually sending messages works a treat but pulling them back again doesn't. The main reason for this is the tightening up of MSMQ's use of RPC as documented in the Message Queuing security overview. The "Secured remote read" feature will need to be tweaked if you plan to work across forest boundaries - even if you don't, this problem can appear in development ...
MSMQ is a very robust product and people expect it to be able to look after data no matter what. To test that it does, customers can perform scary tests like hitting the power switch while the server is running. Obviously a power cut is a real-world event and customers should not expect to lose messages (which usually also means losing money) when one occurs. Surprisingly messages DO disappear and customers rise up to condemn MSMQ's transactional robustness. But you need to dig deeper to find out ...
For those that didn’t know, I have recently left a long run at Thomson Reuters (which is a great company BTW) for a new gig as CIO of Swank Motion Pictures. This company works in the movie distribution business to cruise ships, trains, universities, and more. Some links if you are interested: http://www.onboardmovies.com/ http://www.swank.com/colleg... https://www.swankhealth.com http://www.k12digitalmovies... http://www.swank.com/digita... and more more more …. The thing is that ...
If you’ve configured PDF for Search in SharePoint 2007 then you are certainly almost there in getting it to work with SharePoint 2010. The process is almost identical with some minor changes due to service name change and directory changes. Below are the steps to get iFilter working and configuring pdf files search in a SharePoint 2010 IFilter Install 1. Download PDF iFilter 9.0 for x64 platforms http://www.adobe.com/suppor... 2. Stop the IIS Admin Services by issuing ...
We recently switched over a client’s small infrastructure to Small Business Server 2008. SBS 2008 has SQL 2008 and Exchange 2007 imbedded. The customer wanted to keep the same internal and external FQDN names used previously with Exchange 2003. I had them purchase a SAN certificate with all the standard names in an Exchange 2007 or 2010 environment. We installed the certificate, made sure everything was set in both internal and external DNS, and started setting up clients. Webmail and Active-Sync ...
In a ASP.Net web app I have a button that says "Process". It will spawn a new worker thread that will look at a network share and process some Excel files that have been produced by a third party system. To access the share and to use the Excel COM interop, I am impersonating an elevated user account different than the authenticated user, using Windows Impersonation. I then generate an Excel COM object for each Excel file, and process the files available in the network share. Today I noticed that ...
Luckily this isn't difficult. The address needs to be modified just like using Internet Explorer to browse a web site that's listening on a different port so just insert the port number after the server name. For example, here's the address where the destination web service is listening on port 8080: DIRECT=HTTP://MyWebServer:8... ...
If you are sending messages over HTTP then there is a chance you may be behind a proxy server which prevents you making a direct connection to the destination server. This is no big deal - Internet-enabled products such as Internet Explorer and MSMQ always check for any proxy settings so they know how to get out onto the Web. Specifically they check: HKEY_LOCAL_MACHINE\SOFTWARE... Settings\Connections\WinHtt... If you have MSMQ messages in an outgoing ...
This sounds obvious but make sure port 80 is open on the firewalls and routers between sender and receiver. It's easy to get bogged down in trying to work out why MSMQ isn't sending, such as checking if acknowledgements are getting lost and so on. In this case take a step back and look at what you're trying to do - POST data over the HTTP protocol. If the messages are stuck in the outgoing queue and nothing at all shows up in the web logs on the server then try a simple test - browse the destination ...
Another KB article has been published for MSMQ over HTTP: 941754 Incoming messages may be rejected by the queue manager on the cluster after you configure the clustered instance of Message Queuing to use HTTP messaging in Windows Server 2008 The principle here is that MSMQ does a reverse lookup on the IP address to find the computer name - if the lookup fails then MSMQ isn't happy. This is similar to a previous blog where the lookup returned the wrong computer name from a HOSTS file. I'm not sure ...
I'm again writing about MSMQ failing to send messages over HTTPS. One quick test that people use to check that the certificate is OK is to browse the server over SSL with Internet Explorer. usually this will work and the problem will then be assumed one of MSMQ's making. Unfortunately it is not as simple as that as there are multiple certificate stores available on the machine. Internet Explorer takes certificates from both the "Current User" and "Local Computer" personal stores but MSMQ only makes ...
Here's a solution discovered by Andreas Naranjo which is worth adding to my long-running "MSMQ messages using HTTP just won't get delivered" series. When trying to send an MSMQ HTTPS message from a Windows Server 2003 machine to another, the messages are stuck in the sender's Outgoing queue and the queue status says "Waiting to Connect." HTTP messages go through just fine but HTTPS messages are stuck. The problem can be with the Root Certificate Authority (CA) not being installed and trusted on the ...
This post refers to the situation where a client is sending MSMQ messages over HTTP to a receiving server hidden behind a firewall. The messages will be stuck in the Outgoing Queue with a state that switches between "Inactive" and "Waiting to Connect." If you collect a Network Monitor trace then you should see that the server replied to the message from the client with a response of "HTTP 400 - Bad Request" without including a body in the response. If you had a PSS engineer format the MSMQLOG.BIN ...
I thought for completeness that I would go through some of the KnowledgeBase articles that document problems sending MSMQ messages over HTTP. 883474 Large messages that are sent over an HTTP session may not leave the outgoing queue Basically an HTTP Response must come back from the web server within a certain time or the message will be rejected and redelivery must be attempted. Unfortunately the article doesn't say what the default timeout is. The workaround is to add the HttpResponseTimeout registry ...
The following KB article isn't anything new (it's been out a few years) 889859 Messages that you try to send over HTTPS may remain in the outgoing message queue in Message Queuing 3.0 but a customer asked me why the Certificate Revocation List could not be found so I looked into it. The cause of the problem documented in the KB is: "This problem may occur if Message Queuing 3.0 cannot reach the location of the certificate revocation list (CRL) that is specified in the properties of the certificate. ...
Here's another "MSMQ messages wouldn't leave the outgoing queue" problem that a customer reported. The root cause was an entry in the HOSTS file from an ancient project the machine had been used for in a previous life: 127.0.0.1 localhost 10.12.4.7 intranet To process the HTTP request, the MQISE component makes an RPC call to itself. To do this, it makes a reverse lookup to determine who it is but here it failed as it could not contact the machine called "intranet". Solution was to delete the invalid ...
There is an interesting MSMQ 4.0 problem highlighted in the following KB article: 936502 A message is not received when you use the HTTP protocol to send the message from a Message Queuing client to a Message Queuing 4.0-based server http://support.microsoft.co... Basically, don't put ".SVC" in your queue names as otherwise IIS will get confused IF you have chosen WCF activation: The handlers for Windows Communication Foundation (WCF) are looking for this file extension ...
After a long while trying to work out what was going wrong with another customer's system, I finally cracked it. There were two servers and we could send messages between them in one direction but not the other. Messages would happily go into the outgoing queue and then disappear. The first place I looked was in the IIS logs on the receiving machine - the web service is the first place that the message will reach so we need to check if the POST request is getting through. 2006-10-05 12:55:49 W3SVC1 ...
Here’s an unusual problem that you shouldn't expect to bump into and the solution is potentially painful. Scenario You want to make use of the HTTP protocol to send MSMQ messages from one machine to another. You have installed HTTP support for MSMQ and have addressed your messages correctly but they will not leave the outgoing queue. There is no configuration for HTTP support - setup has already done all that for you (although you may want to check the most recent "Installation of the MSMQ HTTP Support ...
For those who haven’t come across it, PowerPivot is Microsoft’s Excel- and SharePoint-based self-service BI tool. Essentially, it allows power users to build their own SQL Server Analysis Services cubes, except that they don’t need to be familiar with cube concepts and they won’t even notice that SSAS is involved. The other exception from the Microsoft BI norm is that these cubes use a new columnar, in-memory storage engine, called VertiPaq, rather than Analysis Services’ traditional MOLAP (Multidimensional ...
If you don't have the Visual Studio IDE to work with, you can go the old fashioned route with issuing PRINT statements. If you do have the Visual Studio IDE available, execute the following steps: open visual studio navigate to server explorer create/open a connection to your database right click on the stored proc you want to work with and choose "Step into stored procedure" For more details, or for a more visual example with the instructions, navigate to this url: http://www.dotnetfunda.com/... ...
New standard the UDDI was announced several years ago [see the history in Wikipedia]. The UDDI future was promising. I was sure for that. I thought, the future is for Web-services [WS], and it is. Isn't that mean, we need services to search Web-services in internet, some Registries/Catalogs of the Web-services? How we could find the WS in internet? Google Search was not effective in this; it is still not effective now. By any means, the UDDI idea should win; all WS-s should work with UDDI Registries. ...
I recently got the following errors when starting Enterprise Single Sign-On on a pre-production BizTalk Server: The SSO service failed to start. Error Code: 0x80131700 The first error gives two suggestions on how to fix this error. The first suggestion is to reinstall SSO. I tried a repair which did not do the job so what about a full re-install? Unfortunately I could not uninstall Enterprise Single Sign-On due it being used by other programs (BizTalk anyone?). The second suggestion is to run regasm ...
Windows Live has had many lives. It started as a single page at www.live.com, where you could set up various widgets in a tiled configuration. The widgets mostly consumed RSS feeds and the idea was that you could have a home page where the content updated dynamically; i.e. where the content was “live.” I remember when the service was still in Beta and called Start.com; Robert Scoble, then a Microsoft employee, was hawking it pretty hard. It was kind of cool for its time, but it petered out, as did ...
Many times, especially during development, you could have certificates that are out of date, aren’t singed by any real authority (makecert, etc.), or even don’t match the host name that the request is issued against, but you want to test, etc. One example is if you want to run Fiddler to get a good over-the-wire trace of the HTTP traffic, when the endpoint is accessed over HTTPS. With Fiddler, you can capture HTTPS traffic, only thing is, it sticks it’s own certificate in the chain which doesn't ...
I’ve been using a utility for the last couple of years that organizes my desktop – Stardock Fences – and I was going to write up a review saying how cool and useful it is. However, others have already done that here and here (and many more via Google). So instead of rehashing those reviews, I’ll just say this: I find that the hiding icons feature and the screen resize features are great when I’m using my laptop for presentations. I’ve used this utility on Windows XP, Windows Server 2003 R2, and Windows ...
Thanks to everyone who attended the “Flip on LightSwitch!” at the Kansas City Office Geeks User Group last night! Lots of great questions and interaction from the group! As promised, here are the resources we talked about: First, you need a place to play with LightSwitch. As it is beta, a vpc is always a good idea. Currently there are three flavors of the Visual Studio 2010 Ultimate VPC: Microsoft® Visual Studio® 2010 and Team Foundation Server® 2010 RTM virtual machine for Microsoft® Virtual PC ...
Nationwide, the world’s largest building society realised the benefits of Faster Payments with the help of Microsoft Services and interestingly enough a team of BizTalk experts from Solidsoft. For a number of years Solidsoft has provided senior software consultants expert in Microsoft BizTalk server and many other Microsoft products support of Microsoft Service led developments. The Nationwide project has proved no different with Solidsoft providing a team of 6 to support the successful development ...