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

learn more… | top users | synonyms

0
votes
1answer
301 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
1
vote
2answers
968 views

SQL Server 2008 Timeout Expired

I asked the question below on Stackoverflow without any answers, however, someone suggested I ask the question on serverfault also. Hopefully someone can help. I recently publish my ASP.Net MVC 3 web ...
0
votes
1answer
571 views

Perfomance of SQL Server on Hyper-V VM

I decided to try server virtualization and I have not had such an experience before. I installed Hyper-V Core 2012, created a virtual machine and installed Windows Server 2008. On this VM I should ...
1
vote
5answers
9k views

Remote connection sql server not working but if firewall disabled it does?

I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server ...
1
vote
1answer
4k views

How can I get SeSecurityPrivilege enabled?

I'm trying to install a hotfix for SQL Server 2008 and failing on the Rule Check with "Setup account privileges" failed. I am running SQL Server 2008 Standard on Windows Server 2008 R2. Searching on ...
2
votes
1answer
7k views

SQL Server 2008 R2 database stuck in single user mode

We tried to restore a database, and it failed for some reason. Now it is stuck in single user mode. Here is what I tried: select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame ...
1
vote
0answers
51 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. ...
0
votes
0answers
228 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 ...
1
vote
0answers
138 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 ...
0
votes
1answer
998 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
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 ...
2
votes
1answer
1k views

Error on CMDEXEC job step even with proxy account defined

I’m not yet used to managing permissions on SQL Server 2008. I’m currently trying to create a SQL Server job directly from SQL with a user that isn’t sysadmin (but has the role SQLAgentUserRole). ...
-1
votes
2answers
2k views

High memory usage, where is it coming from?

I have a virtual machine (Windows 2008 Server R2 64 bit running on vmware esxi 4) with 6 GB of installed RAM. It's reporting 95% memory usage and close to 0% CPU. This server hosts some WCF services ...
1
vote
0answers
148 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 ...
0
votes
1answer
402 views

Taking a disk image with Windows Server Backup while SQL Server is running

I'm using Microsoft's Windows Server Backup tool on a Windows 2008 R2 Server running SQL Server 2008. I want to take a disk image of a drive on which SQL Server is running (databases are on the drive ...
-1
votes
2answers
40 views

SQL Mirroring on Live System? [closed]

My project has a SQL 2008 database with production data on it in use at all times. We need to move our entire production network from one hosting environment to another. We've already stood up the ...
1
vote
1answer
1k views

Manipulate SBSMonitoring Database

Our SBSMonitoring database has reached its limit (10GB). I've worked with databases in a previous job and I'm familiar writing SQL queries. Is it safe to delete entries from tables in that database? ...
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
1answer
2k views

Backup and restore vCenter 5.5 in a Lab.

I need to take a copy of our production vCenter and run it in a lab for testing purposes. This part isn't my strong point.How do I go about this and is there any official documentation pertaining to ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
3
votes
2answers
3k views

Why is my database not available?

I have one database on my server that constantly becomes unavailable. To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open ...
0
votes
4answers
959 views

Monitor SQL Server

I am managing a very important SQL Server 2008 R2 database. I need a solution that notifies me through email if the performance of the database server is getting bad. I am imagining the following ...
-2
votes
1answer
70 views

0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a ...
0
votes
1answer
278 views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
0
votes
1answer
99 views

How do I know which node in a cluster answers?

I have set up an NLB with two servers (nodes) which are running the same service. The filtering is single host, because I don’t want them to run at the same time, because there is data in the cache ...
0
votes
1answer
884 views

Moving SQL Server 2008 R2 Logs Causing Access Denied Error

I have just tried moving the log location for the SQL server 2008 R2 logs as I have a fairly small System disk due to the massive size of the Winsxs folder, and now I am getting the following error in ...
5
votes
4answers
5k views

Can SQL Server 2008 Linked Servers be edited? Is there the equivalent of an ALTER statement for Linked Servers?

I have a Linked Server which was made using SQL Server Management Studio 2008. If the linked server destination changes, I will have to change the properties of it to direct to the right place. But ...
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
1answer
83 views

Is an HP Proliant 350e Gen8 server appropriate for Primevera and Sage applications? [duplicate]

I want to buy a server to accommodate both the Primevera and Sage applications? Would a HP Proliant 350e Gen8 do? Are there any concerns about this platform?
1
vote
1answer
9k views

“There are currently no logon servers available to service the logon request” when trying to remote desktop to a VM after a power failure

I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power ...
3
votes
4answers
24k views

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 ...
22
votes
6answers
66k views

How to rename a SQL Server 2008 instance?

How can I rename a SQL Server 2008 instance without reinstalling? For example, if the db is referenced as "MySQLServer\MSSQL2008", how can I rename to "MySQLServer\SQL2008"?
3
votes
3answers
101 views

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
0
votes
1answer
826 views

sql server 2008 cluster hang when a heavy load is run

we have a sql server 2008 active/active cluster running on wondows 2008R2 O/S. 14GB RAM, 4xCPU. we have set a ceiling of 12GB for sql server. We're running an agent job which loads 3 million records ...
0
votes
1answer
8k views

SQL Server instance service doesn't start

After manually stopping SQL Server instance service it can not be started both manually from a SQL Server Configuration Manager and automatically by restarting computer. If trying to do it manually I ...
1
vote
1answer
358 views

Where is my SQL Server 2008 R2 / Windows 7 install? [closed]

I ran the SQL Server 2008 R2 Install on my Windows 7 Professional (32bit) os. Everything ran fine, no errors. I ran the SP1 install, again, all green, no errors. I run the System Configuration Checker ...
6
votes
1answer
107 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
0
votes
1answer
241 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
1answer
53 views

SQL Backup very slow

I takes like an hour to backup my 24GB database. I put the backup on the same disk as the location of the actual SQL database, but I dont think thats the cause. When I execute exec sp_who2, here is ...
2
votes
2answers
2k views

SQL 2008. I have user in a db which has no login on the server. How is it possible?

I am talking about windows authentication. I dont have access to the server adming rights but a dbadmin sent me screenshot where my user is not in the logins of the server. and also there is only one ...
1
vote
3answers
691 views

Trigger Powershell Command to Copy SQL Backups to Network Drive

I've got two servers on a workgroup and I need to transfer my SQL Server 2008 Backups from the local drive of one to a network drive on another. Ideally, I'd like to have SQL call the Powershell ...
0
votes
1answer
436 views

How to resolve SSPI context error without changing Service Account from MSSQL

There is a issue while connecting from new Windows 8.1 Clients to SQL Server 2008 running on Windows Server 2008 R2. The SQL Service running under account Domain\mssqlservice on a machine thats works ...
2
votes
2answers
620 views

Perfmon for SQL Server from local machine

I'm following Brent Ozar's video on Benchmarking and Baselining, and I've got a data collector set on my local machine set up to hit a remote sql server, but I can't get the collection to start. I ...
2
votes
4answers
441 views

SQL Server Monitoring Packages [closed]

I'm looking into purchasing a SQL Server monitoring system. It should work with 2005/2008. We would like to monitor performance, availability, backups, jobs and various database issues (space) What ...
0
votes
5answers
5k views

How can I disable the windows authentication mode of SQL Server

How can I disable the windows authentication mode of SQL Server and restrict it to ask for username and password every time, with no windows authentication?
16
votes
3answers
11k views

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a ...
5
votes
3answers
5k views

Tracking SQL Server 2008 Timeout Errors

we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors. So I'm ...
18
votes
2answers
35k views

“'' is not a valid login or you do not have permission” on sql server installation

I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission. I use SYSTEM ...
2
votes
2answers
6k views

SQL Server remote backup query fails “cannot open the backup device”

I am trying to configure my scheduled backups of a MSSQL database to a mapped network drive, which is on a fileserver running Server 2003 Standard. Query reads like this: BACKUP DATABASE XXXX TO ...
1
vote
2answers
2k views

Installing a new SQL Server instance fails

I've previously in my setup installed SQL Server Express 2005. Now I've switched to SQL Server Express 2008. I updated the command line parameters to those documented for the latter. If the comp ...