September WARDY IT Community Dinner

The WARDY IT Community Dinner is held on the second Monday of the month and is a great opportunity to share knowledge, information and experiences with other IT professionals in South East Queensland.  The September WARDY IT Community Dinner is being held on Monday the 11th of September.  To RSVP to be at this event send an email to peter @ wardyit.com.

WHERE Thai Mali | 82 Bennetts Road | Camp Hill | http://www.thaimali.com.au/
WHEN Monday 11th September | 6:30PM
RSVP Friday 8th September
Please note that you are responsible for the cost of your own dining.

Add this event to your Outlook Calendar

The remote name could not be resolved (Microsoft.SqlServer.Management.UI.RSClient)

When connecting to Reporting Services through SQL Server Management Studio (SSMS) you may receive the error:

The remote name could not be resolved: xxx (Microsoft.SqlServer.Management.UI.RSClient).

This error may be caused as a result of modifying the machine name.

In order to resolve the error you need to ensure that the element http://localhost/reportserver in the rsreportserver.config is configured to the correct computer name.

By default the rsreportserver.config file is in the directory C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\.

For more details regarding this error refer to the following thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=256312&SiteID=1.

SQL Server Standard Article

I have just received the following email from Editorial Services for the SQL Server Standard Magazine:

I just signed off on the Sept./Oct. issue of Standard which your article will appear in.

So look out for the September/October edition of SQL Server Standard where my article on SQL Server Management Objects (SMO) will appear.  The article is titled How to Make the Impossible Possible.

SQL Server on Vista and Longhorn

Microsoft has recently made the following announcement regarding the support of SQL Server on Windows Vista and “Longhorn” http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx.  Basically earlier versions of SQL Server, including SQL Server 2000, SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server “Longhorn” or Windows Vista.  So this is just one more reason to start thinking about moving to SQL Server 2005 and for any new development to be performed on SQL Server 2005.

Melbourne and Canberra SIG Resources

Over the last two days I have presented at the Melbourne and Canberra SQL Server User Groups on SQL Server Automation & SQL SMO.  Below is a list of resources associated with this presentation:

The presentation that I performed on Thursday the 9th March in Adelaide for the Adelaide SQL Server User Group was recorded using Camtasia (http://www.techsmith.com/camtasia.asp).  This presentation is similar to the one presented in Melbourne and Canberra.  The wmv produced recorded the entire presentation including the audio, so if you missed the presentation (or would like to see it again) it is available for download from http://www.wardyit.com/presentations/WARDYITSolutionsAdelaideSQLSMO.wmv. The wmv is approximately 49mb.  Camtasia records the entire screen so the PowerPoint deck and code examples are all available to be viewed so it is just like being at the presentation.

An mp3 of the presentation performed in Adelaide is also available for download from http://www.wardyit.com/presentations/WARDYITSolutionsAdelaideSQLSMO.mp3. The mp3 is approximately 16mb.