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.

392 questions
24
votes
3 answers

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new function), SQL Server will not honor the updated dll…
Ian Boyd
  • 5,131
  • 14
  • 57
  • 79
16
votes
1 answer

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently set to without using the Management…
token
  • 275
  • 1
  • 3
  • 9
13
votes
1 answer

Why is MS SQL Server Using NTLM Authentication?

Windows Server 2008 R2. SQL Server 2008 R2 installed. MSSQL Service runs as Local System. Server FQDN is SQL01.domain.com. SQL01 is joined to an Active Directory domain named domain.com. The following is the output of setspn: C:\> setspn -L…
Ryan Ries
  • 55,011
  • 9
  • 138
  • 197
13
votes
8 answers

Activity monitor is unable to execute queries against server

Is there any fix to get SSMS activity monitor working? Problem: SQL Server Activity Monitor fails with an error dialog: TITLE: Microsoft SQL Server Management Studio The Activity Monitor is unable to execute queries against server [SERVER].…
mika
  • 1,466
  • 2
  • 12
  • 18
11
votes
5 answers

Can't login to SQL Server in Single User mode

I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error: Login failed for user 'LOCALSERVER\Administrator'. Reason: Server is in single user mode. Only one…
Earlz
  • 969
  • 5
  • 12
  • 28
11
votes
3 answers

How to completely remove MS SQL Server 2008 R2 x64 which was uninstalled incorrectly?

On my Windows 7 Ultimate x64 I can't do anything with the existing instance of MS SQL Server 2008 R2. It was my mistake to uninstall some components related to SQL Server before running the main uninstaller. Now the uninstaller seems like doing its…
Andrew
  • 321
  • 3
  • 5
  • 11
8
votes
1 answer

How to add a group to the sysadmin fixed server role in SQL Server 2008 R2?

How can i add a group to the sysadmin fixed server role in SQL Server 2008 R2? See my related question for details step-by-step screenshots detailing showing that you're not allowed to add groups to the sysadmin role. Background information Before…
Ian Boyd
  • 5,131
  • 14
  • 57
  • 79
7
votes
1 answer

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance? Scenario is I have SQL 2008 R2 installed as a named instance MACHINENAME\SQL2008R2 and i have some scripts which i cannot…
mundeep
  • 916
  • 8
  • 10
7
votes
2 answers

How to allow the local Administrator to have access to SQL Server?

One of our clients has an installation of SQL Server Express 2008 R2 that we more or less manage for them. Today I need to create a new database(a fairly rare occurrence). So I go to login as the user we usually use and we don't have permission to…
Earlz
  • 969
  • 5
  • 12
  • 28
7
votes
2 answers

How to shrink 40GB LOG file

I have a problem that is my log file in SQL Server 2008 is grown to 40Gb and I wanted to shrink it. The query I am using is ALTER DATABASE DatabaseName SET RECOVERY SIMPLE use DatabaseName GO CHECKPOINT GO DBCC…
shane
6
votes
5 answers

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. Reason: Token-based server access validation failed with an…
Ian Boyd
  • 5,131
  • 14
  • 57
  • 79
6
votes
6 answers

Can't connect to SQL Server 2008R2 on Windows Server 2008R2

I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows Administration account, I have this error (picture1),…
Kris-I
  • 161
  • 1
  • 1
  • 3
5
votes
5 answers

Ola Hallengren's SQL Backup to Network Location not working

I have set up Ola Hallengren's SQL Server Maintenance Solution on several SQL Express servers (2008 to 2012 R2) in the past few years. I recently have started having issues with the network backup component on all of them a new one. I've had this…
MagnaVis
  • 388
  • 1
  • 4
  • 13
5
votes
4 answers

Speeding up SQL Server temp table processing with a RAM Disk

A system we are developing consists of a Web app frontend, and a backend that does a lot of data processing using stored procedures in SQL Server 2008 R2 (please, don't ask why...). These stored procedures make heavy use of temp tables (creation,…
mramirez
  • 51
  • 1
  • 4
5
votes
3 answers

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this in event history: The SQL server service terminated with server-specific error. Only one usage of each socket (protcol/network address/port) is…
ebel
  • 81
  • 1
  • 1
  • 6
1
2 3
…
26 27