Questions tagged [sql-server-2008]

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

240 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
1k 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 ...
4
votes
2answers
501 views

Scripting an automated SQLServer 2008 DR move

We use the built in logshipping in SQLServer to logship to our DR site but once in a month do a DR test which requires us to move back and forth between our Live and BAckup servers. We run multiple (...
3
votes
1answer
63 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 ...
3
votes
1answer
1k 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
0answers
3k 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 ...
3
votes
2answers
1k views

Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2

I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database. But I am getting the following error: 'notebook/iusr' is not a valid login or you do not have permission. I think ...
3
votes
0answers
387 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 ...
3
votes
1answer
216 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
2answers
8k 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 ...
3
votes
1answer
2k 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
6k 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 ...
2
votes
0answers
79 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
1answer
589 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
303 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
0answers
491 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
1answer
108 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
2answers
119 views

Sql Server 2008 Backup and Restore

I have a production critical database which is in Simple Recover Model Currently. We take a Full Backup Every night at 2:30AM. Now I have to change the recovery model back to full. I have to design ...
2
votes
2answers
430 views

Benchmarking MS SQL Server 2008

We have several production SQL servers, some physical, some virtual. I would really like some generic scripts that I could run against each maybe using AdventureWorks to stress test them and compare ...
2
votes
1answer
72 views

SharePoint 3.0 service account

We have a SharePoint 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
145 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
966 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 sp_addsubscription....
2
votes
2answers
533 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
2
votes
0answers
164 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 ...
2
votes
3answers
845 views

SQL 2008 - db mail issue

I have two instances of SQL Server 2008. One was upgraded from SQL Server 2000 and one was a clean, new install. The instances are running on different nodes of the same cluster, although I have ...
1
vote
0answers
38 views

Restoring SQL Database with NoRecovery stuck

We are moving from a SQL 2008 standalone instance to a SQL 2016 HA Failover Cluster Instance (FCI) with an AlwaysOn Basic Availability Group (BAG) configured to replicate to a standalone DR instance ...
1
vote
0answers
77 views

SQL Merge Replication Triggers Missing

In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot ...
1
vote
0answers
79 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
1answer
198 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
0answers
233 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
1answer
153 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
0answers
78 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
251 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
153 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
3k 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 ...
1
vote
1answer
4k 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
0answers
68 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
1answer
1k 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
0answers
206 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
526 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
1answer
859 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
2answers
228 views

What ports do I need to open up on my Win 2k12 server for MSSQL Express 2008?

I'm running Microsoft SQL Express 2008 on a Windows 2012 Server box. Got everything work, and I even manage to connect with the firewall down. But I dont really want the firewall turned off at all ...
1
vote
1answer
195 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
508 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
56 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
68 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
3k views

Unable to save view: “There is already an object named 'Quotes' in the database.” - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It ...
1
vote
0answers
408 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
13k 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
1answer
601 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
0answers
1k 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
2 3 4 5