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
1answer
395 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 ...
3
votes
1answer
205 views

How do I remove an old SQL Server 2008 Express Database Instance

I am trying to restore a database over the existing one. This worked fine in the past, until all of a sudden, it doesnt. I have clearly, in the past, attached the same database file under a different ...
3
votes
1answer
5k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
2
votes
1answer
52 views

What are the downsides of running all SQL Servers under same domain account?

I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers ...
2
votes
1answer
474 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
823 views

Allowing a specific IP Address through a blocked port in Windows Server 2008 R2 Firewall

I have created an Inbound rule to block port number 1433 however I need to allow my static ip address to access this as I use SQL Management Studio to connect to databases on the server. I have ...
2
votes
1answer
241 views

apache 2.2 with php 5.3 and miscrosoft sql 2008 crash

I am using Apache 2.2 with PHP 5.3 and Microsoft SQL Server 2008 on Windows Server 2008 64-bit. Every 3 to 5 hours, I get the error in the event viewer that Apache crashed for 20 seconds and then ...
2
votes
1answer
103 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
2
votes
1answer
4k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
2
votes
1answer
1k views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
2
votes
1answer
45 views

Share Point 3.0 service account

We have a Share Point 3 site that is currently configured to run under a admin account. I have been tasked with reconfiguring it to run under a service account. Unfortunately, when I update the ...
2
votes
1answer
91 views

Problems with merge replication

We are developing a multi-user desktop application with users located in different countries. The platform is - .net 3.5, SQL Server 2008, WinForms. Now, my client has used the help of a DBA who has ...
2
votes
1answer
716 views

Adding new article to transactional replication gives error at subscriber

I have a updatable transactional replication set with SQL Server 2008. Everything is working fine. I added a new table to the existing publication through sp_addarticle followed by ...
2
votes
1answer
2k views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
1
vote
1answer
50 views

Using Linked SQL Servers from a different server

I have 3 machines that are involved in running a SQL script: JumpBox - A machine that serves as a stable point for automation to run. ReportBox - A machine that holds reporting databases and logic. ...
1
vote
1answer
48 views

Single row user security in MS SQL 2008 R2

I have a SQL Server 2008R2 question regarding making a single row in an odd way. situation: I have a student records database in which ~ 100 students might in-process in a given day. They enter a ...
1
vote
1answer
2k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
1
vote
1answer
732 views

MS SQL 2008 - Can I use Windows Authentication to connect from a Mac

I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good. However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
1
vote
1answer
638 views

SSRS Errors “Use Local”, even though I am

I am at a loss. I posted this on SO, but think this is probably a better place. I have searched high and low and don't know what to do. I am running SQL Server Web Edition on Server 2008, which only ...
1
vote
1answer
150 views

Installing instance of Sql - SQL server 2008 R2

I am extremely new to SQL server. I am running the SQL Server 2008 R2 setup wizard and following a tutorial that I found online. Nowhere am I able to configure my instance, even after completing ...
1
vote
1answer
335 views

single application multiple users through thin client

I am having one application built in C# winforms. In the backend I am using SQLSERVER 2008 Express. The application is used remotely through thin clients. My problem is that when one user is using my ...
1
vote
1answer
50 views

SQL Server Rights to backup drive

I'm trying to copy a backup I've made from one server to another using either an SSIS or Powershell step in a job. I've run into the same error on both systems when running the step under the sql ...
1
vote
1answer
63 views

Bigger ProjectServer farm is performing worse

I am using Project Server 2007 sp3 with SharePoint 2007 sp3 and SQL Server 2008 r2. I have recently moved my farm from 2 servers (1 DB and 1 App/Web) to a very big farm having Many Servers, Clustered ...
1
vote
1answer
537 views

System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in impersonating the client

i have published my asp.net MVC 3 web application locally using IIS 7 express and visual developer express 2010, but when i tired to login to the application and after i insert the user name and ...
1
vote
1answer
519 views

FTS - Index rebuild causing CPU issues (SQL Server 2008 R2)

I am encountering some critical issues on SQL Server 2008 in a production environment; We have a database that contains a FTS index; we also have a maintenance job that rebuilds the FTS index and ...
1
vote
1answer
311 views

SQL Server Partitioning, best practices for creating partition scheme's and functions

I'm implementing Partitioning for the first time in SQL Server 2008r2. I've several large tables that I am partitioning. My main question is should I use the same Partition Scheme and Function for ...
1
vote
1answer
669 views

Remote connection to SQL Server 2008 in LAN

I try many ways, but still doesn't work. MSSQLSERVER is running. SQL Agent is running. SQL Browser is running. TCP/IP is enabled (something else inside it must I change?) Named Pipes is enabled ...
1
vote
1answer
578 views

Can I install a 32-bit SQL Server 2005 alongside a 64-bit SQL Server 2008 installation?

The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC ...
1
vote
1answer
501 views

Can BES 5.0 Express database be migrated from SQL Server 2005 Express to SQL Server 2008 R2 Express?

Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general? If the database is backup ...
0
votes
0answers
46 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
0
votes
0answers
89 views

Upgrading SQL Server from 2008 to 2012 doesn't respect existing install paths

Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server ...
0
votes
0answers
53 views

How To Open/Edit Existing Report Server in Business Intelligence Development Studio

Hi we have a reporting server running in one of our server. I have been tasked to edit one report. I am new to reporting services and the one who made it is no longer part of the company. I have ...
0
votes
0answers
157 views

Application logs an INSERT into database but data is not there. Where to look for debug info?

I have a PHP shell application which essentially moves data from a MySQL table to a REMOTE MS SQL Server (2008 R2) server based on a number of business rules. This routine has been working flawlessly ...
0
votes
0answers
110 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
0
votes
0answers
100 views

Clients Unable To Connect To Server Or Database

We recently moved several of our servers and VMs from one location to another. We have already go through and set up DNS and given all the correct IPs for all the machines we needed but we have one ...
0
votes
0answers
229 views

Cannot add Domain Users to SQLServer security

I installed a win2008 server (WSQL) Its has successfully joined another Win2008 server which is the domain controller. Now back to WSQL machine, I connect it to the domain... And I install ...
0
votes
0answers
73 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
118 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
0
votes
0answers
825 views

How do you RESET the SQL Server 2008 TCP/IP Protocol settings back to default?

We have a SQL Server with multiple interfaces and a previous admin wanted to enable TCP/IP protocol to listen on a specific port. I believe that wherever he saw a specific IP address, he replaced it ...
0
votes
0answers
103 views

Remote SQL Server Connection works from SSMS but not from Application

We are troubleshooting a weird issue with our SQL Server 2008 server. The application server runs a windows service that makes a DB connection via a connection string in its config file, and we end ...
0
votes
0answers
989 views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
0
votes
0answers
153 views

Dummy transaction to check if a system is up

We want to send a dummy transaction through our system (Application - DB) to ensure it is still up every minute. If the transaction fails we are alerted - Thereby knowing within a minute if there is ...
0
votes
0answers
55 views

I must have done something wrong installing sample database

I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 ...
0
votes
0answers
132 views

Identical tables, different sizes?

I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express). I need to add another subscriber, and come to ...
0
votes
0answers
87 views

SQL failover cluster on single ESXi host

I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
0
votes
0answers
671 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
233 views

Download SQL 2008 R2 and install remotely with key

I have the media and product key for a copy of SQL Server 2008R2, however, I can not get my CD to the server at my data center. Is there a downloadable version (or can the trial be downloaded) of the ...
0
votes
0answers
40 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
239 views

Network adapter on Windows can't access local network

I have a HP server which has Windows Server 2008 as OS. I also have an Ubuntu server VM running with Hyper-V. My ubuntu server runs a web application which connects to MS SQL Server running on the ...
0
votes
0answers
125 views

SCOM 2012 with MS SQL Server 2008 Standard SP1

I've been trying to install SCOM 2012 on one machine with SQL 2008 Standard SP1... And I can't. During the installation of SCOM in the Operational Database phase, It WILL NOT connect to my SQL server. ...