Re: SQL SERVER 2008 Express + SP1

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Idiomatic Expressions to Operating System Architecture: Transforming Rigids
    ... <Subject: Re: Idiomatic Expressions to Operating ... <endpoint during a single session * DATABASE + by ... <statements is a new feature of SQL Server 2005. ...
    (sci.math)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access 2007 adp and SQL Server Express
    ... tab SQL Native Client Configuration / Alias in the SQL Server Configuration ... When configuring the server with the SQL Server Configuration Manager, ... Database Engine in the SQL Server 2005 Surface Area Configuration utility. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: installing help for sql 2005
    ... you have database users that are not mapped correctly to logins. ... SQL Server Documentation Team ... installation help with snap shots because i installed the sql server ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster will not fail over.
    ... As far as the TCP/IP issue goes, you had to rebuild the cluster and were not ... able to restore the master database. ... the entire installation configuration just as if nothing was running on it. ... > This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)