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

learn more… | top users | synonyms

4
votes
1answer
160 views

What is the best way to replicate a large number of SQL 2008 DBs to a failover instance in Amazon Web Services

Our application creates a new sql database for every customer and we will be continually adding new customers and creating new databases every day. These databases can range in size from 3 megabytes ...
3
votes
1answer
199 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 ...
2
votes
1answer
351 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
411 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
191 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
98 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
838 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
44 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
84 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
537 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
3k 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 ...
0
votes
0answers
43 views

Weird issue in RDL on SSRS 2008

I'm the admin for our project's SQL Server 2008, with SSRS Standard Edition. We've encountered 2 issues with one recurring which we suspect it's a bug but we can't find any information on it. These ...
0
votes
0answers
39 views

SQL DTC Failover Scenario

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC ...
0
votes
0answers
71 views

SRSS Client Print Module must be downloaded every use

I am currently having an issue with SQL Server Reporting Services. Everytime a user clicks the print button for the report, the user must install the ActiveX client print module. The issue is that our ...
0
votes
0answers
430 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
34 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
26 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
47 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
58 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
77 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
277 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
138 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
565 views

Creating database from Entity Framework and Code First create database error

This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out. I'm running on MSSQL 2008 Express, EF5 and MVC4 My web.config file looks a bit like ...
0
votes
0answers
31 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
132 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
114 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. ...
0
votes
0answers
1k views

Fatal error 9001 on shared SQL Server 2008

I've asked this same question on StackOverflow, but I might actually have a better chance for an answer here so am posting here as well. I know this question has been asked here before, but none of ...
0
votes
0answers
81 views

401 accessing SQL Reports in SharePoint 2010 through UAG 2010

Simply put, when I try to access SQL Reports through SharePoint 2010 remotely I get a "The request failed with HTTP status 401: Unauthorized." error. When I access it locally the reports load up just ...
0
votes
0answers
298 views

SQL Server Reporting authentication not working

I'm not exactly sure what went wrong but our SQL Server Reporting Services authentication is no longer working correctly. When I try to load the site, it asks for a username and password, and mine ...
0
votes
0answers
134 views

How to speed up SQL Sever - More RAM didn't work

We have a server with 48 GB RAM on it. We're running some pretty heavy processes on SQL Server 2008 64 bit, but it tops out at 3 GB and won't use any more. It only uses about 15% of the CPU. The ...
0
votes
0answers
191 views

MS Sql Database is not responding in random manner

I've created a database in MS-SQL and used it in my application. But sometimes it doesn't responds randomly and throws an exception System.Data.DataRowView' does not contain a property with the name ...
0
votes
0answers
1k views

SQL Server error: Error: 802, Severity: 17, State: 20

I'm randomly getting this error while running a script... Exception calling "ExecuteNonQuery" with "1" argument(s): "An exception occurred while executing a Transact-SQL statement or batch." ...
0
votes
0answers
387 views

SQL 2008 Standard R2 - MSA vs Virtual Accounts vs Domain Accounts?

Just wondering if someone could point me to the right direction. Im about to implement an SQL server on the DC machine. I know that it is not recommended to run the SQL server on the DC but that is ...
0
votes
0answers
114 views

Can not connect to MSSQL Server 2008 Express

I'm trying to connect to a Microsoft SQL Server 2008 Express edition over the internet. Connecting to the server over LAN works just fine. I have opened port 1433 on the firewall and set the ...
0
votes
0answers
54 views

SQL Server 2008 failover clustering

Yesterday a power surge took out our SQL Server. Had to have the motherboard replaced and everything. Not good. Anyway, I'm now looking into failover clustering to prevent such an event from ...
0
votes
0answers
112 views

SQL Server datetime discrepancies between Ubuntu PHP servers

I have 2 servers, each running the exact same version of PHP (5.3.5-1ubuntu7.8). They are also the exact same version of Ubuntu (11.04). I have written a PHP script to connect to a SQL Server 2008 R2 ...
0
votes
0answers
331 views

SQL Server Management Studio 2008 won't open

I'm trying to open SQL Management Studio 2008 to attempt to work with a server I have just set up, and to import an .sql file, but for some reason when I attempt to install and run the software it ...
0
votes
0answers
87 views

Column level Data in sqlserver 2008

My company uses laptop to Enroll customers in the remote villages. At the end of each business day the records are sync to the Central Database(SQLSERVER 2008). I want to Encrypt all the column in my ...
0
votes
0answers
2k views

What is the FT_IFTSHC_MUTEX wait type in SQL Server 2008 R2?

I have seen some people include this wait type in their list of safe-to-ignore wait types, and they reference this blog as the source: ...
0
votes
0answers
1k views

Can't install SQL Server 2008 on Windows 7 pro x64? Why Failing?

Getting installation failed and links lead me to this log. I've tried about 3 times now after removing prior installs and doing a windows update that just install Windows 7 sp1. Where exactly can I ...
0
votes
0answers
35 views

MSSQL doesn't start consistently

On my dev box, MSSQL is set to "Automatic," but it doesn't start with boot every time. If it didn't start EVERY time it would at least make sense. Sometimes it starts, sometimes it doesn't, completely ...
0
votes
0answers
51 views

SQL Connection Error

I am getting this error while trying to access my website: Exception information: Exception type: SqlException Exception message: An error has occurred while establishing a connection ...
0
votes
0answers
233 views

Why getting access denied when installing SQL 2008 R2? (installing with full admin credential)

I started to work on a home based play project where I wanted to create at least 2 VM (using vmware). Server 2k8 went good. then I moved on to setup AD (DC) and completed this piece. next step was to ...
0
votes
0answers
180 views

SQL Server Agent job “dropping” steps

I've got a couple of maintenance plans that back up my databases. In the related sql agent jobs, there are multiple steps - run the maintenance plan, send success/failure email based on the outcome ...
0
votes
0answers
621 views

“1% is not a valid win32 application” Sql Server Setup

I am trying to install Sql Server 2008 R2 Express(x86) to my Windows Server 2008 Server(32bit) machine since yesterday evening but I am having this weird error during installation progress. "1% is not ...
0
votes
0answers
191 views

SQL 2008 R2 Memory Consumption

Following situation: VMWare with Microsoft Server 2008 Enterprice edition 64-bit (4CPU and 32 GB RAM) SQL server 2008 R2 64-bit enterprise. In the taskmanager the SQLServer only takes up about 12 ...
0
votes
0answers
168 views

Unable to install SQL server 2008 after uninstalling it twice (VS2010 is available in system)

Due to some reason i uninstalled sql Server 2008 from control panel(add remove program) I Installed SQL server twice, but it failed everytime. Last time at Installation progress task it failed for ...
0
votes
0answers
26 views

How to fetch REQUEST PROCESSING FLAGS of IIS server

i am developing monitoring software for a variety of servers (including SQl server). I need to detect hung transactions, track them , etc etc. I am using C# to collect the perfmon counters. But i need ...
0
votes
0answers
231 views

Could not connect with Instance of SQL SERVER from LIVE server to server in office

Scenario: LIVE Server: 210.210.210.210 External IP of Office: 111.111.111.111 SQL server on a server machine in office, machine name: MyMachine Another SQL server on another server machine in ...
0
votes
0answers
630 views

SQL Server 2008 Server-Side “Invalid userid” (Error 18456, Severity: 14, State: 5)

Errors Database administrators report Microsoft SQL Server 2008 server-side error "Invalid Login" (error 18456, Severity: 14, State: 5). Error examples from the server log: Dec 1 2010 10:12AM - ...