SQL Express 2005 Remote Connections and Backups

Monday, May 1, 2006

.NET

SQL Server Express 2005 doesn't allow remote connections by default. Some simple instructions for allowing remote connections can be found at ... http://www.datamasker.com/SSE2005_NetworkCfg.htm.

Also grab the free ExpressMaint console utility available at http://www.sqldbatips.com/showarticle.asp?ID=29. It provides some of the functionality of the sqlmaint utility - backups made easy!

2 Comments

Thanks for the post. I've been trying to figure this one out for the past couple of weeks.

Now I can continue to use my laptop to remote into my computers and watch the NHL playoffs from my couch!

Jason Row - Monday, May 1, 2006 1:39:00 PM
Ian, thanks for the tip re Jasper Smith's SQL 2005 Service Manager.

Alex Hoffman - Thursday, May 4, 2006 2:23:00 AM

Comments have been disabled for this content.