F.A.Q. – Help

Common Problems:

  • Windows 2008 R2 Server fails to install SQL Server

  1. This is because Windows 2008 R2 ships with the .NET 3.5.1 framework. You just need to enable the feature from Server Manager.  After checking the following setting, run the installation again.
  2. Open “Server Manager” (Start / All Programs / Administrative Tools / Server Manager).
  3. Select “Features” on the left.
  4. Click “Add Features” on the right.
  5. Check the box “.NET Framework 3.5.1 Features”.
  6. Click “Install”.

 

  • “Scan for Servers” from the server does not return the local sql server instance.

  1. Start the SQL Server Configuration Manager (Start / Programs / Microsoft SQL Server 2008 / Configuration Tools).
  2. Click SQL Server Services.
  3. Verify that the SQL Server Browser is running.   See the following link for more information.  http://msdn.microsoft.com/en-us/library/ms189093.aspx

 

  • Cannot connect to SQL Server from client on a remote machine (a machine that does not have the SQL Server running on it).

  1. You may need to adjust some settings on the “server” (the machine that is running SQL Server).
  2. See the following links for more information.  http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx  And/Or  http://msdn.microsoft.com/en-us/library/ms175043.aspx