If your building a new sql server, you'll need to move the SQL user accounts and their passwords to the new server. This works for sql 2005 and sql 2008 servers. Here is the link to the orginal article http://support.microsoft.com/kb/918992 This article describes how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. For more information about how to transfer the logins and the passwords between instances ...
Read More
Recently Paul Randal posted What three events brought you here ? He bascially ask "what three life-direction-changing-events" have brought you to where you are today? Which is a very interesting question that comes up from time to time at the 'After Event' for the Jacksonville SQL Server Users Group. I'm always interested in people's stories of how they became DBAs. While most of the stories I hear are of Accidental DBAism, the details of the story are never the same and are very intresting. Aft...
Configure Group Policy to keep RDP session to a minimum on your SSIS boxes Active Directory Group Polices overwrite local policies on a windows server. With that fact in mind, if you know that here are no AD policies for RDP Session time limits, and you have admin privileges to the local box, and you need to introduce some type of time restrictions on the RDP session; this might be exactly what you are looking for. Before we begin, I do need to bring up the old warning: Don’t implement this in p...