-2
votes
1answer
25 views

sql server 2005 on server 2003 slow performance [closed]

We are running a Windows Server 2003 r2 x64 with SQL Server 2005 (Production Server) on it. Our software provider usually access to our server to fix/update/add features to our systems ...
0
votes
1answer
1k views

Best practice on how to update & reboot a live server [closed]

We have a business critical server that has not been re-booted in over 2 years. It is running Windows Server 2003, with SQL Server 2005 (SP3), Visual Studio 2005 and 2008R2, and has numerous versions ...
0
votes
2answers
106 views

Less than 10% Free Space on Database Server

2-weeks ago one of our web servers CPU Usage started bottle-necking lot at 100% for long periods of time when an application runs and requests "sqlserver.exe"..When this app runs and does its ...
0
votes
2answers
28 views

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken ...
2
votes
1answer
91 views

Freqeunt Failure Audit errors on web server (MSSQLSERVER)

We have detected a lot of Failure Audit errors (MSSQLSERVER) on our Web Server for. Something like Login failed for user 'sa'. [CLIENT: 74.208.102.175] For more information, see Help and ...
0
votes
2answers
143 views

Windows Server 2003 Restarts after bootscreen

Im working with a dell server with windows server 2003, after installing SQL Server, the system restarts after bootscreen everytime. On options menu (when you press F8) I disabled "restart on ...
0
votes
2answers
102 views

Upgrade Windows Server Standard Edition 2003 to Windows Server Enterprise Edition 2003

Our client wants to expand RAM to its maximum on HP BL490c G6 server, but the issue is that MS Windows Server 2003 with Service Pack 2 (SP2) Standard Edition is installed there and it supports only ...
0
votes
1answer
84 views

Setup was unable to validate logged in user

I'm trying to upgrade SQL Server 2000 to SP4, so I can upgrade it to 2008 later, but I'm getting this error. I tried with windows login that have administrator privileges, and with sa password as ...
0
votes
1answer
9k views

Is it safe to shrink tempdb.mdf in MS SQL Server?

Hej, my TEMPDB.mdf grew up to 42GB on MS SQL Server 2005 installed on Windows Server 2003. Last date change is 31/01/2013 at night. So, I wonder whether this is ok to shrink it?
3
votes
3answers
727 views

What to check during a periodic system health check

I have been tasked with preparing a list of checks to do as a part of a weekly system health check routine which my team is supposed to do. The problem is neither I nor any of my colleagues have ever ...
2
votes
2answers
80 views

Converting a Windows 2003 server

We have a legacy database system based upon MS SQL running on Windows Server 2003. The client software will only run on Windows XP. We have recently had success converting a client into a virtual ...
1
vote
1answer
63 views

Is my server lacking storage space?

Looking for some help here. I have two ASP.Net web applications using SQL Server 2005 hosted on a dedicated Windows 2003 server. One of the applications only receives around 100 unique hits a day, ...
1
vote
1answer
301 views

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently ...
6
votes
1answer
5k views

Will SQL Server 2012 install + run Windows 2003

I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64? I don't intend to use this for production just for testing and ...
2
votes
3answers
2k views

Windows update keeps doing the same updates

I have searched relentlessly for a solution to my problem, but to no good end. I have a server which is having problems (almost) every night and the IT guy does not seem to be able to determine why ...
1
vote
1answer
71 views

Strange Server Problems

I'm having some server issues, hopefully someone might have some insight. There is one server in my workplace which is set up strangely and I don't understand it. Every machine can ping/access/share ...
0
votes
1answer
337 views

exe hangs when scheduled from SQL Agent, but fine when run by user

I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, ...
1
vote
4answers
3k views

Error Connection to SQL Server using [HOSTNAME]\instance or [FQDN]\Instance, [IP]\instance working

This one's kind of weird, at least to me. I've got MSSQL server 2k5 (STD) installed on Server 2k3 R2 SP2 (on account of some legacy software that doesn't yet support x64 or Server 2008), using ...
2
votes
4answers
352 views

Missing drive space in Server 2003

I have two drives used for SQL backups which for the last week have been acting strange - the free space indicated by windows is far off from what windirstat, etc indicates. There should only be about ...
1
vote
0answers
145 views

Amazon Cloud Services for Disaster Recovery

To simplify our environment, at it's most atomic level, we have a .NET website running on IIS 6 on one server and the website depends on data from a MS SQL 2005 database on another server. We have ...
3
votes
1answer
76 views

Windows Server 2008 or 2003 for SQL Server 2005

Is there a benefit of using Server 2008 over 2003 for SQL Server? Specifically 2005?
1
vote
1answer
1k views

How to use AWE for Windows Server 2003 (32-bit) and SQL Server 2005 (32-bit)?

The server is Windows Server 2003 SP2 (32-bit), running SQL Server 2005 SP3 (32-bit). I believe the server has 4 GB of physical RAM. The machine has crashed twice in the last week and it is a ...
0
votes
2answers
398 views

Native SQL logins timing out at login validation phase

The default SQL Trace of my instances shows the following issue for native SQL logins (non-domain accounts): Network error code 0xe8 occurred while establishing a connection; the connection has ...
1
vote
1answer
262 views

Attempting to open a dll whenever logging on to server after SQL Server upgrade to 2008 R2

The environment is Windows Server 2003 SP2 32-bit, SQL Server 2008 R2 SP1 When logging on to the server the following message box is displayed 'you are attempting to open a file of type 'application ...
1
vote
2answers
278 views

Apache + MS SQL, querys extremly slow remotly but fast localy

So, I have MS SQL Server 2008 running on a Windows Server 2003 machine in VMWare with a network interface set to host only. When I run my 'application' on apache (xampp) on the host machine and ...
2
votes
4answers
1k views

How to permanently delete data off Windows 2003 server?

One of our clients requires that at the end of the contract we "securely" delete all data from the server (including SQL Server). I think I need to deal with this in two parts. 1. SQL Server Data: ...
0
votes
1answer
96 views

SQL server 2005 Slow access

I got reports from users that the access speed has dramatically slowed down, when they try to access the database. Perfmon states: Cpu ~20% usage. RAM (3,5gb) 2.1gb in usage, 1.7GB for SQL HDD ...
0
votes
2answers
892 views

cannot change sql server 2008 express installation folder

I am trying to install SQl Server 2008 Express (not R2, and I can't move to that) on windows 2003. I downloaded SQLEXPR32_x86_ENU.exe from the Microsoft site and am going thru the installer. I want ...
0
votes
1answer
192 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
0
votes
2answers
342 views

Configure SQL-SERVER without running service

Is it possible to change the location of the temp.mdf or other files without starting SQL-Server? I wanted to reactivate an old server but one of it's USB hard disk was been already used somewhere ...
2
votes
2answers
1k views

Importing database from MS SQL Server 2003 to MS SQL Server 2008

I have 2 MS SQL Servers running on 2 separate domains and I'm trying to import data from 1 to the other. The 1st MS SQL Server runs on Windows server 2003. The 2nd SQL Server runs on Windows server ...
0
votes
1answer
273 views

Installing SQL Server on a Domain Controller

I want to install SQL Server on a Domain Controller ( windows server 2003 R2) but i have an error because SQL Server services can not run under a local service account or a network service account.
1
vote
1answer
187 views

Site resilience with MSSQL Servers

What I'm trying to do is set up a failover system between two MS SQL Servers. It needs to be active/passive, and allow weighting (so Site 1 is preferable, before Site 2). I've done this between our ...
2
votes
3answers
1k views

How can I speed up SQL Server queries on Amazon EC2?

Our SQL queries sometimes take too long. We have a Windows Server 2003/SQL Server 2005 setup. We have already created indexes everywhere that's possible. Can we get quicker disks? Any ideas from ...
8
votes
2answers
284 views

Ways to convince management of a high cost

new here, greetings and such. My problem is relatively simple, but the situation is a tad odd. Currently, I have just been hired on to improve (essentially fix) a server room for a health care ...
1
vote
3answers
359 views

MSSQL Server is inaccessible from other domain users

I am unable to connect to other machines with the same domain and network. SQL Server 2008 is running, I can connect locally with MSSQL01\Administrator and password using Windows authentication. ...
0
votes
2answers
193 views

Why does the MSSQL stay at “restoring… ” even after 2 hours?

I have backed up a database at my old server and restored it at the new server. I am totally new to MSSQL 2005 Server Express, so it took me quite a while. I spent 30 minutes to find out back-ups are ...
1
vote
2answers
2k views

Can't install SQL Express 2008R2- caspol.exe application error - the application failed to initialize

I'm trying to install SQL Server Express 2008 R2 on Windows 2003 Server (enterprise edition). I get the following error message: Title: caspol.exe - Application Error Text: The application failed ...
1
vote
1answer
390 views

If I set the Functional Level of the Forest & Domain to 2003, will Microsoft SQL 2000 still work properly?

Scenario: Windows Server 2003 (Domain Controller). SQL 2000 is running on a different Windows Server 2003 machine. SQL 2000 uses the domain to authenticate users. In order to do an Exchange 2003 to ...
1
vote
3answers
1k views

High CPU Usage (95-99%) for mssql on the server

our server is running win2003 with mssql 2005 on the same box with 2GB ram. the website itself is based on dnn 4. We are seeing these high cpu usage spikes (mssql) of 95-99% even with no ...
0
votes
1answer
868 views

SQL Server 2005 ASYNC_NETWORK_IO waits: can we just increase network buffer size? (How?)

We have a SQL Server 2005 (64-bit Std) on Win2k3 R2. We're seeing a disproportionate number of ASYNC_NETWORK_IO waits that (seem to) result in unavailability of the database, which slows or hangs our ...
5
votes
1answer
369 views

Windows Server Cluster & Strange Day Light Savings Time Behaviour

Over the weekend (Sunday March 27th) Daylight Savings Time kicked in here in Ireland and so all the servers (all win2k3 server) in our Production Environment updated their Times +1 Hour. However ...
3
votes
2answers
67 views

Reinstall Windows Server with SQL Server

I currently have a Windows 2003 server installed with SQL Server 2000 and 2005 on it. We have the disk partitioned in two: C: contains the operating system and applications E: contains the DB files ...
2
votes
1answer
196 views

Configure SQL Server 2005 to take advantage of 32GB of RAM on 64-bit version of Windows Server 2003

I'm looking for recommendations/best practices for configuring SQL Server 2005 to take advantage of a recent memory upgrade to 32GB of RAM. The OS version is Windows 2003 64-bit Enterprise Edition. ...
1
vote
5answers
2k views

Best way to improve disk performance (SQL Server 2000)

I am having some disk access issues on a web application. The main load is many concurrent inserts/updates/selects on large tables. It is currently a single 2ru rackmount running SQL Server 2000 and ...
1
vote
1answer
73 views

Combing two IIS6 server together

I have two IIS6 Servers. Server A has a few websites running on it Server B has more website running on it. Server B is being taken off-line and wish to run all the sites on it as it a higher spec ...
0
votes
1answer
788 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
0
votes
1answer
374 views

How can be cout \Process(sqlservr)\% Processor Time over 300 %

The counter, Process(sqlservr)\% Processor Time, is hovering around 361% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
0
votes
1answer
1k views

diagnosing OLEDB 80004005 E_FAIL errors

I'm trying to diagnose what is causing regular crashes and hangs in one of our database applications. Operating system is windows server 2003, database server is SQL server enterprise 2005. We ...
2
votes
1answer
90 views

Move clustered SQL from one network to another

We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway ...