SQL Server Setup & Upgrade - SQL Server
Recent update: 2008-3-21

Unable to Uninstall SQL server 2005 Express

592 byte By OtisMukinfus at 2008-3-7
When I try to un install SQL Server Express (VS 2005 Beta 2), which is not functional, I get an error message:The SQL Server System Configuration Checker cannot be executed due to WMI Configuration on the machine MACHINE_NAME Error:2147746132 (0x80040154).I ran the Windows Install Cleanup tool ...

Cannot Apply SQL 2000 SP4 to Evaluation version

604 byte By jimmimacc at 2008-3-6
I have been trying to apply SP4 to my downloaded and installed evaluation version of SQL Server 2000. On the Analysis Services, I get an error that states "You must install Analysis Services before you can apply a service pack." When I try desktop engine, I get a "The instance name specified is ...

SQL Server 2005 Express April CTP

465 byte By GARussell at 2008-3-5
I have tried several different ways to get SQL Server 2005 Express installed with a VB 2005 Express package. It continues to tell me that it is unable to install due to incompatible components on my system. I've used the clean up tool, I've reinstalled the earlier beta version and uninstalled ...

replication component missing error while installing Sql Mobile2005

367 byte By AdnanSiddiqi at 2008-3-3
Hello i installed sql2005,first when I install it,it dont show SqlMobile option in available component lists,second when i install sqlce MSI file seprately,it searches for SQl Replication service and says its not installed,though its already installed on machine,i can install it anyway but why ...

Problem starting Maintenance Plans

965 byte By StuartLodge at 2008-3-1
HiI've installed the June CTP and want to set up some basic maintenance plans - especially for backups.However, when I run try to run the "Maintenance Plan Wizard" or to run "New Maintenance Plan" then I hit an error: "Exception has been thrown by the target of an invocation. (mscorlib)"This ...

Upgrade Express to 2005 CTP

67 byte By Joffies at 2008-2-28
Is there a way to upgrade SQL express 2005 to SQL Server 2005 CTP?

Setup Error: Data source name not found and no default driver specified

1840 byte By stand__sure at 2008-2-27
I am getting the following error during the setup of the database engine (the other parts seem to install properly):***SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default ...

Can't complete SQL Server 2005 installation!!!

272 byte By ivykuo at 2008-2-26
An err occurs when the installation of SQL Server 2005 ,"failed to start" SQL Server , the err msg asks me to query online menually,includes "SQL Server 2005 Setup Log Files and Starting SQL Server Manually." but I don't know what is the problem. Can you help me?

SQL server 2005 Beta 2 Uninstall Hell

1454 byte By JasonWalker at 2008-2-25
Ok, I have tried everything I can think of, but I am still getting errors to do with SQL server 2005 beta. Since the beta expired on all the VS.net 2005 I thought it would be a good idea to uninstall the lot to save some hard disk space...how wrong I was!! Everything uninstalled just great ...

Upgrade Desktop Engine (MSDE 2000) to standard edition 2005

434 byte By VivSas at 2008-2-24
While reading through books online I found that the supported upgrade for Desktop edition (MSDE) 2000 is to SQL Server 2005 workgroup and express edition.I am looking at upgrading just the database that resides on Desktop edition (MSDE) 2000 to SQL Server standard edition 2005. Is that ...

install SQL Server Express

101 byte By P.Hyde at 2008-2-23
when installing SQL Server Express on XP home edition it hangs wilst searching for IIS compnents

Problem of SQL Server 2005 Reporting service installation

3397 byte By xpding at 2008-2-22
The report manager site not working properly after I install the SQL Server 2005. I have been tried to fix it since yesterday. But it just getting worse. I need to get this to work properly before I can install the Visual Studio Team Foundation Server. I am following the Visual Studio Team ...

June CTP Won't Install

609 byte By DarrenShaffer at 2008-2-22
Alright - I'm at 5 hours of my time now trying to remove the April CTP via all the advice in this user's group and install the June CTP of Yukon. I have used the Build Uninstall Wizard as well as removing registry keys per some of the other posts here. I have removed everything in the ...

Installing SQL 2005 on servers with DNS

806 byte By cwilliam at 2008-2-21
I've looked into installing the SQL 2005 Enterprise beta in my organization to look at it's features and capabilities. We use SQL 2000 today.My setups weren't successful, and the reason (I think) is that the server I was installing these on is running DNS, because it's a Global Catalog ...

SQL Server 2000 Enterprise - memory usage

994 byte By robertc1 at 2008-2-20
Hi,I'm running SQL Server 2000 Enterprise on Windows Server 2003 Enterprise with 8 GB of Ram. For some reason SQL Server is not using more than 120 MB. I configured the options below to enable SQL Server to utilize more than 2 GB. If I keep all the default options, SQL Server will use ...

User define function

433 byte By WeiMing at 2008-2-20
I am using SQL 2000, and have a database was updated all the way from 6.5. I can not create function on this database instance, but I can create function on any other "new" database instance. I think this is because this particular db was from 6.5 which do not support user define function.Is ...

Are there updated instructions for the install of CTP and VS beta?

460 byte By midavis at 2008-2-20
Add me to the walking wounded over the weekend with this beta install.I have a development laptop that I want it all to reside on.Installed the VS beta and the April CTP in that order and Client tools were missing.I removed both, CTP by using the tool that was on the cd and VS by Add/Remove ...

YAIP (Yet Another Install Problem)

807 byte By firstspirit at 2008-2-19
Problems getting SQL Express June CTP to install. When I run the setup I get:--SQL Server 2005 CTP Setup has detected incompatible beta components from Visual Studio or SQL Server. You must run the build cleanup wizard from the CDE to remove previous SQL Server components and .NET Framework ...

SQL 2005 Developer Edition beta error message

883 byte By MikeBennett at 2008-2-18
HiWhen I install the latest CTP, I get this message when I ask for Analysis Services to be installed - deselecting that option, enables me to do the main install. The message is:Setup failed because Service MSSQLServerOLAPService is disabled for the current hardware profile. Services must be ...

Unable to create database from VS

1069 byte By RichardR at 2008-2-17
I'm getting a time out when I attempt to create a new database from within Visual Studio 2005 Beta 2. Here's what I did: 1) I installed VS2005 Beta 2 on a clean Windows 2003 Server w/SP 1 installation;2) Went into VS, created a new project;3) Clicked on the Database Explorer tab on the left ...

Upgrading Replication - Effects ?

780 byte By SeanDL at 2008-2-16
Hi ThereOk i have a publisher, remote distributor and subscriber all SQL2000.Now i need to upgrade this environment, i know that i have to upgrade the distributor first but what effect does this have on the replication that is busy running?That is will all publications and subscription continue ...

Update: Can't install Express June CTP?!

680 byte By HendrikB at 2008-2-15
Hey all, I'm trying to install SQL Server 2005 Express June CTP on a windows 2003 Web Edition Server (With SP1).I've had an old version of the .NET 2.0 Framework installed, so I downloaded the one mentioned next to the SQL Express download (this one: ...

Can't install Express June CTP?!

680 byte By HendrikB at 2008-2-15
Hey all, I'm trying to install SQL Server 2005 Express June CTP on a windows 2003 Web Edition Server (With SP1).I've had an old version of the .NET 2.0 Framework installed, so I downloaded the one mentioned next to the SQL Express download (this one: ...

How can I tell which CTP I have?

918 byte By JosephGeretz at 2008-2-15
I received SQL Server 2005 CTP in my June MSDN shipment. But it seems to be missing specific functionality that I would expect in the latest June CTP. Specifically, I don't see the 'Transfer Database' task in the Integration Service project template. A fellow on the NG told me that he has ...

Can't compile mkacls.cpp as suggested in BUG #: 374329 (SQLBUDT)

3907 byte By davidwj at 2008-2-15
from cl.exe I get a bunch of linker errors:/out:mkacls.exemkacls.objmkacls.obj : error LNK2019: unresolved external symbol __imp__CryptGetProvParam@20 referenced in function "struct _SECURITY_DESCRIPTOR * __cdecl GetSecurityDescDacl(unsigned long)" ...

SQL Server 2005 Developer ed.

422 byte By AVPimble at 2008-2-15
I am trying to install 2005 on a new hard drive, running only Windows x64. The processor is a AMD Athlon 64 3000+, 2.02GHz, with 1GB RAM.When I click on setup.exe, I receive the following error message:The image file c:\SQLDEV\setup.exe is valid, but for a machine type other than the current ...

SQL Server 2005 Beta 2 expiration date?

83 byte By jus at 2008-2-14
What is the expiration date of SQL Server 2005 Beta 2 (time bomb)? Thanks Jus

SQL 2005 Server Removal Question

391 byte By guest at 2008-2-14
I have been having repeated difficulty with getting Reporting Services working right (on Vista Ultimate) inside VS 2005. So for right now I am changing the install order and installing SQL 2005 and then dev studio. I have reviewed the forums of different manual installs and it seems as though nothin...

how to install vs ctp June with SQL Server Express

312 byte By jackie at 2008-2-14
VS CTP June include .net v2.0.50601,But the SQL Server Express (April or June) need .net framwork 2.0.50215.45.When I have finished to setup vs ctp june , I run SQL Server Express setup from VS DVD, I got the error (imcompatible beta ...

Issue installing SQL Server Express on Visual Studio Beta 2

564 byte By tushars at 2008-2-13
Hi,I have installed VS 2005 Beta 2 (Team System) using a DVD available from MS TEch Ed. This also installs SQL Server 2005 Express edition along with other tools. This installation is done on a vpc.However when I try to install SQL Server Express Manager over this installation, I get "The ...

SQLEXPRESS April CTP: SQL Server Configuration Manager

404 byte By mrdomiscoding at 2008-2-13
I have managed to re-install SQL Express April CTP, tried to get june's version but it won't install. anyway I got the April CTP installed OK, however now I get : snap-in failed to inialise : SQL Server Configuration Manager {CA9F87272-31DF-41D2-975C-887D74903967} Anyone know how I can ...

SQL EXPRESS CTP APRIL + CTP JUNE

1922 byte By mrdomiscoding at 2008-2-12
I have a Windows Server 2003 ( no service pack) I had SQL Express CTP April version on , but removed it using the uninstall program, I then deleted all the files in c:\Program Files\Micrsoft SQL Server\90 I then tried to install the CTP June version , but I keep getting the message about ...

How to remove failed installation

241 byte By beastrabbit at 2008-2-11
Installation of the June 2005 SQL Server 2005 CTP apparently completed but doesn't work - many links in the start menu are dead etc. There is no item in the add/remove programs for SQL Server. How can I manually remove the installation?

SQL Server 2005 Problems

1332 byte By AdamDustonnnn at 2008-2-10
Dear Microsoft Product Experts,Recently I installed SQL Server 2005 Express Edition. I don't remember the installation sequence exactly, but I believe that I chose "windows integrated authentication" rather than sql server authentication. This has made the database unusable with PHP, and this ...

installing sql

177 byte By rainbow at 2008-2-10
i have a problem installing sql server 2005 CTP editon,iam using visual express beta 2 editions of vb and vc# 2005 what is the compaitable sql version i can use with them?

How do I get AdventureWorks to show in sql2005.

791 byte By mlopez at 2008-2-8
How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the ...

June CTP: cannot install: Office 2003 Web Components

1089 byte By mlopez at 2008-2-8
THe June CTP of Sql Server 2005 fails with this message:Please insert the disk: Microsoft Office 2003 Web Components.[Ok] [Cancel]Of course:(1) I already had Office 2003 web components installed, and had performed a re-installation just to make sure.(2) Inserting my disk of Office 2003 Pro does ...

error installing standard edition on a windows 2003 server

2191 byte By VivSas at 2008-2-7
I have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller. Is installing standard edition on a server that is a domain controller supported because it looks like install is trying to create and add to local groups which are not present on a ...

Error installing SQL Server 2005 Express Manager

613 byte By PFlorenzano at 2008-2-7
Hello everyone,My name is Pete and I'm new to this forum. Today, I installed Microsoft .Net Framework 2.0 and SQL Server 2005 Express June CTP. The following error pops up when I attempt to install SQL Server 2005 Express Manager:"The installer encountered an unexpected error installing this ...

Cannot connect to SQL Server 2005 April CTP from remote computer

11808 byte By BrianFurner at 2008-2-7
Hi, I am trying to connect to a SQL Server on a Windows2003 w/sp1 Server from a remote computer but always seem to get the infamous "Access is denied or Server Does Not Exist" error. However, if I try to connect from the machine that is running the server, there is no problem. (Used sql ...

June CTP Sql agent problem

210 byte By Stephaenmarois at 2008-2-7
I Have installed June CTP DEV edition on a Windows Xp box. I'm a unable to start Sqlagent ..Sql agent status marqued as 'Agent Xps Disabled' Any idea ? P.S. Instance services started and running fine ..

Can we download the DTS Designer?

334 byte By MSEllen at 2008-2-6
I am using SQL Server Express 2005 CPT April, and I would like to use the DTS Designer with it. I have been looking for a download but have not found it yet. Does anyone know where I can download it from or if DTS Designer is included in the tools that come with SQL Server Express? I haven't ...

Cannot install June CTP on Windows 2003 DC !!!

810 byte By teleweb at 2008-2-6
I am trying to install Sql Server 2005 June CTP on a Windows Server 2003 SP1 primary domain controller with IIS/ASP installed. I get this error (when Sql Server Database Services is being installed: "SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group ...

I'm looking for a Project Plan template for Migration from MS SQL 2000 to MS

74 byte By Joan at 2008-2-6
We are beginning an upgrade project and want to learn from other projects.

Can I install sql 2005 march ctp in a machine with sql 2000?

90 byte By LuisValencia at 2008-2-5
What will happen to my databases? Will I be able to uninstall sql 2005 without problems?

None of the Management Tools Installed...

1147 byte By KiranBabu at 2008-2-5
I got SQL Server 2005 CTP (developer edition) as part of Visula Studio 2005 Beta Package. I removed all previous SQL server and Visual Studio stuff including all .NET framework versions completly. Then I installed SQL Server 2005 CTP first and selected all options (including all tools). I did ...

Configuring SQL 2005 Database Mail

260 byte By laker_42 at 2008-2-4
I am trying to configure Database mail to work with our Exchange server but the only setting that I see is for a SMTP server. I find it hard to believe that this won't work with Exchange. Has anyone got this to work with an Exchange server? Thanks! John

Publishing SQL Express June CTP as a "Prerequisite"?

638 byte By sean2078 at 2008-2-4
Hello,I have not conducted extensive testing yet, but I have installed the June CTP of SQL Express and everything is working fine with my Beta 2 copy of VS.NET 2005. I see that "SQL Server 2005 Express Edition Beta" is listed in the "Choose which prerequisites to install" list of the VS.NET ...

2005 CTP Connection error

265 byte By KeithKiedrowski at 2008-2-4
When I try to connect to the 2005 CTP SQL server in any of the VBexpress software packages I get the gfollowing error user instance login flag not supported in this version of SQL I am not sure what to check or what I may have missed in the SQL server setup

SQL Server 2005 Developer CTP Edition - Setup Error

511 byte By KarthikMohan at 2008-2-4
I am getting the following error message when I try installing the SQL Server 2005 Developer CTP. Can anyone please help me out.Thanks in advance.SQL Server setup could not connecr to the database service for server configuration. The error was"[Microsoft][SQl Native Client]Named Pipes ...

SQL Server

Site Classified