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

SQL Server Trace keeps outputting files

A consultant has come and gone to do some audit on our SQL server, and has left a bit of a mess here. The problem is that he did things that we don't know anything about. In the C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA…
thomasb
  • 103
  • 6
0
votes
1 answer

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i want to use this connection string in the network,…
Deepesh Ghanekar
  • 1
0
votes
1 answer

Associate SSL certificate for SQL Server which does not use the FQDN

We would like to connect securely to SQL 2008 R2 over the internet for reporting purposes. Speed is not a huge concern for these smaller data sets, and users are going to be using simple reporting programs (e.g. Access) that require ODBC…
cninsd
  • 41
  • 1
  • 5
0
votes
1 answer

Multiple SQL Standard Instances on 4 Processor/32-core Server

We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for 3rd-party apps. Is there any issue with simply…
Theowood
  • 1
0
votes
1 answer

Performance issues with windows server, sql-server and apache

I am running into some performance issues on my server, which runs Windows server 2008, SQL Server 2008 R2, and apache. This is a purely internal website, and is accessed by a total of about 6 people. However, those six use it heavily all day. My…
aquavitae
  • 99
  • 6
0
votes
0 answers

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the Object Browser for one database, he can't view them…
CJM
  • 730
  • 3
  • 12
  • 28
0
votes
1 answer

Different versions of SQL Native Client in SQL Server 2008 R2

I have this error when I try to connect from a Server called: AplicationServer1 to another server in the same domain Kobl, called DatabaseServer1 SQLSTATE[28000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user…
SoldierCorp
  • 103
  • 4
0
votes
1 answer

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I have error 15517. I feel that th subscription i made…
user193655
  • 253
  • 1
  • 5
  • 18
0
votes
1 answer

Trouble with redirect alias name in SQL 2008 R2

I'm working with a team of developers who have SQL instances installed in different places. For the purposes of having one config file for our local machines (instead of having a config file for each machines) we're trying to deal with the SQL…
Geoffrey
  • 273
  • 1
  • 4
  • 12
0
votes
1 answer

Restore backup from SQL 2008 to 2008R2 with standby

We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success with SQL Server Replication, but as the…
Aaron Mason
  • 703
  • 6
  • 20
0
votes
1 answer

Alter new and existing session Command Timeout value

My first post so please me... I’m a self-taught DBA in a manufacturing environment full of engineers who like to fiddle. Although I have not given them sysadmin or any explicit extra rights I have an issue with some engineers running ‘killer’…
Steve Smith
  • 1
0
votes
1 answer

Cannot see linked server properties in SQL Server 2008 R2

I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000. When viewing the properties of an existing linked you, you cannot see (or edit) any information in 2008R2 - where you can in 2000 Note: This is…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
0
votes
1 answer

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out grown our current database server. The main issue is…
M1ke901
  • 1
  • 1
0
votes
1 answer

Install SQL Report Server on a separate server using remote instance for dbs

I have been googling a lot to find the installation guide on how to install Reporting Services on a application server, but couldn't find anything. I already have an SQL server on another machine and want to use this server to host the reporting…
Oliver Nilsen
  • 205
  • 2
  • 8
0
votes
1 answer

DateTime of data file autogrowth in sql server

How to determine the datetime of the last auto file growth of a data file in sql server 2008, if I dont have a trace file at the time of autogrowth. One of the online posts mentioned that the "Modified Date" on the windows explorer is the last time…
user65649
  • 3
  • 1
1 2 3
…
25 26