'SQL Server 2008' Tag

• Installing SQL Server 2008 on Windows Server 2008 R2

  August 16, 2009

  Before you install SQL Server 2008, read this post about installing the pre-requisites on Windows Server 2008 R2. In this example I have also prepared a special SQL Service account named DBService. Start the setup program. Select Installation. Select the New SQL Server stand-alone installation. When the Setup Support Rules has identified all the rules, [...]

  posted in Blog by InsomniacGeek

• Pre-requisites for installing of SQL Server 2008 on Windows Server 2008 R2

  August 16, 2009

  In order for you to install SQL Server 2008 on Windows Server 2008 R2, you will need to add required Server Roles and Features.   First, add the .NET Framework v3.5.1 that SQL Server 2008 requires. Go to the Server Manager –> Features and select add features. Put a check in the .NET Framework 3.5.1. [...]

  posted in Blog by InsomniacGeek

• How to enable database diagram on SQL Server 2008

  August 12, 2009

  When you try to create a database diagram on SQL Server 2008, you are greeted with this message: TITLE: Microsoft SQL Server Management Studio —————————— Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or [...]

  posted in Blog by InsomniacGeek