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

learn more… | top users | synonyms

1
vote
3answers
7k views

SQL 2008 R2 Named Instance Client Connectivity Issues?

We're upgrading our software from using SQL 2000 to 2008 R2. Our customers will be installing an update which uninstalls 2000 and installs 2008 R2 under the same instance. So if no instance existed, ...
1
vote
1answer
404 views

Remote Performance Monitoring SQL Server

I've got a couple of servers running SQL Server 2005 Enterprise and I'd like to monitor them remotely using Perfmon (Windows' Performance Monitor). On my machine, I have an instance of SQL Server ...
1
vote
2answers
572 views

How to migrate SQL 2005 to SQL 2008 R2 on new hardware with same server name

We have a need to migrate from existing hardware that is running SQL 2005 to new hardware running SQL 2008 R2. When all is said and done we want the same IP and hostname that was on the "old sql ...
1
vote
2answers
537 views

What can cause SQL Server's maximum memory setting to appear to change over time?

I started analyzing our SQL Server PerfMon logs in Excel, and discovered this. Legend: Red - SQL Server - Target Server Memory Green - SQL Server - Total Server Memory Blue - Available System Memory ...
1
vote
3answers
112 views

To get Sql Server 2008 r2 installed, do I just install Sql Server 2008 and then use windows update?

I have been told I need to install Sql Server 2008 r2 on my development PC, do I just install Sql Server 2008 and then let windows update install r2 – e.g. is it like any other service pack?
1
vote
2answers
4k views

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 ...
1
vote
1answer
155 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
1
vote
2answers
1k views

Cannot install SQL Server 2008 R2 on Windows Server 2008 R2

We are attempting to install SQL Server 2008 R2 on a Windows 2008 R2 SP1 box. We keep running into errors at the end of the install - "the service did not respond to the start or control in a timely ...
1
vote
1answer
163 views

Why does SQL Server Management Studio fail to connect on the first attempt?

When accessing SQL server on a remote development PC via Management Studio the connection will consistently fail on the first attempt. After the failure I retry and can now successfully connect to the ...
1
vote
2answers
121 views

using win7 pc instead of windows 2003 server

Simple question, in terms of hosting an Asp.net-mvc/SQL Server 2008 R2 Express based app, will a powerful Windows 7 PC do? I just wonder if there is anything I'm missing here, being an App Dev and not ...
1
vote
2answers
122 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
95 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
3k 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
69 views

MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure

I'm trying to narrow down and debug quite elusive error: State: 08001 Code: 258 Msg: [Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. State: HYT00 Code: 0 Msg: ...
1
vote
1answer
3k 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
10k 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
678 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
1answer
4k views

how remotely connect to sql server 2008-r2 installed on vps(virtual private network)? (firewall and sql server 2008 configs)

i have sql server 2008 r2 installed on a virtual private network (vps) with one ip valid ... my sql server instance info for connect on server(vps) is like below : server type: database engine server ...
1
vote
2answers
134 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
2k 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
6k 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
24k 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
147 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
1answer
546 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
2answers
3k 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
97 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
1answer
485 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
326 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
2k 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
1k 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
1answer
40 views

2K8 Cluster - SQL Instance broken on one node

Using a 2-nodes cluster 2008R2 Failover Cluster. A new clustered instance was created (I double checked it's clustered). Instance was installed on node1. When we try to move it to node2, it failed. ...
1
vote
1answer
231 views

SQL Server 2008 R2 connection sometimes fails with 'incorrect login'

As part of our testing suite, next to the Unit Tests which mock everything and don't require a database connection, we also have Integration Tests which do require a database. The Integration Tests ...
1
vote
1answer
167 views

Minimal required user permissions for running MS CRM

We have several M$ CRM instances running. Each one has its own dedicated SQL Server instance. The permissions are set up in accordance with the Microsoft recommendations for setting up MS CRM. ...
1
vote
2answers
709 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
962 views

Is there DDL viewer role in SQL Server?

I have a user that have db_datareader role in SQL Server 2008 I need this user to be able to see Stored Procedures, functions, table scripts, etc. What role is that? I don't want user to RUN DDL ...
1
vote
1answer
100 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
272 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
44 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
3k views

TCP/IP connection to SQL Express works on HALF of the clients in a WORKGROUP

So far I have learned the following facts about Microsoft SQL Server Express, including version 2012, and earlier versions like 2008R2, and 2008, and for the most part all the way back to SQL Server ...
1
vote
1answer
1k 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
905 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
648 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
403 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
835 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
8k 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
864 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
613 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
327 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
3k 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 ...