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

learn more… | top users | synonyms

2
votes
1answer
69 views

SQL Server Report Services Not Configuring

This is kind of Frustrating as I know I am doing everything right, however SQL Server Reporting Services are not configured: To Configure I did these following steps Opened Reporting Services ...
2
votes
1answer
349 views

MS SQL Server is accessible locally but not over the internet

When I try to access a named instance of Microsoft SQL server 2008 R2 SP2 on the local network, I have no problem. But when access it outside office from the internet, I can not connect to the ...
2
votes
1answer
259 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
2
votes
1answer
536 views

How to uninstall SQL 2008R2 Reporting Services via the command line?

I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and ...
1
vote
1answer
65 views

SQL Server 2008 R2 Failover Clusters behaviour on multiple failures

I'm testing the resilience of one of our test systems. We have 2 x DB (SQL 2008 R2 on Server 2008 R2, running in ESXi VMs) arranged in a Failover Cluster. Shutting down the Active SQL Server service ...
1
vote
1answer
113 views

High CPU utilization on server

Server Configuration: Virtual Dedicated Windows Server 2008, Xeon Processor 1.6GHZ, 4GB RAM MS SQL Server R2 Express IIS 7.0 .NET Framework 4.0 Problem: Very slow response of the ...
1
vote
1answer
306 views

SQL Server 2008 R2 marked for unload due to memory pressure

I noticed the following error message on a development server that I'm working on. Can anyone tell me what this means? AppDomain 21 [mssqlsystemresource.sys[runtime].21] is marked for unload due to ...
1
vote
1answer
333 views

Adding a linked server via Powershell

I'm trying to add a linked server to my local SQL Server 2008 R2 setup from within a Powershell script. Here's what I've been trying so far (and variants): EXEC master.dbo.sp_addlinkedsrvlogin ...
1
vote
1answer
139 views

SQL Server 2008 R2 Backup

I see this error message in log BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages. SQL Agent is disabled. I never issued backup ...
1
vote
1answer
588 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
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 ...
0
votes
1answer
12 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
1answer
74 views

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 ...
0
votes
1answer
18 views

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 ...
0
votes
1answer
55 views

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 ...
0
votes
1answer
113 views

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 ...
0
votes
1answer
73 views

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 ...
0
votes
1answer
105 views

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 ...
2
votes
0answers
282 views

SQL Server 2008 R2 mirroring failing

I have two Windows 2008 R2 (Amazon EC2) instances running SQL Server 2008 R2. I use 9TB striped disks (9x1TB EBS volumes) for storage. One server is running as principal and second one as mirror. Both ...
1
vote
0answers
25 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 ...
1
vote
0answers
77 views

SQL Server Replication - How to connect to a system via computer name rather than IP address in Amazon AWS?

In Amazon AWS, VPC, I am trying to setup replication in SQL Server, and have three servers setup with port 1433 RDP open (1 web, two SQL). I can RDC into each server. From the web server, I can ...
1
vote
0answers
125 views

Losing connection to SQL Server on the same machine?

I've installed our SQL Server driven software on a client's computer. This consists of SQL Server 2008 R2 Express, and using ADO/SQLOLEDB drivers on a brand new Windows 8 64bit machine. The problem ...
1
vote
0answers
79 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
1
vote
0answers
261 views

SQL Server distribution agent cleanup job causes blocking

I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I ...
1
vote
0answers
39 views

Sql Server 2008 R2 Web Edition - an administrators guide?

I've been hunting around on Google and have so far failed to find a book or online guide for how to administer and lock down Sql Server 2008 Web edition. Specifically I've come from 10 years of MySQL ...
1
vote
0answers
80 views

SQL Server 2008 R2 installation error

when I install SQL Server 2008 R2, I get this error. Why? http://i52.tinypic.com/2ik4c47.jpg
1
vote
0answers
537 views

Web sync merge replication cannot connect to publisher

Before I start I would like to clarify that I am setting up a test environment to configure & test WebSync before carrying out a deployment at a client. My machines are all running SQL Server ...
0
votes
0answers
12 views

SQL2008 R2 BackupDirectory - Cannot access the specified path or file on the server

I've recently added extra SAN storage space to our SQL2008R2 server (Failover Cluster with 2 nodes). With that I've edited the follow registry entry from I: to K: and moved the existing backup folders ...
0
votes
0answers
35 views

Setting secure connection to SQL server over SSL

I have TEST-SERVER which is in 192.168.1.0 subnet. I need to set-up secure connection to it for people from outside that subnet i.e. internet. I know that certificate for SQL server needs to have ...
0
votes
0answers
14 views

SQL server listening on 2 ports but 1 of them encrypted

First thing, please forgive me for my english, it isn't perfect i know :) I have server called "TEST" (running Windows Server 2008 R2) with SQL Server 2008 R2 instaled on it. I have configured SQL ...
0
votes
0answers
19 views

Encrypting SQL Connections: no certificates listed

We are trying to setup encrypted connection to SQL server, using the this guide. We have certificates installed and they are being used to encrypt the [http] connection to our application. When we ...
0
votes
0answers
23 views

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be ...
0
votes
0answers
11 views

Log ODBC queries including execution times to solve performance issue

We are facing some Perdormance issue in out web aplication which uses an ODBC Connection, i would like to log running queries to analyse where the problem is, Is there any way to make ODBC log the ...
0
votes
0answers
12 views

Team Foundation Server “In Recovery” Errors

I have a team foundation server running in our domain running Small Business Server x64; We periodically run into freezes with TFS check-in, and Checkout; and looking at the SQL databases closely, ...
0
votes
0answers
10 views

Why are there delays in applying tracked changes to the SQL Full Index

I have SQL Server set to automatically track changes on a table and that works fine. However, sometimes there is quite a delay (over 8 hours) between when the changes are tracked and when the changes ...
0
votes
0answers
24 views

Merge_Replication_Tables_Not_In_Sync

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
0
votes
0answers
77 views

Connection Timeout Expired

Message:Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and ...
0
votes
0answers
53 views

SQL-Server 2008 R2 Mail Configuration failed

I have a failover SQL server that I need to configure DB mail for. I got it working on the primary database and all configurations are mirrored to the failover server. The issue is that the 2nd ...
0
votes
0answers
41 views

Access violation on inline function with CTE

Heh, that's weird. I have simple table type and inline table-valued function. When I try to run or compile this batch, I got c0000005 EXCEPTION_ACCESS_VIOLATION ! create type M1List as table (ID ...
0
votes
0answers
188 views

sql server 2008r2 reporting services service will not start

Got a Server 2008R2 VM with SQL Server 2008R2 SP1 installed the problem is the reporting services service will not start in a timley fashion; We've tried the following suggestions; Its setup to run ...
0
votes
0answers
89 views

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 ...
0
votes
0answers
157 views

SQL Server 2008r2 SP2 Manual Install Error

I am receiving an error I have never seen before, nor can I find any info on the net. When I try to install SP2 for SQL Server 2008r2 I receive the following error. Cannot find the value of the ...
0
votes
0answers
30 views

Instant File Initialization Turned on but file grows slower in sql server 2008r2

What are the reasons a data file (8 GB) could take a long time to grow even if Instant file initialization is turned on in sql server 2008r2? The sql service account has admin access to "Perform ...
0
votes
0answers
50 views

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 ...
0
votes
0answers
456 views

Automate Sql Server 2008 R2 Express install - silently and pre-configured

I want to create a .MSI installation of my app. One of the things that should be installed it's the SQL Server 2008 R2 Express, but i want it to be installed silently, pre-configured for all client ...
0
votes
0answers
82 views

MSSQL 2008 R2 Restore VSS

We have a Windows 2008 R2 server which has 2 disks of which one is used as a backup disk for Windows Backup with VSS enabled. We also have MSSQL 2008 R2 running on this server. If I want to restore a ...
0
votes
0answers
145 views

SQL 2008 R2 - Log Shipping between cloned servers

I have two servers, one is a clone of the other (Hardware and Software) and restored from a baremetal backup. Both servers are on different networks. Both servers are part of a domain with the same ...
0
votes
0answers
173 views

Windows 2008 SQL cluster won't come online after db failure

We have a new SQL 2008 R2 cluster on Windows 2008 R2 that is active/passive. We restored the large db to the sql instance to start testing and it choked on the integrity check and failed the db ...
0
votes
0answers
141 views

Group Policy Settings for Servers Hosting SQL Server and/or Exchange

My company is in the process of building a new AD Domain for our VDI environment. Once the VDI rollout is complete, we will be migrating everything out of our existing domains into this new domain. ...
0
votes
0answers
127 views

SQL Server 2008 R2 Data Mirroring issue

I'm trying to setup Data mirroring between 2 servers. Error: “The server network address “TCP://servername:5022″ can not be reached or does not exist. Check the network address name and that the ...