SQL Express Family CTP Now Available

SQL Express Family CTP Now Available

• Ricardo Oliveira

  I just tried an install and received the same error regarding the sa account.
  

• davidhhhhhhhhhhhhhh

  I would remove the SQL Server Management Studio Express prior to installing the Express Advanced SKU. You'll also need to install IIS on your machine if you want to install Reporting Services.

  -Jeffrey

  
  
  

• Zvonimir

  I have experienced the same problem
  

• Matt Fraser

  Hi,

  Any idea when the full version of SQL Server 2005 express edition is going to be released

  Thank you

  
  
  

• Wiemann

  I have got Advanced Services installed now. Re-reading the Readme file, I found I didn't need to install SP1 before Advanced Services - it is included. I uninstalled the instance and ran Advanced Services from scratch, with all options selected (except Mgmt Studio Express, as I have the full SQL Server tools already).

  So I don't know if the sa login problem was because of installing SP1 separately first, or if it is a problem with upgrading an instance.

  The only other issue is that //localhost/ReportServer$SQLExpress complained that NT AUTHORITY\NET WORK SERVICE did not have a log in. I added it manually and gave it the same permissions as NT AUTHORITY\SYSTEM on ReportServer$SQLExpress and ReportServer$SQLExpressTempDB and it seems fine now.

  Hope this helps.

  David

  
  

• MIS

  Are there problems with installing these on top of SQL Server 2005 Express I have:

  Microsoft SQL Server Management Studio Express 9.00.1399.00
  Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
  Microsoft MSXML 2.6 3.0 5.0 6.0
  Microsoft Internet Explorer 6.0.2900.2180
  Microsoft .NET Framework 2.0.50727.42
  Operating System 5.1.2600

  but I have already had significant time-wasting problems because I had the Beta Version of SQL Server 2005 installed previously - in the end I wiped my hard drive and re-loaded XP.

  It is the Reporting Services I am after - good advice would be appreciated.

  regards, David Wilson.

  
  

• D_J_

  Me too - on two different PCs.  Any workarounds welcome. 

  To clarify, this occurs on the Advanced Services install with all options chosen.  The SP1 install has already succeeded.  I shall try varying the Advanced Services install options.

  
  

• Dami#

  I'm new to SQL Express so be gentle...

  I had the same "minimum hardware" and "sa" installation problem with SQL Advance. I tried several times but always failed with same complaint.

  1) tried to upgrade to SQLEXPR_ADV and failed (three tries).

  2) successful install of SQLEXPR_TOOLKIT components. ( same (incorrect) hardware and sa complaints)

  3) successful upgrade to SQLEXPR SP1. (no complaints)

  4) again failed upgrade to SQLEXPR_ADV (same complaints)

  5) Followed David's suggestion and removed SQLEXPRESS instance. Installed SQLEXPR_ADV without complaint. Apparently the advance edition will install new but not upgrade previous.

  6) Also noticed that other features (e.g. ssmsee, etc ) did not upgrade so had to uninstall then install those too.

  HTH somebody

  Sturdy

  
  

• admeralthrawn

  Haven't seen anyone else with install problems on the SP1, but I have tried to install 3 times. I meet ALL system requirements(although it gives warning about hardware which is wrong). It installs the majority of the product but when it gets to "SQL Server Database Services" it fails with the following: "SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa.' Refer to sever error logs....."

  The second time I tried changing to SQL Server Authen. with sa and a blank password, but during the install it said I had to have Windows Authen. I changed logon service fro Network Service to Local System on the third attempt and it still failed. Can anyone think of what could be causing this

  
  
• SQL Express Family CTP Now Available