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

learn more… | top users | synonyms

1
vote
3answers
5k 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: ...
2
votes
1answer
711 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
2answers
2k 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 ...
0
votes
0answers
19 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 ...
1
vote
1answer
678 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: ...
2
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 ...
0
votes
2answers
966 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 ...
5
votes
3answers
60k 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 ...
3
votes
2answers
1k 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
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
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
20 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 ...
2
votes
0answers
19 views

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting ...
0
votes
1answer
71 views

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it ...
0
votes
0answers
228 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
4answers
17k 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'. ...
0
votes
1answer
63 views

Can Ping but Cannot Telnet directly to SQL Server 2012 Cluster Nodes

We have a monitoring tool (Solarwinds Orion) that needs to connect to a 2-node failover SQL Server Cluster. For reasons outside of our control -- we cannot monitor the CLUSTER IP directly at this ...
0
votes
0answers
33 views

Amazon EC2 SQL Server Connection Timeouts

I am currently having a problem with SQL server timeouts. I am running Windows Server 2008 R2 w/IIS and SQL 2008 R2 (Express) on an m1.small instance in EC2. We have custom services that monitor the ...
0
votes
0answers
44 views

Is there a log showing why a Windows server did not restart SQL Server after a reboot?

Our server was rebooted after a Windows Update scheduled for 1am, but after the restart SQL Server did not start up, so our websites were unable to display. Usually this process happens with no manual ...
2
votes
1answer
196 views

Connection to SQL Server 2008 R2 Database Server is SLOW

The database server is a VM running SQL Server 2008 R2 on top of Windows Server 2012, 24GB RAM allocated and 2TB of disk space. Overall, the database connections are very slow and one thing that ...
0
votes
2answers
252 views

Why is my DB read-only when attached to SQL Express, but not with SQL Web?

I have an .mdf/.ldf pair, originally created in 2008 R2 Standard, and well under 10GB, with ACLs: d:\db snapshot\DB_NAME.mdf SERVERNAME\SQLServerMSSQLUser$ACCOUNT$MSSQLSERVER:F OWNER RIGHTS:F ...
1
vote
1answer
125 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 ...
0
votes
0answers
14 views

SQL Server 2008 R2 Hardware configuration [duplicate]

We need some clarification in Logshipping & Hardware Configuration. Could you please help us in this regard. We are using SQL Server 2008 R2 Standard edition installed on 32-bit Windows server ...
1
vote
0answers
76 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 ...
0
votes
1answer
41 views

How can I delete this ODBC?

I am unable to delete a specific ODBC of type system DSN. I am able to create and remove other ODBC connections on the same server, but a particular ODBC (name = Default) cannot be removed. If I try ...
2
votes
1answer
321 views

Why is MS SQL Server Using NTLM Authentication?

Windows Server 2008 R2. SQL Server 2008 R2 installed. MSSQL Service runs as Local System. Server FQDN is SQL01.domain.com. SQL01 is joined to an Active Directory domain named domain.com. The ...
1
vote
2answers
84 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
0answers
45 views

SQL Server 2008 R2 Express Edition (local) gone after reinstall [closed]

I ran into a problem with triggers wich stopped me from logging into my databases. I hoped that reinstalling the software would fix the problem but instead it created a diffrent problem, my sql server ...
0
votes
0answers
22 views

Php, IIS8, and MS Sqlserver2008 driver installation

I am new to iis setup, so this is quickly turning into a nightmare. I have installed php using wpi (IIS8)(server 2012) everything is working fine. Now i would like to connect to the ms sql server (v ...
0
votes
1answer
246 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
50 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 ...
0
votes
0answers
99 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 ...
1
vote
0answers
24 views

SQL Server 2012 licensing Downgrade [duplicate]

Our vendor is requiring us to upgrade existing accounting software db from sql 2000 to sql 2008 and my boss wants unlimited connection to db. Can i use sql 2012 per core instead of sql 2008? from my ...
0
votes
3answers
47 views

Separate SQL Server Instance or just new database?

I'm going to deploy an app whose requirement is just 'db_owner' for a database. The database itself must be created separately by the DBA. Based on how the application will work (and its simple ...
-1
votes
1answer
46 views

Slow WRITE operations SQL Server, corrupt backup file after COPY

I am not a network type but a Programmer. I have been working with our DBA and Network technician about a problem I am experiencing. First, our DBA recently moved the database I support from one ...
0
votes
1answer
236 views

In-Place Upgrade from Windows Server 2008 R2 to 2012

I realize that this might not be the best place to ask this question but I'm not sure which one of the StackExchange websites this question belongs to except for ServerFault. I currently have a ...
0
votes
0answers
52 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 ...
1
vote
1answer
47 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? ...
0
votes
0answers
23 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
39 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 ...
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 ...
0
votes
1answer
73 views

SQL Server Web Edition Installation

I have a hosted VM with about 20 client websites on board. Many use a database which is currently SQL Server 2008 R2 (not an evaluation). Because of upcoming licensing issues, I need to change to the ...
0
votes
1answer
84 views

How to setup log and data files on SSD for SQL Server?

I'm setting up my production SQL server. I have two 800GB SSD disks available to me (for Windows and SQL Server). Where should I put databases' data and log files? How many tempdb files should I ...
1
vote
1answer
59 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 ...
2
votes
1answer
293 views

AD Integrated OpenVPN Server User Cannot Connect to MS SQL Server

I have a Windows 2008 R2 Domain/Forest functional level environment with an OpenVPN Access Server (v1.8.4.400) that is Active Directory integrated and working smoothly. I've been working with our DBA ...
0
votes
0answers
26 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
18 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
1answer
214 views

SQL Server 2008R2 Transaction Replication Stop and Restart but continue log backups

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database. ...
0
votes
2answers
173 views

Client connectivity to MSSQL

I'm wondering if there is a policy that can be pushed that defaults a client to always dynamically determine the port for connectivity. I'm dealing with a custom C# application that connects to a ...
1
vote
0answers
155 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 ...