Need to change Authentication type of my first DB in SQL05

* I was able to configure and install the DB

* I accidentally selected Windows Authentication

Now it won't let me login and keeps giving me an error.

Question: how do i change the authentication type without getting into the db? is there something I'm missing?

The authentication method is Server level, not database level. (Are you able to access the Server -but not a specific database?)

IF so, using SSMS, in the Object Explorer pane, right-click on the Server, and then select the [Security] tab. Change the authentication method there.

If you are not able to access the Server using SSMS, it may be just as quick for you to re-install (or) let us know so we can walk you through the process.

|||Sql service is necessary after changing the authentication mode on server level. Hence do a restart after changing the authentication mode.

Need some help with MSDE 2000

I have to create an application using MSDE, I install the software on my pc
and it is working fine but my problem is that I have to store the database
on the J drive of my LAN and must be able to access if from my local PC or
any other pc connected to the Lan. When I put the database on my pc I can
access the the tables, but when I put the database on the J drive of the LAN
the MSDE client on my PC does not find the databases. Is there a way to tell
the MSDE client on my PC to go to the J drive on the lan and find the
databases? The data must be store on the J drive of the Lan. I would really
appreciate some help here as I am very new to MSDE. In ms access I just had
to set the path to the database and that was it.
thanks in advance.
On Sat, 12 Jun 2004 01:37:34 -0400, Patrick Blackman
<caribsoft@.videotron.ca> wrote:

> the MSDE client on my PC does not find the databases. Is there a way to
> tell the MSDE client on my PC to go to the J drive on the lan and find
> the
> databases?
You should install MSDE on the machine where it runs, not on another PC
into a mapped drive. That's just what my feeling tells me. There might ne
network installation guides on msdn.microsoft.com.
Furthermore, if you need to access MSDE over the net, make sure
authentication (hint: SECURITYMODE=SQL, for instance) is set up properly
as well as "firewalls" are disabled or at least let the appropriate ports
through (I can't recall the MSDE listening port).
HTH,
Stefan
Give a man fire and he is warm for a day.
Set him on fire and he is warm for the rest of his life.

need some help

hi,
tried several issues to solve this ploblem.
i want to install reporting service but during the install ill get " Error
1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
you have sufficient privileges to start system services."
But im a domain admin. doing this on a new machine it runs fine dooing this
with a differend account intead ot the NT Authority\NetworkService a
domina account lets say domain\sqlsrv then the service wil start.
but the problem what i have than is at the end of the installation it say
activate the install manualy this won't work overhere. tried anything.
anyone who has a good hint to solve this problem.
because the sql reporting won't instaal i can't install MOM 2005 reporting.
greetings,
robert
<Func Name='RedirectorCAX'>
Function=Do_rsManagerShortcut
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_rsManagerShortcut
<Func Name='Do_rsManagerShortcut'>
<EndFunc Name='Do_rsManagerShortcut' Return='0' GetLastError='0'>
<EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
MSI (s) (64:98): Executing op:
ActionStart(Name=Do_AddASPNETExtension.F903F06D_68 A4_46D3_A635_84A74188E25D,,)
MSI (s) (64:98): Executing op:
CustomActionSchedule(Action=Do_AddASPNETExtension. F903F06D_68A4_46D3_A635_84A74188E25D,ActionType=11 22,Source=D:\Microsoft
SQL Server\MSSQL\Reporting
Services\ReportServer\bin\,Target="C:\WINDOWS\syst em32\cscript.exe" "C:\WI
NDOWS\system32\iisext.vbs" /AddFile
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et_isapi.dll" 1 "ASP.NET
v1.1.4322" 0 "ASP.NET v1.1.4322",)
MSI (s) (64:98): Executing op:
ActionStart(Name=Do_EnableASPNETExtension.F903F06D _68A4_46D3_A635_84A74188E25D,,)
MSI (s) (64:98): Executing op:
CustomActionSchedule(Action=Do_EnableASPNETExtensi on.F903F06D_68A4_46D3_A635_84A74188E25D,ActionType =1122,Source=D:\Microsoft
SQL Server\MSSQL\Reporting
Services\ReportServer\bin\,Target="C:\WINDOWS\syst em32\cscript.exe" "C:
\WINDOWS\system32\iisext.vbs" /EnFile
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et_isapi.dll",)
MSI (s) (64:98): Executing op:
ActionStart(Name=StartServices,Description=Startin g
services,Template=Service: [1])
MSI (s) (64:98): Executing op:
ProgressTotal(Total=1,Type=1,ByteEquivalent=130000 0)
MSI (s) (64:98): Executing op:
ServiceControl(,Name=ReportServer,Action=1,Wait=-2147483648,)
Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
that you have sufficient privileges to start system services.
MSI (s) (64:98): Product: Microsoft SQL Server 2000 Reporting Services
Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer)
failed to start. Verify that you have sufficient privileges to start system
services.
When you get this error during install look for the RS log files. They are
called ReportServerService<timestamp>.log file. If present they may contain
information as to why the service will not start.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Smit" <MOM@.fiberman.nl> wrote in message
news:OxSnXyy8EHA.1452@.TK2MSFTNGP11.phx.gbl...
> hi,
> tried several issues to solve this ploblem.
> i want to install reporting service but during the install ill get " Error
> 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
> you have sufficient privileges to start system services."
> But im a domain admin. doing this on a new machine it runs fine dooing
> this with a differend account intead ot the NT Authority\NetworkService
> a domina account lets say domain\sqlsrv then the service wil start.
> but the problem what i have than is at the end of the installation it say
> activate the install manualy this won't work overhere. tried anything.
> anyone who has a good hint to solve this problem.
> because the sql reporting won't instaal i can't install MOM 2005
> reporting.
> greetings,
> robert
> <Func Name='RedirectorCAX'>
> Function=Do_rsManagerShortcut
> <Func Name='GetCAContext'>
> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
> Doing Action: Do_rsManagerShortcut
> <Func Name='Do_rsManagerShortcut'>
> <EndFunc Name='Do_rsManagerShortcut' Return='0' GetLastError='0'>
> <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> MSI (s) (64:98): Executing op:
> ActionStart(Name=Do_AddASPNETExtension.F903F06D_68 A4_46D3_A635_84A74188E25D,,)
> MSI (s) (64:98): Executing op:
> CustomActionSchedule(Action=Do_AddASPNETExtension. F903F06D_68A4_46D3_A635_84A74188E25D,ActionType=11 22,Source=D:\Microsoft
> SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\,Target="C:\WINDOWS\syst em32\cscript.exe" "C:\WI
> NDOWS\system32\iisext.vbs" /AddFile
> "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et_isapi.dll" 1 "ASP.NET
> v1.1.4322" 0 "ASP.NET v1.1.4322",)
> MSI (s) (64:98): Executing op:
> ActionStart(Name=Do_EnableASPNETExtension.F903F06D _68A4_46D3_A635_84A74188E25D,,)
> MSI (s) (64:98): Executing op:
> CustomActionSchedule(Action=Do_EnableASPNETExtensi on.F903F06D_68A4_46D3_A635_84A74188E25D,ActionType =1122,Source=D:\Microsoft
> SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\,Target="C:\WINDOWS\syst em32\cscript.exe" "C:
> \WINDOWS\system32\iisext.vbs" /EnFile
> "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspn et_isapi.dll",)
> MSI (s) (64:98): Executing op:
> ActionStart(Name=StartServices,Description=Startin g
> services,Template=Service: [1])
> MSI (s) (64:98): Executing op:
> ProgressTotal(Total=1,Type=1,ByteEquivalent=130000 0)
> MSI (s) (64:98): Executing op:
> ServiceControl(,Name=ReportServer,Action=1,Wait=-2147483648,)
> Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
> that you have sufficient privileges to start system services.
> MSI (s) (64:98): Product: Microsoft SQL Server 2000 Reporting Services
> Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer)
> failed to start. Verify that you have sufficient privileges to start
> system services.
>
>

need some help

hi,
tried several issues to solve this ploblem.
i want to install reporting service but during the install ill get " Error
1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
you have sufficient privileges to start system services."
But im a domain admin. doing this on a new machine it runs fine dooing this
with a differend account intead ot the NT Authority\NetworkService a
domina account lets say domain\sqlsrv then the service wil start.
but the problem what i have than is at the end of the installation it say
activate the install manualy this won't work overhere. tried anything.
anyone who has a good hint to solve this problem.
because the sql reporting won't instaal i can't install MOM 2005 reporting.
greetings,
robert
<Func Name='RedirectorCAX'>
Function=Do_rsManagerShortcut
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_rsManagerShortcut
<Func Name='Do_rsManagerShortcut'>
<EndFunc Name='Do_rsManagerShortcut' Return='0' GetLastError='0'>
<EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
MSI (s) (64:98): Executing op:
ActionStart(Name=Do_AddASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,,)
MSI (s) (64:98): Executing op:
CustomActionSchedule(Action=Do_AddASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,ActionType=1122,Source=D:\Microsoft
SQL Server\MSSQL\Reporting
Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:\WI
NDOWS\system32\iisext.vbs" /AddFile
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll" 1 "ASP.NET
v1.1.4322" 0 "ASP.NET v1.1.4322",)
MSI (s) (64:98): Executing op:
ActionStart(Name=Do_EnableASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,,)
MSI (s) (64:98): Executing op:
CustomActionSchedule(Action=Do_EnableASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,ActionType=1122,Source=D:\Microsoft
SQL Server\MSSQL\Reporting
Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:
\WINDOWS\system32\iisext.vbs" /EnFile
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll",)
MSI (s) (64:98): Executing op:
ActionStart(Name=StartServices,Description=Starting
services,Template=Service: [1])
MSI (s) (64:98): Executing op:
ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
MSI (s) (64:98): Executing op:
ServiceControl(,Name=ReportServer,Action=1,Wait=-2147483648,)
Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
that you have sufficient privileges to start system services.
MSI (s) (64:98): Product: Microsoft SQL Server 2000 Reporting Services
Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer)
failed to start. Verify that you have sufficient privileges to start system
services.When you get this error during install look for the RS log files. They are
called ReportServerService<timestamp>.log file. If present they may contain
information as to why the service will not start.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Smit" <MOM@.fiberman.nl> wrote in message
news:OxSnXyy8EHA.1452@.TK2MSFTNGP11.phx.gbl...
> hi,
> tried several issues to solve this ploblem.
> i want to install reporting service but during the install ill get " Error
> 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
> you have sufficient privileges to start system services."
> But im a domain admin. doing this on a new machine it runs fine dooing
> this with a differend account intead ot the NT Authority\NetworkService
> a domina account lets say domain\sqlsrv then the service wil start.
> but the problem what i have than is at the end of the installation it say
> activate the install manualy this won't work overhere. tried anything.
> anyone who has a good hint to solve this problem.
> because the sql reporting won't instaal i can't install MOM 2005
> reporting.
> greetings,
> robert
> <Func Name='RedirectorCAX'>
> Function=Do_rsManagerShortcut
> <Func Name='GetCAContext'>
> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
> Doing Action: Do_rsManagerShortcut
> <Func Name='Do_rsManagerShortcut'>
> <EndFunc Name='Do_rsManagerShortcut' Return='0' GetLastError='0'>
> <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> MSI (s) (64:98): Executing op:
> ActionStart(Name=Do_AddASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,,)
> MSI (s) (64:98): Executing op:
> CustomActionSchedule(Action=Do_AddASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,ActionType=1122,Source=D:\Microsoft
> SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:\WI
> NDOWS\system32\iisext.vbs" /AddFile
> "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll" 1 "ASP.NET
> v1.1.4322" 0 "ASP.NET v1.1.4322",)
> MSI (s) (64:98): Executing op:
> ActionStart(Name=Do_EnableASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,,)
> MSI (s) (64:98): Executing op:
> CustomActionSchedule(Action=Do_EnableASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,ActionType=1122,Source=D:\Microsoft
> SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:
> \WINDOWS\system32\iisext.vbs" /EnFile
> "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll",)
> MSI (s) (64:98): Executing op:
> ActionStart(Name=StartServices,Description=Starting
> services,Template=Service: [1])
> MSI (s) (64:98): Executing op:
> ProgressTotal(Total=1,Type=1,ByteEquivalent=1300000)
> MSI (s) (64:98): Executing op:
> ServiceControl(,Name=ReportServer,Action=1,Wait=-2147483648,)
> Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
> that you have sufficient privileges to start system services.
> MSI (s) (64:98): Product: Microsoft SQL Server 2000 Reporting Services
> Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer)
> failed to start. Verify that you have sufficient privileges to start
> system services.
>
>

need some help

hi,
tried several issues to solve this ploblem.
i want to install reporting service but during the install ill get " Error
1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
you have sufficient privileges to start system services."
But im a domain admin. doing this on a new machine it runs fine dooing this
with a differend account intead ot the NT Authority\NetworkService a
domina account lets say domain\sqlsrv then the service wil start.
but the problem what i have than is at the end of the installation it say
activate the install manualy this won't work overhere. tried anything.
anyone who has a good hint to solve this problem.
because the sql reporting won't instaal i can't install MOM 2005 reporting.
greetings,
robert
<Func Name='RedirectorCAX'>
Function=Do_rsManagerShortcut
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_rsManagerShortcut
<Func Name='Do_rsManagerShortcut'>
<EndFunc Name='Do_rsManagerShortcut' Return='0' GetLastError='0'>
<EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
MSI (s) (64:98): Executing op:
ActionStart(Name=Do_AddASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25D,
,)
MSI (s) (64:98): Executing op:
CustomActionSchedule(Action=Do_AddASPNET
Extension.F903F06D_68A4_46D3_A635_84
A74188E25D,ActionType=1122,Source=D:\Mic
rosoft
SQL Server\MSSQL\Reporting
Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:\WI
NDOWS\system32\iisext.vbs" /AddFile
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll" 1 "ASP.NET
v1.1.4322" 0 "ASP.NET v1.1.4322",)
MSI (s) (64:98): Executing op:
ActionStart(Name=Do_EnableASPNETExtensio
n.F903F06D_68A4_46D3_A635_84A74188E2
5D,,)
MSI (s) (64:98): Executing op:
CustomActionSchedule(Action=Do_EnableASP
NETExtension.F903F06D_68A4_46D3_A635
_84A74188E25D,ActionType=1122,Source=D:\
Microsoft
SQL Server\MSSQL\Reporting
Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:
\WINDOWS\system32\iisext.vbs" /EnFile
"C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll",)
MSI (s) (64:98): Executing op:
ActionStart(Name=StartServices,Descripti
on=Starting
services,Template=Service: [1])
MSI (s) (64:98): Executing op:
ProgressTotal(Total=1,Type=1,ByteEquival
ent=1300000)
MSI (s) (64:98): Executing op:
ServiceControl(,Name=ReportServer,Action
=1,Wait=-2147483648,)
Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
that you have sufficient privileges to start system services.
MSI (s) (64:98): Product: Microsoft SQL Server 2000 Reporting Services
Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer)
failed to start. Verify that you have sufficient privileges to start system
services.When you get this error during install look for the RS log files. They are
called ReportServerService<timestamp>.log file. If present they may contain
information as to why the service will not start.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Smit" <MOM@.fiberman.nl> wrote in message
news:OxSnXyy8EHA.1452@.TK2MSFTNGP11.phx.gbl...
> hi,
> tried several issues to solve this ploblem.
> i want to install reporting service but during the install ill get " Error
> 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
> you have sufficient privileges to start system services."
> But im a domain admin. doing this on a new machine it runs fine dooing
> this with a differend account intead ot the NT Authority\NetworkService
> a domina account lets say domain\sqlsrv then the service wil start.
> but the problem what i have than is at the end of the installation it say
> activate the install manualy this won't work overhere. tried anything.
> anyone who has a good hint to solve this problem.
> because the sql reporting won't instaal i can't install MOM 2005
> reporting.
> greetings,
> robert
> <Func Name='RedirectorCAX'>
> Function=Do_rsManagerShortcut
> <Func Name='GetCAContext'>
> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
> Doing Action: Do_rsManagerShortcut
> <Func Name='Do_rsManagerShortcut'>
> <EndFunc Name='Do_rsManagerShortcut' Return='0' GetLastError='0'>
> <EndFunc Name='RedirectorCAX' Return='0' GetLastError='0'>
> MSI (s) (64:98): Executing op:
> ActionStart(Name=Do_AddASPNETExtension.F903F06D_68A4_46D3_A635_84A74188E25
D,,)
> MSI (s) (64:98): Executing op:
> CustomActionSchedule(Action=Do_AddASPNET
Extension.F903F06D_68A4_46D3_A635_
84A74188E25D,ActionType=1122,Source=D:\M
icrosoft
> SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:\WI
> NDOWS\system32\iisext.vbs" /AddFile
> "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll" 1 "ASP.NET
> v1.1.4322" 0 "ASP.NET v1.1.4322",)
> MSI (s) (64:98): Executing op:
> ActionStart(Name=Do_EnableASPNETExtensio
n.F903F06D_68A4_46D3_A635_84A74188
E25D,,)
> MSI (s) (64:98): Executing op:
> CustomActionSchedule(Action=Do_EnableASP
NETExtension.F903F06D_68A4_46D3_A6
35_84A74188E25D,ActionType=1122,Source=D
:\Microsoft
> SQL Server\MSSQL\Reporting
> Services\ReportServer\bin\,Target="C:\WINDOWS\system32\cscript.exe" "C:
> \WINDOWS\system32\iisext.vbs" /EnFile
> "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll",)
> MSI (s) (64:98): Executing op:
> ActionStart(Name=StartServices,Descripti
on=Starting
> services,Template=Service: [1])
> MSI (s) (64:98): Executing op:
> ProgressTotal(Total=1,Type=1,ByteEquival
ent=1300000)
> MSI (s) (64:98): Executing op:
> ServiceControl(,Name=ReportServer,Action
=1,Wait=-2147483648,)
> Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
> that you have sufficient privileges to start system services.
> MSI (s) (64:98): Product: Microsoft SQL Server 2000 Reporting Services
> Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer)
> failed to start. Verify that you have sufficient privileges to start
> system services.
>
>

need original disk for sp1 install? please tell me i don't...

hello
installing sp1 requires the original cd? please tell me i don't... i really
don't want to shuffle tons of files around so i can extract a 600mb file
just to install a service pack.
man, i hate this about msft... i'm always digging up original cds for
updates. what a pain. what's the reason for this?
dushan bilbijaPerhaps they're trying to discourage piracy?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> hello
> installing sp1 requires the original cd? please tell me i don't... i
> really
> don't want to shuffle tons of files around so i can extract a 600mb file
> just to install a service pack.
> man, i hate this about msft... i'm always digging up original cds for
> updates. what a pain. what's the reason for this?
> dushan bilbija
>|||We did our best to ensure you would not need the original media when
installing SP1. Windows installer has some quirks about it that can make
this a difficult goal to achieve. I have seen this issue happen when config
files are copied over top of existing config files. The modified dates and
create dates confuse the installer and make it think it needs to recreate
the file.
If you send me the setup log file I can see if this is an issue we can
resolve for our next service pack.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Perhaps they're trying to discourage piracy?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > hello
> >
> > installing sp1 requires the original cd? please tell me i don't... i
> > really
> > don't want to shuffle tons of files around so i can extract a 600mb file
> > just to install a service pack.
> >
> > man, i hate this about msft... i'm always digging up original cds for
> > updates. what a pain. what's the reason for this?
> >
> > dushan bilbija
> >
> >
>|||you'd think that was the reason... but how would they achieve that with the
original cd? a nice cd burner takes care of that problem. a quick google
search gives you any cd key you need.
btw... where's the guide for vb.net and sql2005? :)
dushan
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Perhaps they're trying to discourage piracy?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > hello
> >
> > installing sp1 requires the original cd? please tell me i don't... i
> > really
> > don't want to shuffle tons of files around so i can extract a 600mb file
> > just to install a service pack.
> >
> > man, i hate this about msft... i'm always digging up original cds for
> > updates. what a pain. what's the reason for this?
> >
> > dushan bilbija
> >
> >
>|||hi daniel
i'll email you the log file... maybe it'll help debug the install.
in the meantime, i've found a workaround... i dnloaded the eval install, and
used that instead. the original cd is on our corporate network, and i didn't
have access to it.
thanks for the quick reply!
dushan
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23wLRh8ujEHA.2500@.TK2MSFTNGP09.phx.gbl...
> We did our best to ensure you would not need the original media when
> installing SP1. Windows installer has some quirks about it that can make
> this a difficult goal to achieve. I have seen this issue happen when
config
> files are copied over top of existing config files. The modified dates
and
> create dates confuse the installer and make it think it needs to recreate
> the file.
> If you send me the setup log file I can see if this is an issue we can
> resolve for our next service pack.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > Perhaps they're trying to discourage piracy?
> >
> > --
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > www.betav.com
> > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > __________________________________
> >
> > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > > hello
> > >
> > > installing sp1 requires the original cd? please tell me i don't... i
> > > really
> > > don't want to shuffle tons of files around so i can extract a 600mb
file
> > > just to install a service pack.
> > >
> > > man, i hate this about msft... i'm always digging up original cds for
> > > updates. what a pain. what's the reason for this?
> > >
> > > dushan bilbija
> > >
> > >
> >
> >
>|||oops... spoke too soon.
the install i have is enterprise edition... so i still need the cd.
dushan
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:Os9KZGvjEHA.3392@.TK2MSFTNGP15.phx.gbl...
> hi daniel
> i'll email you the log file... maybe it'll help debug the install.
> in the meantime, i've found a workaround... i dnloaded the eval install,
and
> used that instead. the original cd is on our corporate network, and i
didn't
> have access to it.
> thanks for the quick reply!
> dushan
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23wLRh8ujEHA.2500@.TK2MSFTNGP09.phx.gbl...
> > We did our best to ensure you would not need the original media when
> > installing SP1. Windows installer has some quirks about it that can
make
> > this a difficult goal to achieve. I have seen this issue happen when
> config
> > files are copied over top of existing config files. The modified dates
> and
> > create dates confuse the installer and make it think it needs to
recreate
> > the file.
> >
> > If you send me the setup log file I can see if this is an issue we can
> > resolve for our next service pack.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > Perhaps they're trying to discourage piracy?
> > >
> > > --
> > > ____________________________________
> > > William (Bill) Vaughn
> > > Author, Mentor, Consultant
> > > Microsoft MVP
> > > www.betav.com
> > > Please reply only to the newsgroup so that others can benefit.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > __________________________________
> > >
> > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > > > hello
> > > >
> > > > installing sp1 requires the original cd? please tell me i don't... i
> > > > really
> > > > don't want to shuffle tons of files around so i can extract a 600mb
> file
> > > > just to install a service pack.
> > > >
> > > > man, i hate this about msft... i'm always digging up original cds
for
> > > > updates. what a pain. what's the reason for this?
> > > >
> > > > dushan bilbija
> > > >
> > > >
> > >
> > >
> >
> >
>

Need infos regarding install of SQL Express 2005 SP1

Hi,

A little technical question. If I want to install SQL Express 2005 SP1, do I have to uninstall current version first?

Thanks in advance,

Stphane

No, you apply a service pack to an existing installation.|||

Hi again,

Thanks for the info. Maybe a last question. Considering the fact that a SP1 has also been issued for Visual Studio 2005, must I first install the SP1 for VS 2005 before installing SP1 for SQL Express 2005 or it doesn't matter?

Thanks for your help,

Stphane

|||

It doesn't matter.

Mike

|||

SQL Server and Visual Studio are separate products. You do not have to apply SP1 to them in any particular order, nor do you have to apply it to both (though it is a good idea.)

Please indicate if your question has been answered properly. Thanks,

|||

Hi again,

I just finished install VS 2005 Sp1. Quite long, especially the section where it was evaluating the pre-requisites, but everything completed without error. It detected the appropriate version of VS2005 I was using. Now I'm ready to apply SP1 to SQL Server Express 2005. Before going on, I really need to clarify those things.

Considering the fact that the version of SQL Server Express 2005 actually present on my system is the one I originally installed from VS2005 Standard disks, what is the appropriate install sequence I should take?:

1- If I want to install "Microsoft SQL Server 2005 Express Edition with Advanced Services", do I have to uninstall the SQL Server Express 2005 version actually installed on my machine first or do I simply install the new one over it?

ref: http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en

2- I presume that I can then install "Microsoft SQL Server 2005 Express Edition Toolkit" without problem. Anything I should take care of before install?

ref: http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en

3- Finally, I presume that I can apply SP1 "Microsoft SQL Server 2005 Express Edition (SP1)" without any problem. Is the following link the appropriate version to apply or should I apply another one?

ref: http://www.microsoft.com/downloads/details.aspx?familyid=11350B1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en

Thanks for your help,

Stphane

|||

Stphane,

Your sequence of steps should be work ok.

|||

Hi Arnie,

Just to be sure. Must I uninstall current version of SQL Express before going on with others listed in previous message?

Thanks for your help, really appreciated!

Stphane

|||Unless you are using a beta version, you do not need to unInstall before applying the service pack.|||

Hi again,

For applying SP1, I was aware that there was no need for uninstalling as I already applied SP1 over Visual Studio 2005. In fact, my question was more about the installation of "Microsoft SQL Server 2005 Express Edition with Advanced Services" over actual SQL Express installed on my machine. Can I install it over actual version or must I first uninstall current SQL Express version installed?

Thanks again,

Stphane

|||

The 'Advanced Services" edition is the same version of SQL 2005 Express, and it includes additional functionality, including Management Studio Express.

Again, you do NOT have to uninstall before adding a service pack.

(Now is that complete enough for you to indicate you have been responded and answered?

|||

Hi again,

This last question was not about SP1. Actually the SQL Server 2005 Express version I have is the one installed directly from Visual Studio 2005 Standard Edition disks. I would like before applying SP1 to install instead version/package "Microsoft SQL Server 2005 Express Edition with Advanced Services". During your last posts, you seemed to talk only about SP1. Again, "Microsoft SQL Server 2005 Express Edition with Advanced Services" is NOT installed but I would like to install it before applying SP1.

That is why I asked again, and still ask, in order to install "Microsoft SQL Server 2005 Express Edition with Advanced Services" over current version I have of SQL Express, do I have to uninstall SQL Express version currently installed first?

After this new install will be done, THEN I know I will be able to install SP1 without touching anything, the same way I already did so far for VS 2005.

Sorry for misunderstanding, but I want to be sure before screwing up anything.

Stphane

|||

And as I have replied many, many times: NO, you do not have to uninstall your current version of SQL 2005 Express. When you start up the "Advanced Services" edition, you will be asked if you want to install a new instance, or just install the new advanced services and Management Studio Express.

Please, give it a rest. Go make your installation. Go with Peace and Florish.

|||

Hi,

Really sorry to bug you but I never went through this install so far. Having known from start that install process would have asked me this question would have made things clear in my mind. Now, with that last detail, YES, we can close the subject.

Thanks for your patience,

Stphane

|||Cool, you gave yourself credit for answering your own question!

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need infos before installing SQL Express 2005 SP2

Hi,

I noticed that SP2 was finally released. A few question before I dive in that install:

- Must I uninstall anything before installing SP2?

- Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?

- If I also have Compact Edition installed, is there any SP2 issued for it?

- Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?

Thanks in advance,

Stphane

" - Must I uninstall anything before installing SP2?"

No, changes are commulative.

"Considering that fact that I keep a copy of each install programs on a disk in case of crash recovery, must I keep SP1 files as well as SP2 files or can I consider that SP2 is complete by itself, that it completely overwrite SP1 and so delete SP1 files and just keep SP2 files for backup?"

Only if you want to install your SQL Server from scratch and only want to roll up to SP1 after a crash, otherwise if you want to update the database to SP2 again, you′ll be fine just keeping the SP2 files.

-If I also have Compact Edition installed, is there any SP2 issued for it?

No, the only changes convening the Compact edition is the support of Managment Studio to administer it.

"Is there a place where I can sign in so I can receive some sort of email notice where an upgrade is available for download for SQL Server 2005 as well as for Visual Studio 2005?"

Windows Update will inform you if new updates become available.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Many thanks for the infos. Just to be sure I followed your explanation. If I have to recover/reinstall SQL Server Express SP2 following a crash, I just need my original Visual Studio disk and SQL Server SP2 files installed to get back to work?

"Windows Update will inform you if new updates become available"

I'm quite surprised to read that Windows update is supposed to notify me when any update to Visual Studio 2005 as well as SQL Server are available because not later that this morning, I tried it again following reception of your reply

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=fr

and still didn't see any update available for those two items. Am I missing something?

Thanks for your help,

Stphane

|||

Hi again,

I started applying "SQL server Express with advanced tools SP2" this morning and must admit that I'm not too sure about what I must understand from step "Existing components". I have three items:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled?

If I then look at the details I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

What would be the appropriate step to take?

Thanks in advance,

Stphane

|||

Hi Stephane,

All editions of SQL Server SP2 will be available on Microsoft Update later in March. There are a number of steps we have to take once we've completed a service pack to make it availabe on Microsoft Update. Rather than make you wait until we finish the Microsoft Update work to get the service pack, we release it to the web as soon as we're done and just accept that there is a slight delay before it's seen on MU. I'm not sure about the whether VS SP1 is on Microsoft Update or not.

Regarding the error you are seeing when you try to update the Workstation components, this seems to be a result of having tools from a different edition on your computer. Do you have an edition of SQL Server other than SQL Express on your computer? The tools are a common component, shared by all editions of SQL Server, although the higher level editions have more tools that SQL Express. If you've installed one of the other editions, the larger set of tools from that edition are installed on your computer. Since SQL Express has the smallest set of tools, SQL Express SP2 can not update the tools installed by other editions, you will need to apply the patch for the larger edition to get the tools updated.

If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change. Once the maintenance dialog opens, click the Report button to get a report showing not only the version of each component, but the source edition.

Mike

|||

Hi Mike,

Many thanks for replying. I carrefully took attention at your suggestions.

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I did it and got following report:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS

Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Common components

Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (états-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. Am I missing something or maybe somewhere else I should check?

Thanks again,

Stphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

|||

Hi everyone,

For follow-up of this discussion, please read following thread:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1307730&SiteID=1

Stphane

Need IIS installed for Client Components??

Just wondering if I can install SQL Server 2005 Client Components onto
a computer(s) without having IIS (specifically web server) installed
on it? Any ideas?
Yes you can install the client components without having IIS
installed.
-Sue
On 1 Feb 2007 11:50:19 -0800, "nlandis22@.gmail.com"
<nlandis22@.gmail.com> wrote:

>Just wondering if I can install SQL Server 2005 Client Components onto
>a computer(s) without having IIS (specifically web server) installed
>on it? Any ideas?

Need IIS installed for Client Components??

Just wondering if I can install SQL Server 2005 Client Components onto
a computer(s) without having IIS (specifically web server) installed
on it? Any ideas?Yes you can install the client components without having IIS
installed.
-Sue
On 1 Feb 2007 11:50:19 -0800, "nlandis22@.gmail.com"
<nlandis22@.gmail.com> wrote:
>Just wondering if I can install SQL Server 2005 Client Components onto
>a computer(s) without having IIS (specifically web server) installed
>on it? Any ideas?

Need IIS installed for Client Components??

Just wondering if I can install SQL Server 2005 Client Components onto
a computer(s) without having IIS (specifically web server) installed
on it? Any ideas?Yes you can install the client components without having IIS
installed.
-Sue
On 1 Feb 2007 11:50:19 -0800, "nlandis22@.gmail.com"
<nlandis22@.gmail.com> wrote:

>Just wondering if I can install SQL Server 2005 Client Components onto
>a computer(s) without having IIS (specifically web server) installed
>on it? Any ideas?

Need I Remove SQL2k5 Trial to install a licensed copy

I thought I read somewhere that the SQL2k5 trial copy could be licensed at
or before the 180 days expired, but I can't find it. Can some one please
confirm, If I install SQL2k5 Enterprise Trial copy. Can I license that
copy, or do I need to uninstall and reinstall the licensed copy?http://www.microsoft.com/sql/howtobuy/faq.mspx
Thanks & Rate the Postings.
-Ravi-
"WANNABE" wrote:

> I thought I read somewhere that the SQL2k5 trial copy could be licensed at
> or before the 180 days expired, but I can't find it. Can some one please
> confirm, If I install SQL2k5 Enterprise Trial copy. Can I license that
> copy, or do I need to uninstall and reinstall the licensed copy?
>
>|||have you try upgrading from trial to FULL Version..
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Ravi" wrote:
[vbcol=seagreen]
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "WANNABE" wrote:
>

Need I Remove SQL2k5 Trial to install a licensed copy

I thought I read somewhere that the SQL2k5 trial copy could be licensed at
or before the 180 days expired, but I can't find it. Can some one please
confirm, If I install SQL2k5 Enterprise Trial copy. Can I license that
copy, or do I need to uninstall and reinstall the licensed copy?http://www.microsoft.com/sql/howtobuy/faq.mspx
--
Thanks & Rate the Postings.
-Ravi-
"WANNABE" wrote:
> I thought I read somewhere that the SQL2k5 trial copy could be licensed at
> or before the 180 days expired, but I can't find it. Can some one please
> confirm, If I install SQL2k5 Enterprise Trial copy. Can I license that
> copy, or do I need to uninstall and reinstall the licensed copy?
>
>|||have you try upgrading from trial to FULL Version..
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Ravi" wrote:
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Thanks & Rate the Postings.
> -Ravi-
>
> "WANNABE" wrote:
> > I thought I read somewhere that the SQL2k5 trial copy could be licensed at
> > or before the 180 days expired, but I can't find it. Can some one please
> > confirm, If I install SQL2k5 Enterprise Trial copy. Can I license that
> > copy, or do I need to uninstall and reinstall the licensed copy?
> >
> >
> >

Need Help... Urgent!

I've installed SQL Server 2005 from MSDN, however, while I was trying to
install the SP1 from the same DVD, it said:
"Shared String ID 11217 Not Found" with the body of the message saying
"Shared String ID 11216 Not Found"...
What could I do? How do I solve this?
I went to Microsoft.com to download the SP1 directly from there.. But the
error continues...
Thanks...Hi Sonia,
Why dont you apply SP2 directly?
--
Ekrem Ã?nsoy
"Sonia.Madureira" <Sonia.Madureira@.discussions.microsoft.com> wrote in
message news:067A08DC-D5B1-4734-B24D-3A23E951F562@.microsoft.com...
> I've installed SQL Server 2005 from MSDN, however, while I was trying to
> install the SP1 from the same DVD, it said:
> "Shared String ID 11217 Not Found" with the body of the message saying
> "Shared String ID 11216 Not Found"...
> What could I do? How do I solve this?
> I went to Microsoft.com to download the SP1 directly from there.. But the
> error continues...
> Thanks...|||Hi Ekrem,
Thanks for answer.. I've tried right now to install SP2 but it didn't work
out either..
When it's extracting, occours an error saying:
"The following error occoured", same in body - OK
When I click in OK it shows:
"A recently applied update, , failed to install" and in the content of the
report it says:
"EventType: sqlsetup P1 : unknown P2 : 0x0 P3 : unknown ..." , the
unknown repeats until P10...
Can you Help me?
"Ekrem Ã?nsoy" wrote:
Hi Sonia,
Why dont you apply SP2 directly?
--
Ekrem Ã?nsoy|||I'm not sure if your prior SP installation attempt broke some SQL Server
binaries or not but it look's like it did. As you do not have a chance to
uninstall only the SP installation (that corrupted one), there is not
emerging an idea in my mind but to uninstall the problematic SQL Server
instance and install a new SQL Server instance from scratch and applying SP2
then.
I don't know your environment and if it's an important SQL Server instance
and can not be offline for a while or something don't blame me for my
comments =)
I hope others has a better idea on this problem.
P.S.
You said that an error occurs when the package is being extracted but as it
complains about the corrupted SP installation in the error message, I think
it finishes extracting the package and the problem occurs when it's checking
the system before applying the SP.
--
Ekrem Ã?nsoy
"Sonia.Madureira" <SoniaMadureira@.discussions.microsoft.com> wrote in
message news:523C6A93-BF60-492A-A58F-DF9729087D2E@.microsoft.com...
> Hi Ekrem,
> Thanks for answer.. I've tried right now to install SP2 but it didn't work
> out either..
> When it's extracting, occours an error saying:
> "The following error occoured", same in body - OK
> When I click in OK it shows:
> "A recently applied update, , failed to install" and in the content of the
> report it says:
> "EventType: sqlsetup P1 : unknown P2 : 0x0 P3 : unknown ..." , the
> unknown repeats until P10...
> Can you Help me?
>
>
>
> "Ekrem Ã?nsoy" wrote:
> Hi Sonia,
> Why dont you apply SP2 directly?
> --
> Ekrem Ã?nsoy
>|||Thanks Ekrem,
I'll uninstall SQL and try again.
I've started this week serving as aprenctice in a company of services,
software, harware... So, they want me to learn as logic that is... (by the
way, forgive me my mistakes, i'm portuguese)
We install PC's, servers, etc in clients.. So we use SQL server...
They told me to install SQL server in my PC to start learning and when
errors occour, they answer to looke online.. I am looking everywhere but with
no luck... =( LOL
Thanks for helping me Ekrom... I will try to uninstall now... And try
again... =)
"Ekrem Ã?nsoy" wrote:
> I'm not sure if your prior SP installation attempt broke some SQL Server
> binaries or not but it look's like it did. As you do not have a chance to
> uninstall only the SP installation (that corrupted one), there is not
> emerging an idea in my mind but to uninstall the problematic SQL Server
> instance and install a new SQL Server instance from scratch and applying SP2
> then.
> I don't know your environment and if it's an important SQL Server instance
> and can not be offline for a while or something don't blame me for my
> comments =)
> I hope others has a better idea on this problem.
> P.S.
> You said that an error occurs when the package is being extracted but as it
> complains about the corrupted SP installation in the error message, I think
> it finishes extracting the package and the problem occurs when it's checking
> the system before applying the SP.
> --
> Ekrem Ã?nsoy|||Thanks Ekrem,
I'm allready installing SP2...
I have my problem solved...
=)|||That's a good news =)
I suggest you to be careful about installing SQL Server and its Service
Packs... For example, close any running apps that can\may prevent SQL Server
Setup to install its components successfully. It was your computer this time
but it could be an important SQL Server server. So ensure that there is a
clean and pure running system before starting installing SQL Server and its
Service Pack or something.
To learn better you could buy some books about SQL Server and your best
online assistant will be Books Online. Take advantage of it.
Good luck.
--
Ekrem Ã?nsoy
"Sonia.Madureira" <SoniaMadureira@.discussions.microsoft.com> wrote in
message news:BDDAFBE5-0CE4-4831-8827-314F87C4E5F0@.microsoft.com...
> Thanks Ekrem,
> I'm allready installing SP2...
> I have my problem solved...
> =)|||Thanks so much for helping me...
I have a lot to learn... =)
i will look for ebooks about it...
Thanks again!

NEED HELP! SQL Server 2000-Agent Jobs Scheduling error

I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this erro
r
in the error log: [192] Date calculation spin detected for Schedule 18 a
nd
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/defaul...kb;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

NEED HELP! SQL Server 2000-Agent Jobs Scheduling error

I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!
Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default...b;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

NEED HELP! SQL Server 2000-Agent Jobs Scheduling error

I've got a SQL Server 2000 SP-4 install that is giving me an error on a job
scheduled to run 1/week on Tuesday From 8:30AM - 11:30PM. It logs this error
in the error log: [192] Date calculation spin detected for Schedule 18 and
does not calculate the next time the job should start.
I read an associated article at msdn that stated this error was fixed in
SP-1, which I didn't install. As mentioned before, I do have Service Pack 4
installed which should also have corrected this issue, but regardless I am
still getting it. Has anyone had this problem and found a solution? Is
there possibly a hotfix I could apply instead of having to try re-installing
SP-4? Any help would be greatly appreciated!Hi Stephen,
Welcome to use MSDN Managed Newsgroup Support.
Yes, it is a known issue in SQL Server 2000 and SQL Server 7.0. To resolve
this issue, please following this article:
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of
the Schedule for the Day
http://support.microsoft.com/default.aspx?scid=kb;EN-US;295378
Please try to reinstall SQL 2000 SP4.
Hopw this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.