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

Installing active SQL server instance on passive node, no network settings field

I'm installing an active-active MSSQL server 2008r2 instance. While trying to install the second active node on the first passive node, I get to the network configuration page and there are no fields. Normally there are fields to enter IP…
eth0
  • 163
  • 1
  • 3
  • 12
0
votes
1 answer

SQL Server extension fails with PHP, IIS

I am having difficulties getting the SQL Server extension to work with PHP on Windows Server. The installation went fine and I'm able to load phpinfo through the browser. However, when I enable php_sqlsrv_54_ts.dll, it throws a 500 - Internal server…
Kermit
  • 71
  • 3
  • 11
0
votes
1 answer

unable to connect to remote sql server from SHDSL router

Got a new leased line network to our office that came with a SHDSL router (Watson). Currently, we are unable to use Sql Server management studio to connect to remote Sql databases. It errors out saying A connection was successfully established with…
user529265
  • 101
  • 1
0
votes
1 answer

cannot log in to sql server 2008

I'm trying to log in to SQL Server 2008, but the installation and the log_in user were done by my friend. Now I'm to trying to open the management studio but I get the error message "login failed" although SQL Server service is running. How can I…
Amanda
  • 1
0
votes
4 answers

SQL 2008 vs. SQL 2008 R2 - which to choose?

We should change our SQL 2005 Server to SQL 2008. My bet was 2008 R2 SP1 but in this week we had several problems with it (related to CU7 and CU8) and as far I see, R2 has bugs - confirmed by Microsoft. We have no special requirements, our SQL 2005…
boj
  • 121
  • 4
0
votes
1 answer

Things to consider when applying hot fix to production server

We are currently using Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) as our production data warehouse database. I need to apply hotfix / security patch version…
oOo Testing1 oOo
  • 19
  • 1
0
votes
2 answers

What is the correct authentication mechanism when there are users inside and outside the domain?

We have a Windows 7 enterprise desktop data entry app for mobile (laptop) users with local SQL Express 2008 R2 Express db that syncs data with an SQL Server 2008 R2 Server db. Users may go off network/offsite and still view and enter data. Data…
abc123
  • 107
  • 1
  • 6
0
votes
3 answers

Connecting to database without instance name

When I'm trying to connect to my database, I need to provide the instance name like so: 192.168.10.10\SQLEXPRESS I'd like to be able to just connect to my database without having to type the instance name, like so: 192.168.10.10 How can I accomplish…
TtT23
  • 127
  • 1
  • 2
  • 14
0
votes
2 answers

Advised auditing method for MS SQL to track changes made to a specific table by a specific user?

What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio? I'm using 2008 R2 Express Edition and want to specifically track a single user who logs in through…
scape
  • 365
  • 1
  • 3
  • 17
0
votes
2 answers

What's the difference between shrinking files or database in SQL Server?

I need more space in my development environment and need to shrink my database (or files) in SQL Server. Should I chose "shrink files" or "shrink database" to free most disk space?
Benny Skogberg
  • 157
  • 2
  • 8
0
votes
1 answer

Database Engine Services Required to install ssrs?

I have already installed sql server 2008 express and ssms on my vm... now I am trying to install ssrs on the same machine and keep getting "database engine error". Should I skip this (click here please) I have tried to uninstall and reinstall…
EagleFox
  • 127
  • 8
0
votes
1 answer

Sql Server database logs "missing"

Here's the problem we're having: In the applications that are using the databases we get errors like: The log for database 'redactedDatabaseName' is not available. Check the event log for related error messages. Resolve any errors and restart the…
linkerro
  • 101
  • 1
0
votes
1 answer

In place upgrade from SQL Server 2005 to 2008

Situation - Server running windows server 2003 and SQL Server 2005. About 18 various databases on the server. We need to upgrade to Windows Server 2008R2 and SQL Server 2008. We can't afford to lose any of the databases (if I did my life as I…
Ken Ray
  • 1
  • 1
  • 1
0
votes
2 answers

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on 'SERVER'' was received with more detail 'Could…
user49352
  • 123
  • 2
  • 4
  • 12
0
votes
2 answers

How to configure SQL 2008 R2 Express to allow remote machine to connect to it?

I'm building a new XenApp 6.5 Farm, which requires SQL 2008 R2 Express(which I've installed on a machine called vCitrixServices). I installed XenApp on vCitrix1 and started to creating a new farm, but I get this error trying to connect to our…
NeerPatel
  • 329
  • 2
  • 6
  • 18
1 2 3
…
25 26