Posted 28 January 2013 - 08:45 PM
I usually pick up on this kind of thing quickly, but SQL Server 2008 R2 is anything but simple.
The first issue I'm running up against is that I'm trying to transfer a database from our old server, running SQL Server Express 2005, to our new server running SQL Server 2008 R2. I did a simple backup and restore using SQL Management Studio. Now, I can see the database using SMS on the new server, but it doesn't show up in the SQL Configuration Manager. As such, I don't think the database is actually 'running' or being advertised. My experience with the full-blown SQL Server software is limited, so I'm not sure what I'm missing.