SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.

learn more… | top users | synonyms

1
vote
2answers
92 views

Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?

I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. ...
1
vote
2answers
94 views

Monitor SQL Server 2008

I've got a SQL Server 2008 R2 instance running on a webserver and I'd like to monitor the running processes it's got or which locks it maintains. The SQL Server process will gradually (running a week ...
1
vote
1answer
2k views

what does R2 stands for in SQL Server 2008 R2?

What does R2 stand for in SQL Server 2008 R2? Is it Revision 2 or Release 2? Is it an another version with additional features?
1
vote
1answer
6k views

How to enable Ad Hoc Distributed Queries in SQL Server 2008 R2

When I run a query with OPENROWSET in SQL Server 2000 it works. But the same query in SQL Server 2008 generates the following error: SQL Server blocked access to STATEMENT ...
1
vote
2answers
559 views

Upgrade sql server 2008 to 2008 R2, in-place upgrade or new install

When upgrading we normally create a new install and migrate databases over, but we are going to test out in-place upgrade from sql server 2008 to sql server 2008 r2 (standard) in our development ...
1
vote
2answers
132 views

SQL Server 2008 R2 installation/connection questions [closed]

I have a Windows Home Server connected to my home network on which I have just installed SQL Server 2008 R2, I am aiming to connect to the SQL Server installation from my laptop using SQL Management ...
1
vote
2answers
1k views

What version of PowerShell is required for SQL Server 2008 R2?

Today I tried to install SQL Server 2008 R2 Express on my computer but I the installation failed, it said that PowerShell must be installed on it. My question is then, what version of PowerShell ...
1
vote
2answers
1k views

Migrate SCOM 2007 R2 Databases to SQL 2008 R2 (change server)

UPDATE I have a SCOM 2007 R2 server that uses a sql 2005 server. Machine 1: SCOM (SCOM 2007 R2 - W2K3) Machine 2: SQL2005 (SQL 2005 SP2 - W2K3) SQL Cluster: SQLCLUSTER (SQL 2008 R2 on Cluster - ...
1
vote
3answers
5k views

“RESTORE HEADERONLY is terminating abnormally” error when restoring backup

When I try to restore a database backup file, I get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ...
1
vote
4answers
14k views

Permission denied when creating database in Sql Server 2008 express

Running the following (generated by Sql Server Management Studio) on Sql Server 2008 Express under Vista: CREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'c:\Program Files\Microsoft ...
1
vote
2answers
143 views

Setting Sql server security rights for multiple situations

We have an application which uses an instance of Sql Server locally for its backend storage. The administrator windows login has had its sysadmin right revoked, and instead two sql logins have been ...
1
vote
2answers
533 views

Ola Hallengren's SQL Backup to Network Location not working

Good Evening All, 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 ...
1
vote
1answer
954 views

deploy ssis 2012 packages on 2008r2 server

We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and ...
1
vote
1answer
395 views

ASP.NET Session State SQL Server 2008 R2 Freezes with High CPU Usage

Our ASP.Net website uses SQL Server as the session state provider. We currently host the database on SQL Server 2005 since it does not play well on 2008 R2. We would like to know why, and how to fix ...
1
vote
1answer
4k views

SQL Server linked server: “Cannot start more transactions on this session.”

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...
1
vote
2answers
997 views

SQL Server stops regularly on every windows restart

Edit 3 & 4 Added Although the SQL Server instance is set to run automatically and TCP also is enabled in its Network Configuration, the SQL Server is stopped after each system restart. I have to ...
1
vote
2answers
96 views

Sql Server 2008 R2 connection error

I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client. But it shows the following error: cannot connect to SMSERVER\SMTECH How ...
1
vote
2answers
722 views

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - ...
1
vote
1answer
395 views

Can only debug once

I can only debug a query once, after that I get this error and have to restart Management Studio. Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The requested name is ...
1
vote
2answers
276 views

cannot at all find sql instance (while installing an asp.net app on IIS)

So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem ...
1
vote
2answers
1k views

Error when installing SQL Server 2008 R2 Express

When installing SQL Server 2008 R2 from the command line prompt, I am getting the following error that is recorded in the Summary file. Scenario specific rules: Rules report file: ...
1
vote
1answer
818 views

SQL Agent History settings not being saved

I'm using Win 2K3 R2 + SP2 with SQL 2K8 R2 installed. I'm trying to set SQL Agent History to keep 1 week of logs. So here's what I do: After I connect, I right click SQL Server Agent and select ...
1
vote
2answers
225 views

SQL Server 2008 constantly reads MDF file, performance terrible [closed]

We have an app that runs SQL Server 2008 R2 Express on the back end on a Windows 2008 R2 virtual server running on VMWare ESXi. Users complain that the app is very slow. I see very high disk IO that ...
1
vote
1answer
59 views

Installing SQL Server 2012 on older instance

I have SQL Server 2008R2 installed on my server which I can connect either by providing server name "xyz" or IP address "127.xx.xx.xxx". Does it mean my installation is done with default instance? ...
1
vote
1answer
149 views

Restoring database to a point in time not working

I have a database that is backed up nightly via a maintenance plan I created using the wizard in management studio. The recovery model is set to full. On the 26th something happened and SQL Agent ...
1
vote
1answer
34 views

SQL server many to one mirroring

I have two SQL servers, server A and server B running SQL Server 2008 R2 Standard. Can I setup a third server that will be a mirror for both server A and server B? I can't seem to find any ...
1
vote
1answer
650 views

SQL Server 2008 R2 on Windows Server 2003 - “ failed to initialize 0x84B10001”

I am trying to install SQL Server 2008 R2 Express on Windows Server 2003 and I get an error "failed to initialize 0x84B10001". Googling got me the following link - ...
1
vote
1answer
549 views

Troubleshooting I/O latency possibly caused by file system driver

I have a SQL Server instance (SQL Server 2008 R2, Windows 2008 R2) that complains, for very short, random periods of about 15-20 seconds, that some of its I/O requests are taking longer than 15 ...
1
vote
1answer
390 views

My php site cannot connect to SQL Database - SqlExpress2012

Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2. Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted ...
1
vote
1answer
176 views

SQL Server account disabled even in single user mode

I'm integrating with a third-party product via its SQL Server 2008 R2 database. In a previous version, I was able to access the database via SQL Server Management Studio and SQLCMD as a Windows ...
1
vote
1answer
644 views

Error upgrading from SQL Server 2008 to SQL Server 2008 R2

I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server .... Additional info ...
1
vote
1answer
5k views

Connection failed: SQLState: '01000' SQL Server Error: 10061

I'm trying to connect my access front-end to the SQL Server backend. It was working when SQL Server was on my computer but now i'm trying to connect to a server So when I create the DSN file with ...
1
vote
1answer
552 views

Is start-process supported in a powershell step on SQL Server 2008 R2?

With the described configuration, I have a SQL Agent Job that includes a Powershell step. That step throws an error when it gets to the line $app = start-process -passthru $program $program_args ...
1
vote
1answer
501 views

Adding SQL Server 2008 R2 (sqlexpress) datasource in CF Administrator

I am using coldfusion 9 and SQL Server 2008 R2. It is set up as sqlexpress When I try to add a data source (sql) I get this error: Connection verification failed for data source: test_cursor ...
1
vote
1answer
262 views

SQL2008 Max Memory set to 10GB, Target/Total perfmon counters report it's using 1.6GB. What's up?

Running SQL2008 R2 32bit on Windows Server 2003 Enterprise with 12GB of RAM. Inside the Memory settings of the SQL instance I've got max memory set to 10000MB but it isn't going past 1.6GB according ...
1
vote
1answer
2k views

SQL Server 2008 R2 Writing To Text File

I used to write to text files from SQL Server using the code listed below: DECLARE @FS INT --File System Object DECLARE @OLEResult INT --Result message/code DECLARE @FileID INT ...
1
vote
1answer
2k views

SqlServer 2008R2 sp1 CHECKDB crashes when spatial index present

We've been having an issue with DBCC CHECKDB crashing with an access violation (null pointer deference) on Sql Server 2008R2 when spatial indexes are present. It is repeatable with DBCC CHECKDB WITH ...
1
vote
1answer
2k views

sql server cluster - “the given network name is unusable” error in creation wizard

I'm trying to create a sql server 2008 R2 cluster. I've got two windows machines running server 2008 that are clustered and have all passed the validation tests etc. I'm now going through the ...
1
vote
1answer
524 views

Report Server w/ SQL 2008 R2 Express - Can't login to Manager URL

I just installed Report Servicing addon (Advanced Services) to a local SQL Express 2008 R2 server. I have the configuration tool and setup the proper URLs but when I connect to them I get permissions ...
1
vote
2answers
3k views

Non-SA role restoring database?

If I'm reading Books Online correctly, a user can restore an existing database if they're the DBO of that database; the actual words are: If the database being restored does not exist, the user ...
1
vote
1answer
807 views

When installing SQL Server, “Unhandled Exception: System.Security.SecurityException: Request failed.”

Brand new Windows Server 2008 R2 install handed over to us from Windows admin group. I try to run the SQL Server 2008 R2 install and get this error: Unhandled Exception: ...
1
vote
2answers
232 views

Is this server core intallation possible: DC + SQL + Sharepoint 2010?

I would like to setup a test staging virtual server. If at all possible I'd like to use just one virtual machine. These are the software requirements: Windows Server 2008 R2 Domain controller Web ...
1
vote
1answer
2k views

SQL Server 2008 R2 - Cannot create database snapshot

Server: Windows Server 2008 R2 X64 Enterprise SQL: SQL Server 2008 R2 Enterprise X64 I have a default SQL Server instance, the SQL Server service account is running as a domain user. I am trying ...
1
vote
1answer
558 views

Taking SQL Server database ownership after the original owner has left the company

I have inherited administration responsibility for a SQL 2008 R2 server at work. The previous database administrator has left the company, and can no longer be contacted. At this point I have: Full ...
1
vote
2answers
3k views

SQL Server 2008 R2 on Windows 7 Starter?

I tried installing SQL Server 2008 R2 on my machine running Windows 7 starter but got an error: An error occurred during the installation of assembly ...
1
vote
1answer
1k views

install SQL Server 2008 R2 on Chinese Vista fails: Checks if existing performance counter registry hive is consistent

PerfMonCounterNotCorruptedCheck Checks if existing performance counter registry hive is consistent. Failed The performance counter registry hive is corrupted. To continue, you ...
1
vote
1answer
177 views

Hourglass won't go away in SQL Server 2008 R2 Management Studio

... after I add a column to a table. I've just started using 2008 R2 Management Studio, but I have a few years experience with 2005 Management Studio. Also, I am connecting to a 2005 instance of a ...
1
vote
1answer
49 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
1
vote
0answers
486 views

SQL Server 2008 R2 log shows backups (I/O suspend, resume) several times an hour

I am troubleshooting a server issue that may or may not be related... On my SQL Server 2008 R2 instance running on Windows Sever 2008 R2 (VMWare), the logs show: Each database is backed up every 6 to ...
1
vote
0answers
27 views

Should SQL Server backups be scheduled in SQL Server Agent or as a Scheduled Task?

I have inherited a system where a system where our database is backed up by identical scripts, one set up in SQL Server Agent and one set up as a Scheduled Task. Both are running at the same time, so ...