0
votes
0answers
29 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 ...
1
vote
3answers
43 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
0
votes
0answers
56 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
100 views

Website display of character encoding does not match up with config files

I have a language problem which I couldn't solve, no matter what I did, I request your help with this. I do web-publishing using Xampp on Windows 2008 Server R2 Enterprise (Language: English, ...
0
votes
1answer
60 views

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote ...
0
votes
0answers
52 views

Proxy DMZ server to bounce data between sql server and clients

Is this feasible? I have a sql server that is setup behind a corporate firewall. I have clients that need direct connection to that sql server via ODBC. Instead of punching holes in the firewall I ...
1
vote
0answers
38 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 ...
0
votes
1answer
102 views

Best Practices Analyzer for Microsoft Dynamics AX 2009

We recently uncovered a potential issue with our Dynamics AX setup whereby Receive Side Scaling (RSS) was not enabled on our AOS servers, which we believe is limiting their performance (currently ...
0
votes
1answer
123 views

opening firewall 1433 port to IP address that require a direct connection

We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2. New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be ...
1
vote
0answers
256 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 ...
0
votes
1answer
53 views

What are the things to look out for when adding other domain user to your IIS?

I have a Windows Server 2008 R2 called Jack11 that joined a domain called Watson.org. It has IIS 7 installed. From my understanding, we need to add the following into the web.config file ...
0
votes
1answer
29 views

Login Failure issue - SQL Server 2008 SETUP on Windows Server 2008

Hi I am trying to upgrade Edition on SQL server 2008 on Windows Server 2008 and while the Setup it checks all the system requirements and When in the end i click Upgrade It gives me error that ...
0
votes
0answers
341 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
1answer
172 views

Is it possible to batch restore backups and remove users from databases in MSSQL 2008?

We're having to do an emergency migration of all of our MSSQL databases from a dying box to a new shiny instance of SQL2008. Unfortunately, we're having to do it by restoring from nightly backups ...
0
votes
1answer
197 views

Problems Installing SQL Server 2008 on Windows Server 2008 R2 Standard SP1

I'm attempting to install SQL Server 2008 on Windows Server 2008 R2 Standard with SP1, and am failing the "Operating system supported for edition" operation in the Installation Rules portion of the ...
2
votes
1answer
731 views

What the best way to achieve RPO of zero and lowest possible RTO (less than 15 minutes) with SQL 2008 R2?

We are running a payments (EFT transaction processing) application which is processing high volumes of transactions 24/7 and are currently investigating a better way of doing DB replication to our ...
0
votes
1answer
104 views

Data transfer between servers extremely slow

I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same ...
2
votes
1answer
669 views

Being Flooded with Security Event ID 4793 - Windows 2008 R2

I have a SQL server that is a domain member running Windows 2008 R2. It is a cluster node in a failover cluster. The security event log is getting flooded with these: Log Name: Security ...
1
vote
2answers
938 views

How can I determine what is sending so much data from my Windows Server running SQL Server?

I have a SQL Server that is continuously sending data out the network interface. The data that is being sent is too high; about 7MB per second. I have scanned the server with anti-virus but haven't ...
0
votes
2answers
133 views

New server: use for SQL Server or Windows (Web)? [closed]

I picked up a new Dell R410 2.8 Ghz 12M cache 32 GB Ram RAID-1/RAID-1 for a good year-end deal. It was purchased mainly to replace my Dell PowerEdge 2850 which is my main WEB server. I run Windows ...
0
votes
4answers
2k views

Does sql server standard come packaged with windows server 2008 r2?

Does sql server standard come packaged with windows server 2008 r2?
2
votes
1answer
64 views

Database unusable whist doing a database restore (SQL Server 2008 R2)

I was asked to create a database from a backup for reporting and whilst transferring the file from backup to a disk on the server the database became unusable. Then again whist running the restore ...
3
votes
3answers
354 views

SQL Server 2008 Workgroup Edition on virtual server with no swapping

I have rented a virtual server with 4 GB memory from Hosteurope, including a license for SQL Server 2008 Workgroup Edition. It works alright and is plenty fast, but whenever I put some load on it, it ...
2
votes
1answer
78 views

Install Different SharePoint Servers using Single Database Server

I have a database server in my network running SQL 2008 R2. I have SharePoint 2010 installed on a separate server and using the above server for database storage. I want to install a new Project ...
0
votes
4answers
439 views

Windows Server 2008 R2 secure enough for internet without 3rd party (hardware) firewall

I need to setup a Windows2008 Server R2 incl. SQL Server and IIS. The server is as far as I know directly connected to the internet. My question is, is Windows 2008 R2 Server secure enough for this ...
0
votes
1answer
71 views

Remote connect to SQL Server 2008

I have a problem connecting with a remote Microsoft SQL Server 2008 I have tried this: How to enable remote connections for SQL Server 2008? so the remote connection checkbox is checked at the ...
1
vote
2answers
160 views

Xen virtualized Server 2K8R2 w/ SQL 2K8 becomming unresponsive

About a year ago, we virtualized most of our small business Windows and Linux infrastructure, which included starting a fresh (not P2V) Server 2008 R2 VM. This performed acceptably until a few weeks ...
2
votes
1answer
4k views

SQL2K8 Backups over an NFS mounted SAN

We have a SQL2K8 server with a 100GB+ database that mostly stores image BLOBS and it fails to backup to our SAN that is connected over NFS. The SQL2K8 server runs off our VMWare Host and it losses ...
1
vote
1answer
1k views

SQL Server 2008 second instance times out when logging in — but only the first time?

This is a strange one that has plagued me for a while now. When logging in to the second instance of SQL Server 2008 on one of our database servers, we get a timeout error: Cannot connect to ...
1
vote
0answers
1k 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
1answer
200 views

Unable to Install SQL Server 2008 on Win Server 2008 R2 Datacenter

I have been trying for the past three days to install SQL Server 2008 with SharePoint integrated mode in VMware Player, however I keep getting the following error: Reporting Services in SharePoint ...
4
votes
3answers
637 views

Max and Min Memory Setting

One failover cluster has 2 nodes with 64GB RAM each: - Node A and Node B. Node A run 2 SQL instances (SQL1 and SQL2). Node B runs 1 SQL instance (SQL3). SQL1 has a max server setting of 30,720MB ...
1
vote
4answers
1k views

SQL Server pegging CPU but only using 2GB Ram?

I know nothing about SQL I'm going to put that out there. Our dev people have said this is an OS problem. Can you help me figure out where to start to determine if this is an OS issue? SQL isn't ...
3
votes
2answers
2k views

Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?

Related Perfmon: which counter identifies that threads are waiting? but sadly abandoned by the asker Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and ...
2
votes
1answer
178 views

What's the best use of 4 nics for Hyper-V?

I'm running several Dell R710's, each of which is outfitted with 4 x Broadcom BCM5709C nics. Two of these R710's are running Hyper-V and a third is running SQL Server 2008, each running Windows ...
0
votes
2answers
249 views

MVC2 Application Performance on Windows Server 2008 R2 with IIS7.5

I originally posted this on StackOverflow but I feel as though the problem lies with the hardware / OS configuration. I'm hoping that someone here has had a similar experience and can offer some ...
0
votes
1answer
124 views

How much and why may a windows domain controller affect performance of sql-server?

Excuse me by asking somehow vague. Please let me be more precise: can anybody please explain me the networktraffic between sql-server and domain-controller on a installation following microsoft ...
0
votes
1answer
135 views

How much and why may a windows domain controller affect performance of sql-server? [closed]

I assume a state-of-the-art installation therefore nothing weird like DC and SQL-Server on the same machine. Think about an installation following the commendations of microsft and all the recommended ...
0
votes
1answer
2k views

SQL Server 2008 R2 Quiet Installation Failure

I've downloaded the SQL Server 2008 R2 software from Microsoft and am working on scripting a silent installation. I'm getting the following errors (and the duplicate paste job is not an accident, ...
3
votes
2answers
198 views

Does anyone know where I can find “proof” that SQL's Fiber mode is barely faster than regular thread mode on Win 2008 R2

I remember seeing a PDC presentation on the Windows Kernel regarding Threads vs Fibers and in it Mark R. mentioned that this caused SQL's Thread mode to run almost as fast as Fiber mode, but with ...
0
votes
1answer
56 views

is it possible to run a different version of sql server trial once you've already run one?

e.g. Have already installed trial version of SQL Server Enterprise Edition 2008 R2, is it now possible to switch to a trial version of the Developer edition?
6
votes
6answers
25k views

Can't connect to SQL Server 2008R2 on Windows Server 2008R2

I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows ...
3
votes
2answers
216 views

Should SQL Server 2008 only be run on Server 2008 R2 (64 bit)?

Today I was told that SQL Server 2008 is supposed to be run on Server 2008 R2 (64 bit). Is this true? And if so, can anyone explain why? Our development instances are running on 32-bit systems. I ...
0
votes
1answer
546 views

Raid Caching configuration suggestions

I'm wondering if there's the optimal Cache setting for the following Raid controllers and raid setups. (OS: windows 2008 R2, App: II7, DB: SQL Server 2008 R2 Enterprise) PERC 6/i: (The default ...
0
votes
1answer
536 views

Error Configuring Reporting Services on Windows Server 2008 R2

I'm installing a TFS2010 with Reporting Services (SQL Server 2008) but I'm getting an error, below are the details and steps I did: I'm installing with a domain account who is also a local ...
3
votes
6answers
1k views

SQL Clustering on Hyper V - is a cluster within a cluster a benefit

This is a re-hash of a question I asked a while back - after a consultant has come in firing ideas in to other teams in the department the whole issue has been raised again hence I'm looking for more ...
0
votes
1answer
417 views

SQL 2008 SP1 crashing almost daily

almost every day our new DB crashes. It is virtual server residing on same hardware as 5 other servers, two of them beeing identical MS SQL2008sp1 and two Oracle 11g's so I can pretty much rule out ...
1
vote
2answers
2k views

Intermittent timeout when connecting to Sql Server, what do I look for?

Sql Server 2008 Standard 64bit on Windows Server 2008 R2 virtual machine hosted on a Hyper-V server. I'm getting intermittent timeouts when connecting to the server. This happens for both windows ...
2
votes
4answers
1k views

Which SQL Server version to install on Windows Server 2008 R2

We have a test server running Windows Server 2008 R2 that I want to put SQL Server 2008 onto. I have an MSDN subscription and thought I could install (x64 version) SQL2008 but the installation warned ...
1
vote
1answer
1k views

Windows Backup failed as another backup or recovery is in progress

i have set up backup schedule on our server. SQL Server 2008 to 01:00am on windows server 2008 R2 to 4:00am. Sql backup runs well, but system backup ends sometimes with error. The error is : ...