Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008-r2]

SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.

SQL Server 2008 R2 was released to manufacturing on April 21, 2010. SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services, a central management of master data entities and hierarchies.

SQL Server 2008 R2 includes a number of new services, including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services Add-in for SharePoint, a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application, and a SQL Server Utility named UC (Utility Control Point), part of AMSM (Application and Multi-Server Management) that is used to manage multiple SQL Servers.

The first SQL Server 2008 R2 service pack (Service Pack 1) was released on July 11, 2011.

390 questions
0
votes
1 answer

Performance implications of running SQL Server 2008 in a virtual machine

I have a bare-bones Windows 2008 R2 Enterprise production server running SQL Server 2008 R2 Enterprise. We have a faster server that isn't being utilized and I'd like to move the production database onto it. However, I also wanted to use the faster…
Kevin Babcock
  • 243
  • 1
  • 4
  • 12
0
votes
1 answer

Will two or more instances of SQL Server Express help on the same machine?

I am curios whether having two or more of these instances on the same machine help using more RAM and more (logical) CPUs. By default an instance of SQL Server Express would only use 1 GB of RAM and 1 cpu only. Having a machine with 4 cores and…
Andrei Rînea
  • 310
  • 5
  • 17
0
votes
2 answers

what type of replication transaction should I use?

I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different sql servers which are located in different parts…
RaymondMorphy
  • 1
0
votes
1 answer

MS SQL Server wont start when listening for VPN IP

I've just configured SQL Server 2008 R2 Express on Server 2008 R2, with the idea to administrate it remotely via the Routing and Remote Access VPN. Everything is fine via the VPN and the connection works, however, the service fails to start…
Nicholas McGee
  • 1
0
votes
1 answer

What are some recommended training resources for Windows Server 2008, IIS 7.5 and SQL Server 2008 R2?

My employer is starting a project to migrate one of our application server stacks from an open-source stack based on JBoss and PostgreSQL on Linux to a Microsoft stack powered by IIS 7.5, SQL Server 2008 R2 and Windows Server 2008. Political…
aaltonen
  • 81
  • 1
  • 5
0
votes
1 answer

Issue in configuration of SSRS

Windows Server 2003 R2 with SQL Server 2008 R2: During installation accidentally I selected "instance for Sharepoint server". Now I want to install the SSRS, in fact I installed it, by adding features from the DVD. Now from reporting services…
Lalit
  • 109
  • 1
0
votes
4 answers

Question regarding SQL Server 2008 R2 installation - 'Server Configuration' phase

I'm trying to install SQL Server 2008 R2 on my development laptop and am hitting a snag when it gets to the 'Server Configuration' phase. It's asking me for Windows user account information for the various servies it needs to run. I'm not sure…
Major Productions
  • 185
  • 6
  • 17
0
votes
1 answer

Block SQL 2008 R2 Insert Access on anything for user in MS ACCESS on AD Group

Hi I would like to block access to insert any data on SQL when a User from a determined Active Directory Group access SQL from MS ACCESS. Is this possible? if not is there any alternative? I've tried a server trigger, and was able to prevent access…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

How to configure SSL on an instance of SQL Server to allow dedicated users to remotely access it?

I have configured the instance of SQL Server to allow dedicated users to access it remotely. Connection string Data Source = 192.168.1.2,1433\sqlexpress;etc... has been tested and works. However, I have not configured the SSL to secure the…
LaTeX
  • 111
  • 1
  • 2
  • 11
0
votes
1 answer

Supertype question from a mega noob

I've tried a couple database creation tools (MS SQL Server, MySQL Workbench, etc.) and I cannot figure out how to create a super-type relation (complete, disjoint). Below is an example of how it looks in crow's foot notation. Even a link to a…
Eric Fossum
  • 225
  • 3
  • 11
0
votes
2 answers

SQL Server 2008 R2 Enterprise won't install on Windows 2008 R2 Enterprise

I've been trying to install SQL Server on a new Windows Server 2008. I have tried everything but I haven't been able to narrow down the problem. When the installation fails I get " Exit code (Decimal): -2068643839". The problem with this is that…
Carlos Paulino
  • 133
  • 2
  • 7
0
votes
2 answers

Clustered MSDTC - No transaction is active

Hi I Currently have two clusters (W2K8R2) with SQL 2K8R2, both with MSDTC cluster service enabled. I've configured the MSDTC with all checkboxes, and Incoming Caller Authentication Required and NT AUTHORITY\NetworkService as the DTC Logon…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

Error installing SQL Server 2008 r2 on Windows Server 2008 R2 Sp1

I am managing my dedicated server, here's what I did: Made a fresh install of Windows server 2008 R2 SP1 from the MSDN install ISO. Then added the web server role that turns on IIS. DONE! Then I went and installed the latest SQL Server, SQL SERVER…
Rui Marinho
  • 1
0
votes
2 answers

setting MAXDOP server default value

Hi I've a server with 2 physical processors with 8 cores each. Looking through Management Studio Shows me a tree with NUMA 0 and NUMA 1 and inside 8 childs. The current maxdop is on 0, should I set a different maxdop for the server? If so this…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
1 answer

Install Reporting Services 2K8R2 on W2K8R2 Cluster Nodes

First I'm aware that Reporting Services is not Cluster aware, But I would like to install it on my each node of my 2 node Cluster on the default instance. I've got the following error installing Rule Check Result Rule "Existing clustered…
Gabriel Guimarães
  • 405
  • 5
  • 18
1 2 3
…
25 26