Re: SQL SERVER 2008 Express + SP1

Again there are three service pack setups which are provided by Microsoft.

SQLEXPR_x64_ENU.exe
SQLEXPR_x86_ENU.exe
SQLEXPR32_x86_ENU.exe

Are u sure you are using correct version for your install?

Manpreet Singh
http://crazysql.co.nr
MCITP – DB Admin, DB Dev SQL Server 2005
MCTS – MOSS 2007, SQL server 2005



"Martin Racette" wrote:

I installed the SQLXPR_X64, and before I attempted the SP1, SQLEXPRESS
database was 64bit for the configuration, better yet the repair do work
anymore because SP1 changed them somehow to 32 and the original install was
64

as for the event log here is what I have:

Script level upgrade for database 'master' failed because upgrade step
'sqlagent100_msdb_upgrade.sql' encountered error 5593, state 1, severity 16.
This is a serious error condition which might interfere with regular
operation and the database will be taken offline. If the error happened
during upgrade of the 'master' database, it will prevent the entire SQL
Server instance from starting. Examine the previous errorlog entries for
errors, take the appropriate corrective actions and re-start the database so
that the script upgrade steps run to completion.

"Manpreet Singh" <ManpreetSingh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:957086DF-DD79-4222-93C7-FC4E8B717D52@xxxxxxxxxxxxxxxx
Have you check windows event viewer logs and sql server error logs ?

And regarding your sql server installation , Microsoft provides three
installation packeges from sql server 2008 express installation

SQLEXPR32_x86
SQLEXPR_x86
SQLEXPR_x64

SQLEXPR32_x86 is a smaller package that can be used to install SQL Server
2008 Express onto only 32-bit operating systems. SQLEXPR_x86 is the same
product but supports installation onto both 32-bit and 64-bit (WoW)
operating
systems. SQLEXPR_x64 is a native 64-bit SQL Server 2008 Express and
supports
installation onto only 64-bit operating systems. You probably have
installed
SQLEXPR_x86 Package

Manpreet Singh
http://crazysql.co.nr
MCITP – DB Admin, DB Dev SQL Server 2005
MCTS – MOSS 2007, SQL server 2005


"Martin Racette" wrote:

I went to check and somehow the only configuration that I have now is the
32
bit, but I am suppose to have 64bit since I am using Vista64 and when I
install the SQL SERVER PEXRESS 2008, I choose to install the 64bit, which
made more sence

I did checked in the configuration manager and all of the protocols are
enable, the problem is when I go in the SERVICE MANAGEMENT, SQLEXPRESS is
not started has it is suppose to be when I boot, so I am trying to start
it
manually, it does start but it shutdown a fraction of a second later

"Manpreet Singh" <ManpreetSingh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:79CADDCB-BBE7-4481-8C43-0A346F000F5D@xxxxxxxxxxxxxxxx
Goto SQL server configuration manager and look for protocols for
sqlexpress
in SQL server network configuration. Enable shared memory, named pipes
and
TCP/IP.
Hope , this will solve your problem.

Manpreet Singh
http://crazysql.co.nr
MCITP – DB Admin, DB Dev SQL Server 2005
MCTS – MOSS 2007, SQL server 2005


"Martin Racette" wrote:

tried again today after rebooting the computer to start manually the
SQLEXPRESS database and here is the new error message, and if you
follow
the
link it refer to SQL SERVER 2005, and I have SQL SERVER 2008EXPRESS,
that
Windows update automatically installed SP1, and since then I can no
longer
access this database
what I do not understand is that the message below reference to
@network@
and the database is on the computer that is trying to start it, and as
far
as I know SQLSERVER EXPRESS can not be on a network to begin with

TITLE: Microsoft SQL Server Management Studio
------------------------------

Error connecting to 'GEORGES\SQLEXPRESS'.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while
establishing
a
connection to SQL Server. The server was not found or was not
accessible.
Verify that the instance name is correct and that SQL Server is
configured
to allow remote connections. (provider: Named Pipes Provider, error:
40 -
Could not open a connection to SQL Server) (Microsoft SQL Server,
Error:
2)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


--
Thank You in Advance
Merci a l'avance

Martin


--
Thank You in Advance
Merci a l'avance

Martin



--
Thank You in Advance
Merci a l'avance

Martin


.