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

I'm trying to install SQL Server 2005 developer edition on my PC. I have .Net Framework 2.0 SP2 installed. Setup fails at the pre-req stage whilst...

DevMountain

02-09-2009 10:51 AM
DevMountain

I'm trying to install SQL Server 2005 developer edition on my PC. I have .Net Framework 2.0 SP2 installed. Setup fails at the pre-req stage whilst...

DevMountain

02-09-2009 10:49 AM
DevMountain

Hello, I am using VWD and SqlServer 2008 Express. Just this error message: Cannot open user default database. Login failed. Login failed for user...

SaintX

02-09-2009 12:57 AM
Ekrem Önsoy

Dear All, I am using the following command line arquement (including INSTALLSQLDIR) to install SQL Server EE through silent mode. It installs in...

charlierp

02-08-2009 10:59 PM
charlierp

Windows XP Pro. When I try to install the subject, it indicates that it installed successfully, but when I reboot, it is still in the update list...

Gary Phillips

02-08-2009 08:01 PM
Vidhya Sagar

I have a computer on my network that is hosting SQL express and its IP is: 192.168.0.22 I can connect just fine with SQL Management studio express...

Robbie

02-08-2009 01:39 PM
Rob

Have a headache with SQL 2005 SP3 on the net administrator's laptop (64 bit XP Sp3 urghh) - there are two versions of SQL on the machine. One...

thejamie

02-08-2009 11:58 AM
thejamie

Trying to install new SQL Server Failover Cluster; Make it all the way through to the Server Configuration tab where Service Accounts are specified. ...

Jim Newell

02-07-2009 11:12 AM
bass_player

I created a virtual machine(2007), installed windows server 2008 Ent and then installed Sql server 2008. Now I am trying to install windows installer...

SQLStudent

02-07-2009 11:08 AM
bass_player

Trying to install new SQL Server Failover Cluster; Make it all the way through to the Server Configuration tab where Service Accounts are specified. ...

Jim Newell

02-07-2009 10:26 AM
Jim Newell

On Feb 6, 3:40*pm, "jloper" <jlo... (AT) lopers (DOT) org> wrote: i've run SQL 2005 Dev and the full version of VS on a machine before. my usual...

Alen Teplitsky

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

Hello, Our users are setup using MSDE, and we would like to get them on SQL Express 2005. Can the installation for the upgrade be done in a way to...

Greg

02-06-2009 11:23 AM
Richard Mueller [MVP]

I’m trying to install SQL Server Express 2008 on a development computer that is also running 2000 Personal and 2005 Express. However I’m stopped...

KenW

02-05-2009 04:22 AM
Ekrem Önsoy

When I open a table or a view in SQL Server 2005 a Change Type button on a Query Designer toolbar is disabled. How can I enable it? Thanks.

Vik

02-05-2009 02:26 AM
Ekrem Önsoy

I would like to check whether we can install SQL Express Edition on Dual - Quad core CPU Server running on Windows 2003 R3 SP2 - 32bit. Dual - Quad...

Vijaya Kumar

02-04-2009 12:44 PM
Andrew J. Kelly

I've got to install the x64 version of SQL 2008 Standard on a Windows 2008 x64 system. I've got the cd that has both x64 and x86 versions on it but...

Sandy Wood

02-04-2009 12:43 PM
Andrew J. Kelly

Can you please tell me (or send me some links where I can learn) how to share the asp.net membership logins between two different websites. At first...

JRL

02-04-2009 09:14 AM
Charles Wang [MSFT]

Hi: I'm trying to install SQL Server 2008 Express on a Vista system but get the 2203 error and the install continues but the database engine is...

John F.

02-04-2009 09:13 AM
Payne

Hi, the setup for the SQL 2008 WT setup is canceled. In the Log-File I find the following message: A computer restart is required. You must restart...

Christian Havel

02-04-2009 08:30 AM
Aaron Bertrand [SQL Server MVP]

We have windows 2003 Enterprise edition 32bit installed along with SQL 2005 Ent Edition. Someone accidentally deleted the all the contents of the...

ISSDBEngr@gmail.com

02-04-2009 02:13 AM
Ekrem Önsoy

Hello all, I am getting crazy, PLEASE HELP! After several times of try and error by installing SQLServer 2008 Express, by the time now I have got...

Jxazu1

02-03-2009 08:15 PM
Vidhya Sagar

We're upgrading SQL Server from 2000 to 2005 and installing 2005 on a brand new server...I have a question about the RAID configuration. We're...

devprog@msbcomp.com

02-03-2009 05:15 PM
Andrew J. Kelly

I have sql server 2005 express edition managment studio installed on a box that does not have the sql server database engine installed on it. Windows...

mat

02-03-2009 10:36 AM
Ekrem Önsoy

Repost of earlier post: I Posted it as a question, but it showed up as a comment not a question. I reinstalled SQL Server 2008 on my local...

jloper

02-03-2009 07:29 AM
jloper

I have a two node SQL Server 2008 Enterprise Edition cluster on Windows Server 2003 Enterprise Edition. I'd like to add SSAS to the existing...

Adam S

02-03-2009 03:59 AM
John Bell

An attempt to install a 2nd instance of SQL Server Express 2005 fails with the message... "An installation package for the product Microsoft SQL...

HMike

02-03-2009 03:33 AM
John Bell

Repost of earlier post: Post as comment not question. I reinstalled SQL Server 2008 on my local development machine today. I reinstalled because I...

jloper

02-02-2009 02:41 PM
jloper

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

jloper

02-02-2009 02:32 PM
jloper

We have SQL server 2005. We have mixed mode authentication.. We have created groups in Active Directory. I created a login for the group and mode is...

spiyush12@gmail.com

02-02-2009 11:46 AM
Rick Byham, \(MSFT\)

I downloaded and upgraded SQL server 2008 express on my machine from SQL server 2005 express. For some reason SQL 2008 server express does not...

inungh

02-02-2009 08:44 AM
inungh

Hello Everyone, Lend me your ears... I work for a company that had a server crash a month ago. They had a customized ASP SQL intranet that I...

JeffM

02-02-2009 08:35 AM
Eduard Beijnes

Hi, I'm trying to implement an efficient way to manage trans log in a prod environment (recovery model full) with the following backup strategy: -...

Socrates

02-02-2009 07:49 AM
Eduard Beijnes

Just installed a new server w/2008 Enterprise and joined it to our domain which is running SBS 2003. Installed SQL Server 2008 on the new server...

az

02-02-2009 02:51 AM
chris.hohmann@gmail.com

I'm getting the following error in Summary.txt: The MOF compiler could not connect with the WMI server. This is either because of a semantic error...

Brent

01-31-2009 09:06 PM
Vidhya Sagar

I note that the minimum OS for SQL Server 2008 is Windows Server 2003 SP2, I am currently running Windows Server 2003 R2 SP1 and need to know if...

D Johnson

01-30-2009 11:48 PM
Aaron Bertrand [SQL Server MVP]

Getting the following error when attempting to use SSMS 2008 for anything beyond writing basic queries. I really don't want to have to start by...

Peter A. Schott

01-30-2009 03:49 PM
Deep