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
1
vote
1 answer

Can only debug once

I can only debug a query once, after that I get this error and have to restart Management Studio. Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The requested name is valid, but no data of the requested type was…
Stijn
  • 218
  • 3
  • 20
1
vote
2 answers

SQL Server 2008 R2 installation/connection questions

I have a Windows Home Server connected to my home network on which I have just installed SQL Server 2008 R2, I am aiming to connect to the SQL Server installation from my laptop using SQL Management Studio using my Windows Credentials (I selected…
Jamie Keeling
  • 123
  • 6
1
vote
2 answers

Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?

I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. I'm loading data from a local SQL Server instance…
Kevin Babcock
  • 243
  • 1
  • 4
  • 12
1
vote
1 answer

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions denied: The permissions granted to user…
eyston
  • 123
  • 5
1
vote
2 answers

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed to initialize properly (0x000007b), Click on OK to…
Nir
  • 131
  • 6
  • 12
1
vote
2 answers

SQL2008R2 Server access to XML templates in IIS7

I'm in a jam. working on a migration project from SQL 2000 to SQL2008 R2 on a windows 2008 R2 box with IIS7 now installed. The old server had 3 simple virtual directories with XML templates installed on them. The 'IIS Virtual Directory Management…
Chris Wood
  • 133
  • 5
1
vote
2 answers

Non-SA role restoring database?

If I'm reading Books Online correctly, a user can restore an existing database if they're the DBO of that database; the actual words are: If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able…
Chris J
  • 1,218
  • 18
  • 32
1
vote
0 answers

SQL Server 2008 R2 installation error

when I install SQL Server 2008 R2, I get this error. Why? http://i52.tinypic.com/2ik4c47.jpg
Hakan Ilgar
  • 11
  • 1
1
vote
2 answers

What can cause SQL Server's maximum memory setting to appear to change over time?

I started analyzing our SQL Server PerfMon logs in Excel, and discovered this. Legend: Red - SQL Server - Target Server Memory Green - SQL Server - Total Server Memory Blue - Available System Memory Server 1: Server 2: Server 3: Has anyone else…
Jon Seigel
  • 468
  • 3
  • 18
1
vote
2 answers

When installing SQL Server, "Unhandled Exception: System.Security.SecurityException: Request failed."

Brand new Windows Server 2008 R2 install handed over to us from Windows admin group. I try to run the SQL Server 2008 R2 install and get this error: *Unhandled Exception: System.Security.SecurityException: Request failed. at…
Osolage
  • 11
  • 2
1
vote
3 answers

To get Sql Server 2008 r2 installed, do I just install Sql Server 2008 and then use windows update?

I have been told I need to install Sql Server 2008 r2 on my development PC, do I just install Sql Server 2008 and then let windows update install r2 – e.g. is it like any other service pack?
Ian Ringrose
  • 870
  • 1
  • 6
  • 12
1
vote
2 answers

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ideas how to resolve this?
jozi
  • 161
  • 2
  • 2
  • 5
1
vote
2 answers

cannot at all find sql instance (while installing an asp.net app on IIS)

So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem now is SQL Server 2008 r2, after figuring out how to…
gideon
  • 1,145
  • 2
  • 13
  • 28
1
vote
2 answers

What version of PowerShell is required for SQL Server 2008 R2?

Today I tried to install SQL Server 2008 R2 Express on my computer but I the installation failed, it said that PowerShell must be installed on it. My question is then, what version of PowerShell should I install? where do I get it?
Shimmy Weitzhandler
  • 143
  • 2
  • 7
1
vote
2 answers

Error when installing SQL Server 2008 R2 Express

When installing SQL Server 2008 R2 from the command line prompt, I am getting the following error that is recorded in the Summary file. Scenario specific rules: Rules report file: C:\Program Files\Microsoft SQL Server\100\Setup…
dretzlaff17
1 2 3
…
25 26