Browse by Tags

Just a quick one - I was playing around with SQL2005 on my Longhorn server and I could not connect from a remote machine - Ahh I thought, the firewall is in the way, but it turned out I had to do 3 or 4 things to get things working. The Microsoft KB article that pointed to the light was How to configure SQL Server 2005 to allow remote connections which covers how to enable the firewall for the 2 programs you need and so on. When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server. For example, you receive the following error message when you use the SQLCMD utility to connect to SQL Server: Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. This problem may occur...

If you have SQL based apps, they will have to upgrade to SQL 2005 SP2 (that includes the MSDE replacement SQL Express). e-Week noted ( SQL Server 2005 SP1 Users Face Vista, Longhorn Glitches ): These two operating systems will only support SQL Server 2005 SP2 "or later when it becomes available," according to Microsoft's SQL Server support Web pages. But there is no indication on these sites of how soon it will deliver SP2 or whether it will deliver the service pack at about the same time Vista and Longhorn are released. the CTP of SP2 is available at http://www.microsoft.com/sql/ctp.mspx More information on the problems users experience when not running SP2 is available at http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx with support information at http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx which notes: Known Issues This section describes known issues that relate to installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn." Issues Related to User Account Control...

Most people do not run SQL on their Windows client PCs, with the exception of MSDE. Windows Vista will not support MSDE (aka SQL 2000), so applications dependant on SQL will need to be moved to SQL Express, which in simple terms is SQL 2005 MSDE on steroids. I have checked and Microsoft will be releasing updates to it's packages that are supported on Vista to move them to SQL Express. Obviously, if you are looking at Vista, check with other 3rd parties to ensure they are doing the same. More details can be found at Running SQL Server on "Microsoft Windows Server Longhorn" or Microsoft Windows Vista . ttfn David

Many people ask me what I do and sometimes they are amazed with the answer "I help Microsoft Partners build solutions that deliver value to their small business partners – for free". This is a great job and part of it is to engage with as many partners as possible to improve the quality and knowledge around the solutions that can be built upon Microsoft technology. This year my role has a slightly different focus, but the way I achieve it will have many similarities. It has becoming important for me to ensure that partners are not just technically capable, but also selling solutions, sometimes even offering their customers alternative licensing options to suit their business needs. Some may see this as me selling out in some way, but while I love technology, if it is not applied correctly and you and I can't make money out of it, then there is a limit to the business value of the technology. I will still be blogging, posting on both business and technical ideas, but also be discussing how to...

Today we had a bit of a kick of for FY07 (Financial Year 07 in Microsoft) and a review of FY 06. We had a healthy year with excellent growth (this is no way a prediction of the MS Company results) and we also did a bit of sweeping a few things out. It has been speculated for a little while that Alistair Baker would be moving on and today we had it confirmed. As of 31st July, the new MD of MS UK will be Gordon Frazer from the South African Sub. He did seem like a very positive and fired up person, so I think this will be nothing but goodness, as will having another Brit in the power halls at MS in the States. For the press release, have a look at http://www.microsoft.com/uk/press/content/presscentre/releases/2006/07/PR03662.mspx ttfn David

Sooo many of you clicked the links in the posts from the last two days, but got an OWA screen that I had to go back and edit about 16 posts. All fixed now - thanks to Rob for pointing it out. ttfn David