installationsql-server-2012
I'm being paranoid here I'm sure. I'm at the end of an SQL Server 2012 install and this message appears. I know it says that I must restart the computer but I've had instances where installer automatically restarted the server when I didn't want it to. I cannot reboot this production server right now. Am I safe to click OK to complete the installation?
If your RegSrvr.xml contains a "password=....;" in <RegisteredServers:ConnectionStringWithEncryptedPassword> section, replace ";uid=...;password=...;" with ";trusted_connection=true;"
In the same file, replace:
<RegisteredServers:CredentialPersistenceType type="CredentialPersistenceType">PersistLoginNameAndPassword</RegisteredServers:CredentialPersistenceType>
with:
<RegisteredServers:CredentialPersistenceType type="CredentialPersistenceType">PersistLoginName</RegisteredServers:CredentialPersistenceType>
Now the server registration will try to use Windows Authentication. Once the Registered Servers are loaded, you can go back and edit the registrations to use your SQL Authentication information.
Following up on my comment, you have to select ENU\x64\SQLEXPRADV_x64_ENU.exe for installation.
Then run the installation package and follow instruction until you get feature selection page.
Follow rest of the steps and complete the installation.
Now Verify the RS installation :
Note: You must be logged in as a member of the local administrators group on the computer where SQL Server 2012 Express is installed.
Navigate to Start -> All Programs -> Microsoft SQL Server 2012 -> Configuration Tools -> Reporting Services Configuration Manager.
In the RS Configuration Connection dialog, make sure that your local report server instance (for example SQLExpess) is selected and click Connect.
In the RS Configuration Manager left pane, select Web Service URL.
Make sure that the Virtual Directory parameter is set to ‘ReportServer_’ (‘ReportServer_SQLEXPRESS’ for the SQLEXPRESS instance), and that the TCP Port is set to 80. Click Apply.
In the Reporting Services Configuration Manager left pane, select Database.
On this page, ensure that the SQL Server Name and Database Name fields contain correct values. If not, click the Change Database button and complete the Report Server Database Configuration wizard.
In the Reporting Services Configuration Manager left pane, select Report Manager URL.
On this page, ensure that the Virtual Directory parameter is set correctly, and that the URL is valid.
Click Exit to close the RS Configuration Manager.
Best Answer
You can safely click OK and it won't reboot it. The instance will even be up, online and accessible without the reboot.
It's always good practice to reboot after a fresh installation or patches as when you try to perform another patch or installation down the road, the installer will more than likely fail of the 'Restart Required' portion of the checks.