Hi All, Was wondering if anyone could tell me the potential issues with downgrading from SQL2005 x64 EE to SQL2005 x64 SE. From what i can see this...

Rob M

03-09-2009 01:22 AM
Rob M

I'm trying to install the 64 bit edition of SQL Server with Tools. It is asking me to install Windows Installer 4.5. Unfortunately, I am unable...

Lee

03-08-2009 02:40 PM
thejamie

SQL Server 2008 won't install and the reason it gives is that Visual Studio 2008 is not upgraded to SP1. After opening VS2008 to be sure that is not...

thejamie

03-08-2009 02:36 PM
thejamie

After reading up on this some more, the rule of thumb is that SP1 also does not install properly on VS2008. If you update VS2008 with SP1, it...

thejamie

03-08-2009 02:30 PM
thejamie

I am testing a restore senerial of master. The original master files have been renaming. Executed following script to recreate master but have...

SQLDBALIZ

03-06-2009 09:02 PM
Mohit K. Gupta

Try asking them here. x-posted to:...

Dave Patrick

03-06-2009 12:49 PM
wipeout64@hotmail.com

Hi, I need to backup couple of sql server databases. I would like to schedule the backup every night at 11 so that a backup is created every night. I...

Jack

03-06-2009 12:22 AM
bass_player

Hi to all ! I want to Setup new Hardware for Migration from Server 200 Cluster System with SQL 2000 to Server 2008 with SQL 2008 Standard. I plan...

Joern Henrichs

03-04-2009 03:17 PM
Chris Wood

I am running Server Enterprise x64 Edition R2 with SP2 and when I try to install SQL Server x64 install I get the error "setup.exe is valid, but...

Hobbes80

03-03-2009 10:35 AM
Hobbes80

Hi, I want to do the following: 1 database server 1 reporting server On the reporting server the reporting databases are installed. Then I want to...

Mark

03-03-2009 06:53 AM
Mark

Hi, I'm trying to completely uninstall SQL Server 2005 Developers Edition from my machine following the instructions...

Eric Yeoman

03-03-2009 03:20 AM
Hank Arnold (MVP)

I have SQL 2008 running on my computer, but I am taking a sql class using 2005, I can import 05 projects and databases, but then I need to take my...

Donica

03-02-2009 11:34 PM
Donica

Ekrem, My problem was that DTC was not setup to run in a cluster. The following article help me setting this up right: How to configure...

Germex

03-02-2009 10:27 AM
Germex

Hi, I am trying to install sp3 on sql2005 sp2 64bit named instance The default instance is sql 2000 I am getting many errors as you can see in...

tsadok03

03-02-2009 03:00 AM
tsadok03

1) When I was doing sql 2k5 upgrade from sql2000. I got some errror: UpgradeAdvisor returned -1... I uninstalled all the.net 22.0, 3.0, 3.5...

ginger

03-01-2009 03:22 PM
ginger8990

SQL 2000 Standard SP4 version 8.0.0.2055 I am trying to apply hotfix KB948111 to bring it to version 8.0.0.2273 When I run the hotfix it will not...

Thomas R Grassi Jr

02-28-2009 09:56 AM
Thomas R Grassi Jr

When installing SQL Server 2005 on my server, the client tools were installed includeing BIDS. On my development workstation, I just installed the...

Mike M

02-27-2009 10:06 AM
Mike M

I am trying to learn some fundamentals, but the problem is that basic information is not being provided in the setup program for SQL Express...

JRL

02-26-2009 02:59 PM
Richard Mueller [MVP]

I'm moving from SQL Server 2000 to SQL 2005 on a new server. I have installed the Upgrade Advisor on the new server and point it to databases on the...

Don

02-26-2009 01:11 PM
Don

Hi, We are using Microsoft SQL Server 2005 SP2 on a dual quad core machine with 4GB ram. This machine was running fine until suddenly...

Andrew Hodgson

02-25-2009 04:57 PM
Andrew Hodgson

In the SQL Server 2005, I create a script by a right click on a view - Script View -> Create ... I get a Create View script and with the additional...

Vik

02-24-2009 02:37 PM
Vik

(cross-post added to SQL Setup) "Chris Wood" <anonymous (AT) microsoft (DOT) com> wrote Not necessarily. E.g. have you checked that all...

Robert Aldwinckle

02-24-2009 09:34 AM
Chris Wood

I've got SQL 2005 Express installed on my SBS 2003 SP2 server. Looking at my Program Groups I can see the Microsoft SQL Server 2005/Configuration...

AllenM

02-23-2009 04:19 PM
Aaron Bertrand [SQL Server MVP]

Hi, Running 2005 64-bit on a 2003 64-bit server with 6GB of RAM. When I go into the server properties on the memory tab, I see the maximum server...

Linn Kubler

02-23-2009 03:20 PM
Russell Fields

Yes, the only message I got. In event viewer, there was an information message saying msinstaller and sql 2005 install failed. In SQL logs: there...

ginger8990

02-23-2009 12:29 PM
ginger8990

We know about the fix/workaround, which is to uninstall XML via the Windows installer cleanup utility. Question: When is MS going to give us a...

John

02-21-2009 07:58 AM
Aaron Bertrand [SQL Server MVP]

POST WINDOWS INSTALLER CONFIGURATIONcan not install, setup ends with Access is Denied. the service account is a local admin, network admin, and has...

RayW

02-18-2009 05:24 PM
Aaron Bertrand [SQL Server MVP]

Gary, Here are a few links of solutions to this problem with 2005 and...

Russell Fields

02-18-2009 08:16 AM
Russell Fields

I am installing SQL 2008 Enterprise x64 to Windows 2008 Enterprise x64 SP1. I run the "System Configuration Check" item and get one error. The error...

Joseph Liu

02-18-2009 01:55 AM
Joseph Liu

My situation is rather an oddball. I am running from a wireless access point (192.168.1.1 with an address of 192.168.1.2) but the Access point is an...

thejamie

02-17-2009 05:02 PM
thejamie

This is an old question. If I re-map database to D drive but the logs and reporting are still on C:\---even maste and msdb.mdf are all located on...

ginger8990

02-17-2009 04:24 PM
ginger8990

Hi Jrl, From your connection string, the login account was the SQL login view, however the error message was for NT AUTHORITY\NETWORK SERVICE which...

JRL

02-17-2009 05:02 AM
Mark Han[MSFT]

Hello everybody. I supose I can install and run Sql2000 32bits on Window2003 64 bits and it will work, won´t it? but, the main question is, it is...

Toni Ortiz.

02-17-2009 02:43 AM
Toni Ortiz.

Is there a way to restore a database into SQL2000 that was backed up in SQL2005? I've heard that using sp_dbcmptlevel to change the...

Blaise

02-17-2009 01:17 AM
Ekrem Önsoy

Thanks for your reply. I have been analysing the I/Os from the various files and the User database has approximately 2/3rd of the I/Os and the Temp...

James Matthews

02-16-2009 10:11 AM
James Matthews

How do I get SQL 2000 Standard to version 8.0.2273 I have SQL 2000 Developers Edition on my PC and its version is 8.0.2273 I applied a hotfix...

Thomas R Grassi Jr

02-16-2009 03:15 AM
Ekrem Önsoy

Hello, I have very little experience in SQL and I have to build a server that will be hosting a SQL 2005 application. Back in 2003 I had to go...

Eric

02-15-2009 06:02 AM
Hank Arnold (MVP)

I've been working on this through several questions, none of which have really solved the problem. So I'd like to begin again, with a clear...

JRL

02-13-2009 03:59 AM
JRL

I have had sql2k5 installed on my machine for development purposes. However, I am only a regular "user" on the machine (and as part of the...

cksiz

02-12-2009 10:50 AM
cksiz

What will happen to my database, will it be erased ? "Ekrem Önsoy" wrote:

Leo

02-12-2009 03:13 AM
Leo

I have been trying to get membership working on SQL Express 2008, and I was having difficulty getting the network service to be able to log in....

JRL

02-12-2009 12:45 AM
Peter Yang

I created a database backup from an SQL 2005 server. Now I have SQL Express 2008, and I'd like to import the database which I made from 2005. When I...

JRL

02-12-2009 12:42 AM
Peter Yang

I have a 64-bit Windows 2008 server that I have installed a named instance of SQL Server Std 2008, 32-bit. I would have installed the 64-bit...

Art Frank

02-11-2009 05:19 PM
Art Frank

Hi, I am trying to install SQL Server with an option of multi language support. I have got few questions regarding this: What options should i...

Imran

02-11-2009 05:50 AM
Imran

I am using a new installation of SQL Xpress 2008 and Visual Studio 2008 (SP1s). Please review my setup steps, because I seem to be missing something...

JRL

02-10-2009 08:52 PM
JRL

what is the best way to set up sql server 2005 express? by default, I think system services is used to run the service. Can I use a regular user...

ts

02-10-2009 11:40 AM
Richard Mueller [MVP]

Hi, We have a SQL 2005 Server running both our Live (production) database and a Test version, usually just a backup of the Live db. To control disk...

Linn Kubler

02-10-2009 10:37 AM
Linn Kubler

I have two SQL servers both SQL 2000 SQL Server 1 version 8.00.2273 SP4 SQL Server 2 version 8.00.2050 SP4 I forgot which fixes I put on Server1...

Thomas R Grassi Jr

02-09-2009 06:42 PM
Aaron Bertrand [SQL Server MVP]

Our sysadmin is reinstalling Windows Server 2003 on our machine which is dedicated to running SQL 2005. We are considering reinstalling in 64...

Neil

02-09-2009 05:25 PM
Neil

I reinstalled SQL Server 2008 on my local development machine today. I reinstalled because I could not install the SilverLight development tools...

jloper

02-09-2009 10:59 AM
jloper