Welcome to my english corner, the WebBlog where I'll try to publish my own experiences and to share knowledge with the Microsoft IT Community, about technologies like SQL Server, Windows Server, Virtualization, Sharepoint/MOSS, and so on. Nevertheless, I'm going to continue to strive in my main (and spanish) Website Portal GuilleSQL, where I'm writing about my IT experiences since October 2007, and is recognized as a Microsoft User Group by GITCA. However, I Know I have to improve my english, so some times you should be patient with my english (I'm sorry...). I hope you enjoy your visit. Keep in contact !

• Connection Pooling, Database drop and creation, and the transport-level error (no process is on the other end of the pipe) - A typical error we can get when programming .NET Framework applications which drop and create databases on SQL Server while using connection pooling (then, by default) is the following well-known error: A transport-level error has occurred when sending the request to the server. No process is on the other end of the pipe. How we can bypass or solve this error?

• Failed to start macro VerifyUsers error on SharePoint 2010 Web Database Site - Access Services is one of new features available in SharePoint 2010, which makes it possible either creating Web Database Sites or publishing a Microsoft Access database as a SharePoint 2010 Site. Then, the client/user can access this Microsoft Access database from SharePoint without the need of having Microsoft Access installed (only the Internet Explorer browser is needed). However, after creating a Web Database site you could get the Failed to start macro VerifyUsers error message. What’s happening?

• The installation of this package failed error when installing the Service Pack 1 for SharePoint 2010 - A typical error when installing the Service Pack 1 for SharePoint 2010 is the error message The installation of this package failed. Maybe a too generic error message to find out why the installation of Service Pack 1 for MOSS 2010 fails, but with a quick review we’ll find the usual reason for which this error occurs: Not enough disk space. Extend disk (or free up space), and the installation of Service Pack 1 for SharePoint 2010 will end with success.

• Event ID 7023, DNS Server service does not start on boot: The network is not present or not started - In the last few days I have been working on a Windows Server 2008 R2 installation having Directory Services and DNS roles enabled. However, after installing Exchange Server 2010, I found out that the DNS Server service was stopped. Then I was looking for additional details and… the DNS Server service had never started on boot. It always got the following error message on the System Event Log: The network is not present or not started (Event ID 7023). However, I could start the DNS Server service manually (once Windows was started) without any problem. In addition, the Intersite Messaging service could not start on boot.

• How get SysAdmin permissions on SQL Server when you cannot access to it - Sometimes, we found out that we cannot access as SysAdmin to an existing SQL Server or SQL Express instance, because we have not any user with elevated privileges on SQL Server, even though being member of the local Administrator group. In this scenario we can try to start the SQL Server instance on Single User mode and connect to it using a local administrator user, to take ownership, creating a user login configured as SysAdmin. This Workaround is quite helpful in Outsourcing projects, corporate mergers, SharePoint 2010 farms installed on StandAlone mode, and so on.