tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/18406-sql-serverCascade CMS: Discussion 2015-06-09T12:49:52Ztag:help-archives.hannonhill.com,2010-02-09:Comment/370538852015-06-08T13:18:52Z2015-06-08T19:29:08ZSQL Server<div><p>Hi Cameshia,</p>
<blockquote>
<p>Install a new Windows 2008 R2 Server with SQL Server 2008. Move
the current SQL Server 2005 (OS: Windows 2003) Cascade database to
this new server.</p>
</blockquote>
<p>I do not foresee any issues here as long as the database is
properly migrated/imported into your new SQL Server instance and
the application server has access to the new database.</p>
<p>Feel free to glance over our <a href="http://help.hannonhill.com/kb/database/setting-up-the-database-sql-server">
Setting up a SQL Server database</a> article just so you have a
reference of how a fresh database would be set up.</p>
<blockquote>
<p>Move the website that we use Cascade for onto an IIS8 server
running Windows 2012 R2.</p>
</blockquote>
<p>To confirm, are you referring to your destination web server? If
so, this would be independent of Cascade, so as long as permissions
are set up properly so that Cascade can publish to the web server
you should be good to go.</p>
<p>Please let me know if you have any questions.</p>
<p>Thanks!</p></div>Ryan Griffithtag:help-archives.hannonhill.com,2010-02-09:Comment/370538852015-06-08T18:08:30Z2015-06-08T19:29:08ZSQL Server<div><p>Thanks, I appreciate you confirming everything with me.</p>
<p>Cameshia</p>
<hr>
<p>Cameshia D. Cargle<br>
Systems Administrator</p>
<p>Texas A&M Foundation | SPIRIT AND MIND</p>
<p>401 GEORGE BUSH DRIVE<br>
COLLEGE STATION, TEXAS 77840-2811<br>
TEL 800-392-3310 | 979-845-7906<br>
FAX 979-458-3101</p>
<p>giving.tamu.edu<a href="http://giving.tamu.edu/">http://giving.tamu.edu/</a></p>
<hr>
<p>The information contained in this e-mail message is intended
only for the personal and confidential<br>
use of the recipient(s) named above. This message is privileged and
confidential. If the reader of this<br>
message is not the intended recipient, you are hereby notified that
you have received this document<br>
in error and that any review, dissemination, distribution, or
copying of this message is strictly prohibited.<br>
If you have received this communication in error, please notify us
immediately by e-mail.</p></div>Cameshia Cargletag:help-archives.hannonhill.com,2010-02-09:Comment/370538852015-06-08T19:29:42Z2015-06-08T19:29:42ZSQL Server<div><p>Not a problem at all, Cameshia.</p>
<p>I'm going to go ahead and close this discussion, please feel
free to comment or reply to re-open if you have any additional
questions or issues during/after the migration.</p>
<p>Have a great day!</p></div>Ryan Griffith