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
3
votes
1 answer

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 minutes, before the issue resolved itself. This was…
Paul
  • 81
  • 5
3
votes
1 answer

vCenter SQL Express Database Maintenence

After performing a simple install of vCenter 5.1 with all default chosen including the sql express database, what should we do to ensure continued operation without manual intervention? Currently we run in the problem where the database bloats out…
BeowulfNode42
  • 2,615
  • 2
  • 19
  • 32
3
votes
2 answers

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple collations per instance.
PnP
  • 1,684
  • 8
  • 39
  • 65
3
votes
1 answer

Tables in the SQL Server "master" database, will they cause problems?

Folks, please be kind on me... I'm just an 'accidental' DBA due to our DBA resigned, so I'm totally a newbie in DBA... You see, I have this application, "ESET Remote Administration Server" (ERAS) that stores its logs and analysis on (originally) a…
pepoluan
  • 5,038
  • 4
  • 47
  • 72
3
votes
2 answers

Can I use a powershell script to install db/website when the database is separated from the webserver?

My boss is on vacation and I'm supposed to have this installation script done by the time he returns. Unfortunately, I've realized that the script I developed won't work on the target server setup and I don't know enough about it to know how to…
Kit Z. Fox
  • 133
  • 1
  • 5
3
votes
2 answers

Looking for robocopy ipg number

I have a robocopy job that creates a problem every time it runs. It saturates the bandwidth in such a way that no other traffic can get through. I read about the /IPG flag but am going in circles trying to find a number. I found calculators that…
eth0
  • 163
  • 1
  • 3
  • 12
3
votes
1 answer

SQL Server Report Services Not Configuring

This is kind of Frustrating as I know I am doing everything right, however SQL Server Reporting Services are not configured: To Configure I did these following steps Opened Reporting Services Configuration Manager Click Connect Clicked Web Services…
Andres Adhi
  • 41
  • 1
  • 4
3
votes
2 answers

Attempting Unauthorized operation - SQL 2008 R2 install

I've been banging against this for a few days. Keep getting this unauthorized error when trying to install SQL 2008 R2 on a Windows 7 machine. I've changed permissions on the key, does not fix... Created an admin user, gave specific permissions…
Fred L
  • 31
  • 1
  • 2
3
votes
1 answer

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 without occurring a license on the Database Engine…
abatishchev
  • 541
  • 1
  • 9
  • 31
3
votes
1 answer

Connecting to SQL server instance on VM via host-only network

I've setup a virtual development machine with Windows Web Server 2008 R2 and installed SQL Server 2008 R2 Express on it as well. I didn't install any SQL tools on it, because I have them on the host machine. Virtual machine is running on VMWare…
Robert Koritnik
  • 912
  • 5
  • 19
  • 35
3
votes
2 answers

Cloning a machine after SQL Server 2008 R2 Express installation

We're rolling out laptops to some of our staff that will require SQL Server 2008 R2 Express be installed. We'd naturally prefer to do the setup of the laptops (including the installation SQL Express) once and then clone it to the other 50 or so…
Larry W
  • 31
  • 2
3
votes
4 answers

Implications of having IIS on SQL Server 2008 R2 machine

an application needs to have IIS on the same box of Reporting Services. Today SSRS and SQL stay on the same clustered box. I need to evaluate the options which for me are: Installing IIS on both Cluster nodes Installing IIS and Reporting Services…
Gabriel Guimarães
  • 405
  • 5
  • 18
3
votes
2 answers

Cannot resolve the collation conflict between "SQL_Latin1_General_CP437_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

I'm trying to copy over a schema from one server to another, and I keep getting the following error and I have no clue where to start from to debug this issue... Error 2 SQL01268: .Net SqlClient Data Provider: Msg 468, Level 16, State 9,…
RyanTaylor2
3
votes
1 answer

KB2494088 Always Fails : How to get it to install (or stop trying to)?

I have a problem where KB2494088 (a SQL Server 2008 R2 patch) continually fails to install when I reboot my system. Downloading the manual patch and trying to apply it says: The SQL Server patch package is part of a general distribution release…
Peter K.
  • 80
  • 5
  • 17
3
votes
1 answer

SQL Server mirroring refuses to work. Tearing my hair out

I'm trying to attempt what I thought would be a very simple process - the mirroring of a database between two MSSQL 2008 R2 servers within the same domain. Both servers are configured similarly, and I have a database called 'archive' that I'd like…
growse
  • 8,020
  • 13
  • 74
  • 115
1 2
3
…
25 26