'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. Here’s the guide to installing SQL Server 2008 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 [...]

  posted in Blog by Magnus Johansson

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

  August 16, 2009

  In order for you to begin installing 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 [...]

  posted in Blog by Magnus Johansson

• How to enable database diagram on SQL Server 2008

  August 12, 2009

  You have to enable database diagram on SQL Server, otherwise 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 [...]

  posted in Blog by Magnus Johansson