0
votes
2answers
27 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 ...
0
votes
3answers
312 views

Increasing vCPUs for Server 2003?

I have a VM running Server 2003 and SQL Server 2008 on VMware ESXi. Can I safely assume this configuration can cope with a change to the number of vCPUs? Are there better solutions to address the ...
0
votes
2answers
159 views

Server failed, can I retrieve my database from the my hard disk?

I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the ...
6
votes
2answers
399 views

Windows File Cache drops suddently

I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory. SSAS relies to a ...
1
vote
1answer
209 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 ...
0
votes
2answers
547 views

Installing SQL Server 2008 SP2 fails in 2003 cluster setup

When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem: Rule "Not clustered or the cluster service is up and online." failed. ...
0
votes
1answer
233 views

Windows 2003 IIS webserver (testserver) is slow

I have a test environment for my Asp.Net 4.0 web applications. It runs on a Dedicated Windows 2003 Webserver (IIS 6) But it's slow! The machine never has 100% cpu and the same for memory. When I run ...
0
votes
2answers
656 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
147 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 ...
2
votes
2answers
769 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 ...
1
vote
1answer
381 views

How to configure Munin to montior Microsoft SQL Server 2008

Is it possible to configure Munin to montior Microsoft SQL Server 2008? On Windows 2003 Server.
0
votes
2answers
125 views

How do I give HOSTNAME\Administrator access to MSSQL01 MySQL service?

I got this far... but there are no Computers listed... while there are 3 other domain members: DC (Domain Controller), VCENTER and BACKUP. I wish to give both VCENTER\Administrator and ...
1
vote
3answers
339 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
1answer
141 views

Problem updating SQL Server 2008 Warhouse Cube

We have a TFS 2008 running on a SQL Server 2008 as base (Windows Server 2003 R2 32 Bit Version). Short time ago I discovered that the Warhouse data (used by reports and analyzer Service) isn't ...
2
votes
3answers
206 views

HA suggestions for geographically separated sites

I have 6 instances of sql server that I need to be highly available by being hosted on two sites (one as principal, one as DR). Transparent automatic failover is required. Most are fairly boring and ...
1
vote
1answer
125 views

SQL Server 2008 Reporting Services on Windows 2003

Will SQL Server 2008 Reporting services work if it is install on Windows 2003? Anyone have any experience with this?
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
413 views

Install my own SQL Server 2008 copy on Amazon

Can I install SQL Server 2008 Standard Edition that I got though BizSpark on Amazon EC2?
0
votes
1answer
466 views

SQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server access

Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in ...
0
votes
2answers
2k views

How can I diagnose the cause of unexpected restarts on a Windows Server 2003 VPS?

At first I always assumed this was the host applying updates or doing some maintenance. But after contacting the company, they assure me I would have received prior notice before any such event. In ...
2
votes
2answers
345 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
3answers
4k views

Add the current admin user to SQL Server Express 2008

I have managed (in 'eksperiments') to remove both my Windows users from my SQL Express instance. I am now logged in as windows admin, and have re-created the corresponding SQL login, but I cannot ...
0
votes
2answers
95 views

Migration Windows 2003->2008, SQL2005->2008

We have some servers with Windows 2003 and SQL Server 2005 and would like to upgrade them to Windows 2008 and SQL2008 because of the new cool features. How can that be done? Anything in particular to ...
2
votes
1answer
568 views

NAT: Exposing SQL Server 2008 Express to the internet

I have a Windows Server 2003 SP2 machine with SQL Server 2008 Express installed. I have my network configured with a NAT. Internal clients can access the instance of SQL Server without a problem. I ...
3
votes
2answers
961 views

Hardware Requirements of SQL Server Clustering

My task is to do clustering in SQL Server 2008. What are the hardware requirements for windows clustering? Is either SCSI or SAN compulsory, or is shared disk enough? I can't understand the hardware ...
0
votes
1answer
389 views

NT to unix password sync service?

I am developing using VSTS 2008 + C# + ASP.Net on Windows Server 2003 x86 to develop asp.net application with SQL Server 2008 Express. I find sometimes my system is very slow (not very responsive) ...
1
vote
3answers
70 views

What is wrong if a dedicated SQL-Server 2005 on a win2003 Server creeps

i have a sql-server 2005 on a win2003 32-bit (3,5GB RAM) 4 CPU Server with a RAID 5 Disk-Array which perform at 1/10 of a virtual 2008-SQL-Server Win2008 32 Bit 2GB RAM Raid 5 Server. The Job is to ...
0
votes
2answers
927 views

Windows Server 2003 supports SQL Server 2008 Express edition?

I am wondering whether we could install SQL Server 2008 Express edition on Windows Server 2003? Or only SQL Server 2005 Express is supported on Windows Server 2003? thanks in advance, George
0
votes
2answers
2k views

Web server connection to SQL Server: Response Packet [Malformed Packet]

I am seeing very, very sluggish performance between my web server (which handles HTTP web services connections) and a separate server running Microsoft SQL Server 2008. I have been capturing packet ...
0
votes
1answer
268 views

SQL Server connection issue

I am using VSTS 2008 + .Net 3.5 + C# + SQL Server 2008 Enterprise on Windows Server 2003. I am using the following connection string, and labtest1 is the local machine name and I connect from local ...
3
votes
3answers
3k views

SQL server could not connect: Lacked Sufficient Buffer Space

I recently moved my app to a new server - the app is written in c# against the 3.5 framework. The hardware is faster but the OS is the same (Win Server 2003). No new software is running. On the prior ...
0
votes
1answer
55 views

SQL Server and Operating System Combination Sacrifices

Since most responders like to understand why the question is being asked, I offer this brief preface. . . I am in the process of preparing a version migration document for a state government agency. ...
0
votes
2answers
434 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...
0
votes
2answers
932 views

Sql Server 2005 Express & Sql Server 2008 side by side

I have a Win2003 system that serves CAD drawings thru an SQL SERVER 2005 Express. I need another installation of SQL SERVER 2008 for an ERP on the same server. There are any known problems or issues ...
1
vote
5answers
1k views

SQL Server 2008 Log-shipping: Without a UNC drive: how? [closed]

My real question here is... is there a tool I can use? (E.g. I have a lot to do, and would prefer not to script it all up myself!) Anyone using the redgate (hmmm, they had a tool for this, but I do ...
0
votes
3answers
1k views

SQL Server 2008 faster in Windows XP than in Windows 2003 Server R2

The Windows XP configuration is a generic computer with a Pentium D 2.8GHz, 1GB of RAM, with Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Build 3790: Service Pack 2) The Windows Server 2003R2 is ...
0
votes
4answers
11k views

Can't access SQL Server 2008 from workstations, but can from server

We have an app that can use mssql2k or 2k8. We've been using 2k but I decided to try 2k8 to compare. I installed in on our win2k3 server alongside mssql2k. In the ODBC applet on the server, I was ...