A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

3
votes
0answers
150 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
2
votes
0answers
959 views

SSMS stuck scripting database objects

SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database. i scripted all the objects in an SQL Server 2008 database from ...
2
votes
0answers
70 views

SQL Server 2008 R2 Replication conflict

We have software that during the installation or updates it drop and adds all of its views, triggers, and stored procedures. This became a problem when we tried to implement a snap shot replication on ...
2
votes
0answers
286 views

ASP.MVC website production server configuration best practice

When creating a new website on a production windows 2008 r2 server which requires connection to SQL Express should I create a custom identity for the application to run under or leave it as ...
2
votes
0answers
348 views

Slow Connection to SQL Server using OleDB

I have a web application using an ISAPI filter (written in c\c++) and OleDB to connect to a SQL Server 2008. The application works fine on a certain number of Windows Server 2008 R2. Recently I ...
2
votes
0answers
132 views

Can encryption be disabled for the login handshake in SQL Server 2005 or 2008

When a client Application connects to SQL Server the login credentials are sent over the network in a TLS Encrypted Handshake Message. For testing purposes I would like to have the login credentials ...
1
vote
0answers
6 views

Same Query,Same execution plan ,Same argument why different duration

I have a query which some times takes longer than normal .the thing is query and parameter and execution plan and reads and cpu are all the sam every time but sometimes it is slow .there is also no ...
1
vote
0answers
17 views

Repeatedly prompted to restart the computer when installing SQL Server 2008 R2 on a x64 Win 8.1 machine

I am trying to install SQL Server 2008 R2 on a Win 8.1 x64 bit machine. When running the installer, I get the Reboot Required check failing the install. I have tried rebooting, no difference. I ...
1
vote
0answers
91 views

What are the limitations of using a scheduled Windows Server Backup instead of SQL Server backups?

We've taken over development and server admin for an e-commerce site, and the client has opted for a well-specced dedicated server, including a second drive for daily Windows Server Backups. However ...
1
vote
0answers
52 views

SQL 2008 over the internet replication

Please excuse me for the (probably) stupid question, but SQL Server is not my main proficiency here... I have 2 SQL Server 2008 R2 servers, one in an AzureVM and another one in my local datacenter. ...
1
vote
0answers
152 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
1
vote
0answers
3k views

Why does RDP freeze on Windows Server 2008 R2 in a virtual machine during high load?

We have noticed a problem where remote desktop sessions to a server will freeze when the server has high CPU load. Environment: VMWare ESX 4.0u1. Guest OS is Windows Server 2008 R2 (this is the ...
1
vote
0answers
149 views

Unable to apply CU 13 to SQL Server 2008 R2

I am running version 10.50.4033 and would like to apply cumulative update 14. However, I get an error that basically says I'm not at the correct version to apply this patch. I assume I have to ...
1
vote
0answers
2k views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) ...
1
vote
0answers
49 views

Failover cluster wouldn't fail over

I have an active-passive failover cluster on 2008r2 with SQL server 2008 clustered on it. I go to fail it over for maintenance and the resource failed to come online on either node. Once I rebooted ...
1
vote
0answers
118 views

sql server x64 access x86 COM object

I want to transfer a database from SQL Server 2000 x86 to SQL Server 2008 R2 x64 but it uses a x86 COM object that I have no inside knowledge of. I know there are some articles out there about the ...
1
vote
0answers
51 views

Microsoft SQL Server Express 2008 access denied

I'm trying to install Target Process on a Windows 7 machine, but for that I need to install SQL Server Express 2008, but I've been hitting my head on the same problem for a while now. I found ...
1
vote
0answers
194 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
1
vote
0answers
262 views

SQL 2008 fail-over cluster---specified credentials for the SQL Server service are not valid

We had Two Node SQL 2008 fail-over cluster. Last week one node was crashed, so we decided to re-build the passive Node(crashed Node), we reinstalled the OS and added to windows cluster successfully, ...
1
vote
0answers
53 views

ssms script wizard not working with modified tables

I'm looking for a way to get all triggers and constraint we modified in a script to migrate them to a different database or reapply to this one if necessary. I'm using SQLServer Management Studio ...
1
vote
0answers
399 views

MS SQL 2008 R2 64bit will not use more than 1.5GB in task manager

I have the latest MS SQL 2008 R2 installed on Windows Server 2008 R2 64-bit. The SQL server process never surpasses 1.5GB in the task manager resulting in heavy disk usage. I have solve this problem ...
1
vote
0answers
127 views

Deploying reports to report server

I posted this question on stackoverflow, but I think it would be better here. I configured SSRS 2008 on a remote server running under Network Service. I can access the report manager from my local ...
1
vote
0answers
359 views

SQL Server 2008 x64 R2 SP1 - Management Studio installation language

In our production server, the hosting provider installed SQL Server and Management Studio (standard edition) in Spanish, but I would like to have them in English. It's quite difficult to find menu ...
1
vote
0answers
6k views

SQL Server services not showing up in SQL Configuration Manager

I have SQL Server 2008 R2 (RTM) running on a Windows Server 2008 R2 (SP1) box. This instance exists primarily to run SSRS in SharePoint integrated mode. When I open SQL Server Configuration Manager, ...
1
vote
0answers
691 views

Unable to access SQL Server 2008 - Cannot Generate SSPI Context

I've had this problem for a few weeks but haven't had time to focus on it until now. My company has a relatively fresh installation of Windows Server 2011, which is also running Microsoft SQL Server ...
1
vote
0answers
54 views

SQL08 ConnectionString: Data Source= vs Server=

For an asp.net webapp, is there a functional difference between a connection string (in Web.config) that uses: Data Source=[WIN-MachineName]\SQLEXPRESS vs Server=[WIN-MachineName]\SQLEXPRESS Since ...
1
vote
0answers
882 views

Delete the default instance of SQL Server 2008

I'm trying to uninstall SQL Server 2008. I went through add remove programs and deleted all the SQL Server programs which didn't remove the services and the instances... I manually deleted the ...
1
vote
0answers
575 views

SQL Server Database stuck in Restoring… state

I'm trying to configure a mirror for a Test database between two SQL Server 2008 R1 SP1 Servers: A1 and A2 I'm doing a full backup of Test database on A1 and then trying to restore it on A2 with ...
1
vote
0answers
928 views

SQLServerAgent could not be started (reason: Unable to connect to server ) Error 103?

Does anyone know how to make the second SQL instance Agent working on the same MSCS SQL Server 2008 R2 cluster? In the clustered SQL Server service instance2 i have assigned the same service account ...
1
vote
0answers
97 views

How to create an SSIS package with a Script Component

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS. I want to take data from a Source database ...
1
vote
0answers
2k views

Unable to authenticate proxy when starting SQL snapshot agent

I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied, I have restored a database from an old image (SQL 2005) and am trying to get web-sync ...
1
vote
0answers
2k views

How do deal with SQL Server transaction log corruption

We had a failure with our SQL Server log shipping job. sp_readerrorlog reported: Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF ...
1
vote
0answers
65 views

Suggestion for encrypting database files in SQL 2008 Standard Cluster

I have an SQL 2008 Server configured as a fail-over cluster an have a requirement to have the database files (mdf/ldf) encrypted. We have tried to use EFS for this but there are a lot of issues doing ...
1
vote
0answers
124 views

Asymmetric key to import assemblies

To import the System.DirectoryServices assembly requires the following commands create asymmetric key asmKey_DirectoryServices from executable file = 'c:\Windows\Microsoft.NET\Framework\v2.0.5072 ...
1
vote
0answers
592 views

Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but ...
1
vote
0answers
60 views

SQL - progmatically change refresh rate for ALL publishers in replication monitor

How can I change progmattically change the refresh rate of all the publishers in the repliation monitor ? Without going into each one to change it's publisher setttings. MS SQL SMS 2008 R2 AHIA, ...
1
vote
0answers
114 views

SQL Reporting Server Authentication Issue

I have one web server & one DB server (running SQL SERVER 2008). Both the servers are in different domains. The web server is allowed to communicate(the communication takes place internally ...
1
vote
0answers
461 views

Event viewer filtering - MS Sql server - How to filter logins from outside?

I want to filter event log to show SQL logon that was initiated from other machines, I have thousands of logins from local machine and few ones from other machines. I want to monitor that connections ...
1
vote
0answers
290 views

Need 64bit SQL Server 2008 for Windows 7 64bit OS

I have Windows 7 64-Bit, and I have SQL Server 2008 Developer edition. Whenever I am trying to install SQL I an error stating that I cannot install 32-Bit SQL Server on a 64-Bit OS, but in the SQL ...
1
vote
0answers
74 views

Which method of SQL Server 2005 or 2008 Replication is best for ease of field changes?

We need 15 minute warm updates from one SQL Server to another. Log Shipping looks good and appears easy to setup. We are also looking into Transactional Replication. The data only needs to copy one ...
1
vote
0answers
819 views

How to setup certificate authentication for MS SQL server 2008 R2?

I have to connect an (ADO) application running on a standalone Windows 2003 R2 server to a SQL 2008 R2 database that is a member of the domain. I have setup an SQL authentication account for this and ...
1
vote
0answers
537 views

Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column

Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column I’ve been trying to understand some strange values in the RESOURCE_ASSOCIATED_ENTITY_ID column of SYS.DM_TRAN_LOCKS when ...
1
vote
0answers
577 views

SQL 2008 Database tuning advisor won’t start

For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying: Failed to initialize MSDB ...
1
vote
0answers
386 views

sql server using all the memory on the box and throwing timeouts on pedestrian queries

I have max memory set. But at least 1 time a day the Sql Server hits over 95% of the ram in the box, and page faults for more. In the meantime the website is throwing very obscure timeouts on simple ...
1
vote
0answers
475 views

Error while starting synchronize

I'm using merge replication for database synchronization. I'm getting the folllowing error when launching the replication monitor.I can able to access both sides. Stil having the problem. Error ...
0
votes
0answers
14 views

SQL Server SSMS/Other Processes Allow Login from Untrusted and Unassociated domain

We have a Windows/SQL server development environment which is completely separate from our developers primary systems, including completely separate domains (no forest association, etc.) Our SQL ...
0
votes
0answers
43 views

SQL Server - Database Transaction Log Backup. Appended or seperate files?

we have 30 productions databases in our SQL server. top big DBs are 60GB, 40GB, 8GB, 5GB and the rest are 1GB or less. we have incremental transaction-log backup set-up currently every-hour by ...
0
votes
0answers
33 views

Running SQL Server based Program Via VPN

I have recently set up a site-to-site VPN. Location A has a PC running windows 7 (we'll call it Computer1) that acts as a server for a point of sale program. The program uses SQL Server 2008 to store ...
0
votes
0answers
13 views

schema specific object access in sql server is not happening after restoring backup

I have an application which is accessing sql objects(stored procs/tables) etc which are defined under a schema 'A' for example A.my_stored_proc. This application is working fine as intended when I ...
0
votes
0answers
51 views

Event 1033 in Windows Event Viewer for SQL Server 2008

Every single morning I come in to find that SQL Server has logged another 3 or 4 of the following events on one of our servers: Log Name: Application Source: MsiInstaller Date: ...