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

learn more… | top users | synonyms

0
votes
1answer
1k 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 ...
1
vote
0answers
11 views

Unable to configure SQL Server log shipping, latch error

SQL 2008 R2, SP1 CU8 both servers, next to each other in the rack, ~10 small databases (total under 50GB). I found that log shipping was broken (for a long time), rebooted secondary as a ...
2
votes
3answers
892 views

Ola Hallengren's SQL Backup to Network Location not working

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 network backup ...
0
votes
1answer
15 views

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The ...
2
votes
1answer
1k 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 ...
0
votes
1answer
960 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 ...
3
votes
2answers
2k views

Attempting Unauthorized operation - SQL 2008 R2 install

I've been banging against this for a few days. Keep getting this unauthorized error when trying to install SQL 2008 R2 on a Windows 7 machine. I've changed permissions on the key, does not fix... ...
1
vote
2answers
3k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
0
votes
0answers
27 views

Database mirroring issue - Both database is showing principal disconnected

My mirror database went down for a week and when i started it again. It was stuck in recovery disconnected mode. To fix the problem i misunderstood someone and ran the below command. ALTER DATABASE ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
1answer
40 views

SQL Server 2008 Agent service wont start

We previously had SQL Server 2008 R2 Express to try some things out (I know it is by design that the agent service is disabled in this version) After proving the concept, we upgraded to the standard ...
2
votes
1answer
3k views

Connecting to SQL server instance on VM via host-only network

I've setup a virtual development machine with Windows Web Server 2008 R2 and installed SQL Server 2008 R2 Express on it as well. I didn't install any SQL tools on it, because I have them on the host ...
0
votes
0answers
68 views

Error installing SQL Server 2008 R2 service pack 3 on Exchange 2013 DAG

I have a 4-node Exchange 2013 DAG; all servers use the Windows Server 2012 R2 OS; they are all consolidated servers, running both the Mailbox and CAS roles. On each server, Trend Micro ScanMail for ...
1
vote
1answer
33 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
0answers
27 views

MSSQL application failing to connect to database server

We run a very old application that connects to an MS SQL server 2008 database using the SQL server native client 10. Sometimes if there has been a power failure with the server the clients will stop ...
0
votes
2answers
106 views

SQL Server 2008 R2 does not utilize allocated memory

Our app runs on a server with 4 core CPU, 8GB RAM and Sql Server 2008 R2 Standard Edition (10.50.1600.1), 64 bit. Server dedicated to Sql Server, no other heavy service is running. We've set min/max ...
4
votes
5answers
33k views

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. ...
1
vote
1answer
57 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. ...
0
votes
1answer
2k views

Can't install SQL Management Studio 2008 R2 Express - Throws exception

I am running SQL Server 2008 R2 on a Windows Server 2012 R2 machine. select @@version returns the following string: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86) Jun 28 ...
0
votes
2answers
48 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
-1
votes
1answer
37 views

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 ...
1
vote
1answer
59 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 ...
0
votes
0answers
88 views

SQL Database with offline filegroup

I'm using SQL 2008 R2 Enterprise and yesterday I had an hardware-error. During this error one disk went offline, which contains a very unimportant part (filegroup) of the database. Accidentially this ...
0
votes
0answers
12 views

SQLServer Maintenance Plan Cleanup misses files by minutes

I have a set of maintenance plans in place that perform a full backup weekly, and once complete, delete any .bak's that are a week old. This is important, because the DBs are very large and disk space ...
0
votes
2answers
252 views

SQL Log Shipping Two Databases using the same shared folder

I will configure Log Shipping for more than 1 database on single a server. And I wan't to know If I can use a single Shared Folder or if I have to create a Folder For Each Database. What I mean is: ...
0
votes
0answers
188 views

SQL server session tasks all waiting

I have a query that often completes in a fraction of a second (~200ms). Sometimes it takes 10-13 seconds to complete. Doing SET STATISTICS TIME ON it shows: SQL Server Execution Times: CPU time = ...
0
votes
1answer
105 views

How to update system databases in SQL Server

I am having problems updating a system database in SQL Server 2008. Perhaps there is a different way to do it, but I basically need to change/remove growth restrictions on certain log files for a ...
0
votes
1answer
80 views

cannot restore database to a different version of MSSQL server

I am trying to restore a database onto a clean install of MS SQL Server 2008 R2. I am using the same installation CD as with the original computer. That PC has since died and I now need to restore the ...
0
votes
0answers
77 views

Unexpected Sql Server 2008R2 / Server 2008 reboot (bsod) on increasing maxmemory SQL setting

The server OS is Server 2008 x64 and its role is DB server + SSIS (SQL Server 2208R2 x64). (VMWARE ESXi 5.1.0 on IBM 3850x5) Until yesterday the total system memory was 8GB and the maxmemory setting ...
0
votes
2answers
4k views

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

How to improve poor SQL Server performance

We have a virtualized environment using VMware vSphere 5.0 U1 which hosts our Microsoft SQL Server and have very poor performance. the host server is a HP DL360 G5 with xeon X5450's, and the disk ...
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
4answers
3k views

how to install mssql 2008 r2 from iso

I'm trying to install ms sql from iso. I've installed virtual clonedrive which mounts the iso as drive however i'm getting the following error. E:\Resoourse\1033\setup.rll is either not designed to ...
0
votes
1answer
75 views

TFS Database migration miss the detach step issue

We currently doing the TFS database migration, originally, we suppose to upgrade to 2012 which support SQL 2008 R2, after a period of time, we decide to upgrade to 2013, and unfortunately we are ...
3
votes
5answers
2k views

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have ...
1
vote
2answers
4k views

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this in event history: The SQL server service terminated with server-specific error. Only one usage ...
3
votes
1answer
239 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
-4
votes
1answer
69 views

Setup network between 2 computers connected using wifi [closed]

In my office I have a WiFi Router that allows 2 computers to connect to Internet. I have 2 questions - How can I create a network between these 2 computers for file sharing? Can I access SQL server ...
0
votes
3answers
737 views

Merge Replication with Geometry data type

The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be ...
5
votes
2answers
1k views

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...
0
votes
0answers
84 views

SQL server reporting services Get user IP

USER -> Reporting server -> SQL Serve SELECT CONNECTIONPROPERTY('client_net_address') AS client_net_address return of course IP of reporting server In DOMAIN is this command return true IP of user ...
0
votes
2answers
3k views

SQL Server Database Access fails when User Granted Acess via Domain Group

On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access is granted to the server instance, but cannot access certain databases on the server. The ...
0
votes
1answer
764 views

SQL Server Agent is not visible in SSMS

I have been monitoring the server for past 4 days but i am not able to see agent on SSms but the agent service is in running mode and the server is of standard edition
1
vote
1answer
879 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: ...
0
votes
0answers
58 views

SQL 2008 R2 says access denied when logging in remotely

I have an SQL 2008 R2 server and a monitoring server both on the same physical network (but different VLANs). The monitoring server is always connecting to the SQL server to run a query and check the ...
0
votes
0answers
1k views

Server 2012 slow performance on ESXi 5.5

I'm having performance issues with a virtual Server 2012 that is installed on an ESXi 5.5 (HP-ESXi-5.5.0-iso-5.71.3). The hardware server is an HP ProLiant DL380p Gen8. The server 2012 is acting as ...
3
votes
3answers
9k views

Can't login to SQL Server in Single User mode

I've been trying all sorts of different combinations of startup flags to SQL Server 2008 R2 Express and I can not get past this error: Login failed for user 'LOCALSERVER\Administrator'. Reason: ...
0
votes
0answers
146 views

migrate plus move existing biztalk server database from sql server 2008 R2 to sql server 2012

we are planning to move biztalk database from one place to another as well as upgrade the sql server. the initial database is in sql server 2008 R2 and target is sql server 2012. but the thing is ...
5
votes
3answers
101k views

How to completely remove MS SQL Server 2008 R2 x64 which was uninstalled incorrectly?

On my Windows 7 Ultimate x64 I can't do anything with the existing instance of MS SQL Server 2008 R2. It was my mistake to uninstall some components related to SQL Server before running the main ...
0
votes
1answer
73 views

Sql server 2008 r2 services won't start

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server ...