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
2 answers

MSSQLSERVICE 2008 R2

I have Microsoft SQL Server 2008 installed and running but I can't seem to see COMPUTERNAME/MSSQLSERVICE at all. I have COMPUTERNAME/SQLEXPRESS but that's not the right one. Ideas?
Adam Mike
  • 1
0
votes
1 answer

Cannot resolve cluster resources on EC2?

I have created this cluster on Amazon's EC2 service. I can connect to the sql instance from the first node (there is only one node in the cluster at this time) using the cluster name, so I know that much works. I have another server in another…
JohnThePro
  • 2,595
  • 14
  • 23
0
votes
2 answers

SQL Server 2008 Web edition - access from another IIS?

We are planning to purchase and install SQL Server 2008 R2 Web edition for our live servers. The grand plan was to install a shiny new server with this SQL Server (web edition), and change the connection strings on our various web-apps on two other…
Dan
  • 783
  • 1
  • 13
  • 21
0
votes
1 answer

Clarrification for SQL Server Express 2008 R2 on CPU limit (CPU based on core based)

I'm aware that SQL Server Express 2008 is having few limitations on the database size and the CPU utilization. In MSDN documentation it was mentioned on the express edition would use only one CPU. I went through the following links but I'm not clear…
Nagesh
  • 103
  • 3
0
votes
3 answers

Interpreting SQLIO test results

I've been running a series of load tests on a dedicated DB SAN from a pre-production cluster (Dell R710 connecting to a dedicated RAID10 SAN over 2 gigabit ethernet connections), and I'm not sure if I'm correctly interpreting the data. For…
Scott Hawkins
  • 101
  • 5
0
votes
1 answer

What happens when Mirror times out with Principal, but Principal does not timeout with Witness or Mirror?

We have three SQL server 2008 r2 servers (principal, mirror and witness) setup for mirroring (with safety option). I see in the Mirror server logs that there was a "The mirroring connection to TCP://PRINCIPAL:1234 has timed out" error for databaseA.…
Juan Tarquino
  • 113
  • 3
0
votes
1 answer

Reconnect dbo to login SQL Server

I've got a SQL Server 2005 Express database on a Vista system (DotNetNuke) with the dbo user connected to a login of foo. This is the account that DNN uses to log in to the db. I made a backup of the db and restored it on a Win7 SQL Server 2008 R2…
Kevin Donn
  • 179
  • 1
  • 4
0
votes
1 answer

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark the "copy-only" flag in Management Studio they…
user102718
  • 1
0
votes
1 answer

SQL Server 2008 R2 Licensing

Possible Duplicate: Can you help me with my software licensing question? I want to add a named instance of SQL Server 2008 R2 on one of the server. Server already has 2 named instances on it. My question is, do I need to buy a SQL Server 2008 R2…
ZINX
  • 123
  • 4
0
votes
1 answer

Can't reset sa password

I am trying to drop and recreate sa account to reset the password. IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sa') DROP LOGIN [sa] GO I am getting an error Cannot use the special principal 'sa'. also when I try to reset sa…
user46529
  • 137
  • 1
  • 6
0
votes
4 answers

How to configure MS SQL Server 2008 R2 (login failed for user)?

I want to connect to database with such connection string: connectionString="Data Source=111.111.111.111;Initial Catalog=test;User ID=user;Password=password" So, I have default SQL Server instance (MSSQLSERVER) in my server. I found it as local…
greatromul
  • 167
  • 3
  • 7
0
votes
2 answers

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK button Click OK Down Arrow goto 1 With SSMS i've…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
0
votes
1 answer

SQL 2008 R2 Active/Active/Passive Cluster Does Not Allow Linked Servers Both Ways

We are designing an active/active/passive failover cluster using SQL 2008 R2. We have two separate instances of SQL 2008: instance A is on node 1, and instance B is on node 2. Right now I'm trying to set up a linked server, since there are…
Valkyrie
  • 101
0
votes
1 answer

Audit Records queried from SQL Server 2008 (Database and Analysis Services)

I'm preparing a clinical data warehouse and I need to be able to audit the specific records that users query from either the relational database or the analysis services cubes. The key requirements is that I need the ability to ascertain any…
Bart
  • 126
  • 3
0
votes
1 answer

Need help creating server out of Personal PC for small project

I have a Software engineering project in the near future in which a couple of students will be working on. I would like to host the database and maybe a source control server on my Local PC with hopes that the other classmates would be able to…
Brandon
1 2 3
…
25 26