Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.
Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegr oups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>
|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?
|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?

Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
>
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?sql

Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.
Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegro ups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegroups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSSQL 2005 SP2 deleted all documents in my documents

hi,
Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
running it on XP SP2.
anybody run into this? restoring OS does not bring back the files.
any help would be appreciated.Doron, shalom
I have just installed SP2 on XP SP2 and it worked just fine. What is the
path of your SQL Server instalaltion?
<doron.almog@.gmail.com> wrote in message
news:1172531419.194567.175800@.h3g2000cwc.googlegroups.com...
> hi,
> Installing MSSQL 2005 SP2 deleted all documents in my documents. i'm
> running it on XP SP2.
> anybody run into this? restoring OS does not bring back the files.
> any help would be appreciated.
>

Installing MSDE 2000a

I have downloaded MSDE 2000a and installed it from the run command on Windows
XP SP2 but can only connect with the login "Trusted NT connection" and not
with the sa login. Can someone please give me the correct command to type to
install with sql or mixed authentication.
http://support.microsoft.com/default...b;en-us;319930
look at the heading "Enable Mixed Mode Authentication After Installation"
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cwsjnr" wrote:

> I have downloaded MSDE 2000a and installed it from the run command on Windows
> XP SP2 but can only connect with the login "Trusted NT connection" and not
> with the sa login. Can someone please give me the correct command to type to
> install with sql or mixed authentication.

Installing MSDE 2000 Rel A

Hi all,
I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
time without any indication of why. I had an earlier installation of MSDE
which I removed manually following the instructions in the Knowledge Base
article. I installed MSDE on a Windows 2000 Pro machine using the same
procedure without any problems.
The command line syntax I'm using is: setup sapwd="[mypassword]"
SECURITYMODE=SQL
Can anyone help?
Thanks.
When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
SQL Server" key needs to be removed. Also remove the entire directory tree
under c:\program files\Microsoft SQL Server. Also, reboot the machine after
doing the manual uninstall.
Jim
"Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
> Hi all,
> I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
> time without any indication of why. I had an earlier installation of MSDE
> which I removed manually following the instructions in the Knowledge Base
> article. I installed MSDE on a Windows 2000 Pro machine using the same
> procedure without any problems.
> The command line syntax I'm using is: setup sapwd="[mypassword]"
> SECURITYMODE=SQL
> Can anyone help?
> Thanks.
|||Hi Jim,
I did delete those keys from the registry with no luck.
In a separate post, I uploaded part of the install log what appears to point
to the problem . Searching for "return value 3" I found the following:
"Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 11:32:55: InstallFinalize. Return value 3."
According to a Knowledge Base article, the only solution to this involves
some advanced level tinkering with the registry, which I don't feel
comfortable undertaking. Is there any other way?
Thanks for your reply.
sb
"Jim Young" wrote:

> When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
> under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
> SQL Server" key needs to be removed. Also remove the entire directory tree
> under c:\program files\Microsoft SQL Server. Also, reboot the machine after
> doing the manual uninstall.
> Jim
> "Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
> news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
>
>
sql

Installing Inventor10

Hello,
I have a problem installing Autodesk Inventor 10 on my
WK SP4 OS system on XP SP2 system it works fine.
Event log during setup Inventor 10 Pro.
Source Loadperf
Category (none)
Event ID 2000
No object list was found in the installation file.
Adding an object list to the installation file will improve
performance of the system when measuring performance counters.
Source Loadperf
Category (none)
Event ID 1000
Performance counters for the MSSQL$INVENTORCONTENT service were loaded
successfully.
The Record Data contains the new index values assigned to this service.
Source MSSQL$INVENTORCONTENT
Category (8)
Event ID 19011
The description for Event ID ( 19011 ) in Source ( MSSQL$INVENTORCONTENT
) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer.
The following information is part of the event: (SpnRegister) : Error 1355.
Source MsiInstaller
Category (none)
Event ID 1013
Product: Microsoft SQL Server Desktop Engine --
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
Source MsiInstaller
Category (none)
Event ID 11708
Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
Source MsiInstaller
Category (none)
Event ID 11722
Product: Autodesk Inventor Professional 10 -- Error 1722.
There is a problem with this Windows Installer package.
A program run as part of the setup did not finish as expected.
Contact your support personnel or package vendor.
Action InstallMSDE, location:
F:\inv1_pro10\bin\acadfeui\support\msde\setup.exe, command:
SAPWD="AutodeskVault" INSTANCENAME="INVENTORCONTENT" SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=1 /L*v
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og /qb
REBOOT=ReallySuppress
Kind Regards
hi,
Smeusje wrote:
> Hello,
> I have a problem installing Autodesk Inventor 10 on my
> WK SP4 OS system on XP SP2 system it works fine.
> Event log during setup Inventor 10 Pro.
try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
for
RETURN VALUE 3
entries..
about 10 lines before each entry some (sometime cryptic) description of the
problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I have two of them
************************************************** ************************************************** ********************
Starting custom action SkuIt
MSI (s) (30:D4) [13:57:35:890]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (30:18) [13:57:35:921]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI47.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
MSI (s) (30:D4) [13:58:06:968]: Executing op:
ActionStart(Name=RegSQLWithMDAC.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INVENTORCONTENT" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (s) (30:D4) [13:58:06:968]: Executing op:
CustomActionSchedule(Action=RegSQLWithMDAC.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=RegSQLWithMDAC,)
MSI (s) (30:18) [13:58:06:984]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI48.tmp, Entrypoint: RegSQLWithMDAC
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action RegSqlWithMdac
MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
Engine -- An error has occurred registering this installation of SQL
Server Desktop Engine with MDAC.
MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback' is 0
MSI (s) (30:D4) [13:58:12:812]: Machine policy value 'DisableRollback' is 0
Action ended 13:58:12: InstallFinalize. Return value 3.
************************************************** ************************************************** *******************
MSI (s) (30:D4) [13:58:19:078]: Executing op:
ActionStart(Name=RollbackStreamSupportFiles.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:078]: Executing op:
CustomActionRollback(Action=RollbackStreamSupportF iles.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionTy pe=1281,Source=BinaryData,Target=RemoveSupportFile s,)
MSI (s) (30:94) [13:58:19:078]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4B.tmp, Entrypoint: RemoveSupportFiles
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
MSI (s) (30:D4) [13:58:19:203]: Executing op:
ActionStart(Name=RollbackDeferProperties.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:203]: Executing op:
CustomActionRollback(Action=RollbackDeferPropertie s.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (30:94) [13:58:19:203]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4C.tmp, Entrypoint: DeferProperties
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
MSI (s) (30:D4) [13:58:19:421]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return: 5
Defer Properties returns: 0
MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 13:58:19: INSTALL. Return value 3.
************************************************** ************************************************** **********************
I already changed from "Not difined" to "silently succeed" as
mentionned in the MSDE 2000 Release A guide
Unsigned driver installation behavior.
Unsigned non-driver installation behavior
Extract guide
A MSDE 2000 Release A installation will fail if either of the following
security policies has been set to Do not allow installation:
* The Devices: Unsigned driver installation behavior local security
policy for Windows XP.
* The Unsigned non-driver installation behavior local security
policy for Windows 2000.
If you use the Do not allow installation setting, you must change it to
Silently succeed before installing MSDE 2000 Release A. If necessary,
you can return the policy to its previous setting after the installation
is complete.
Note Do not allow installation is not the default setting for these
security policies.
To set these policies:
1. In Control Panel, double-click Administrative Tools.
2. Double-click Local Security Policy.
3. Expand Local Policies.
4. Select Security Options.
5. Ensure that the following option in the right pane is set to
Silently Succeed before installing MSDE 2000 Release A:
* On Windows XP and Windows 2003: Devices: Unsigned driver
installation behavior.
* On Windows 2000: Unsigned non-driver installation behavior.
Still doesn't work
Kind regards
Andrea Montanari wrote:

>hi,
>Smeusje wrote:
>
>try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
>for
>RETURN VALUE 3
>entries..
>about 10 lines before each entry some (sometime cryptic) description of the
>problem will be reported..
>
|||hi,
Smeusje wrote:
> I have two of them
> ************************************************** ************************************************** ********************
> MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
> Engine -- An error has occurred registering this installation of SQL
> Server Desktop Engine with MDAC.
> MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> An error has occurred registering this installation of SQL Server
> Desktop Engine with MDAC.
> MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback'
> is 0 MSI (s) (30:D4) [13:58:12:812]: Machine policy value
> 'DisableRollback' is 0 Action ended 13:58:12: InstallFinalize. Return
> value 3.
> ************************************************** ************************************************** *******************
>...
> MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return:
> 5 Defer Properties returns: 0
> MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
> MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting
> UpdateStarted property. Its current value is '1'.
> Action ended 13:58:19: INSTALL. Return value 3.
> ************************************************** ************************************************** **********************
the first one indicates a problem "installing" MDAC... actually it should
not as it only has to check for the correct MDAC stack... on WinXP sp2 and
Win2003 MDAC 2.8 of the service pack 4 will not be installed becouse of the
"superior" level of the installed component, perfomed only via Windows
Update...
for the 2nd one I really have no clues...
I do think all this is dependent of a embedded installation of MSDE... can
you please try downloading and executing the original setup.exe boostrapper
installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

installing apache, php5 and mysql 4

I am trying to get mysql 4, php5, and apache to work on my winxp sp2 comp,
unfortunately even though php5 and apache seems to work ok I am unable to
utilise mysql with php and apache, I have yet to see a guide that has a
problem free installation, if there is such a guide or a fix on how to get
php5, apache and mysql all working on winxp sp2, after having moved
libmysql.dll to the c:\php directory as well as the c:\windows\system
directory,. and amended php.ini to show the path to c:\php\ext (although
this version of php didn't automatically create an ext directory) and having
amended pathn the system environments to point to c:\php, as well as
numerous other recommendations, I am stuck as to how to proceed. Any help
will be greatly appreciated."Nospam" <nospam@.home.com> wrote in message
news:33uIf.41170$494.5977@.newsfe2-gui.ntli.net...
> I am trying to get mysql 4, php5, and apache to work on my winxp sp2 comp,
> unfortunately even though php5 and apache seems to work ok I am unable to
> utilise mysql with php and apache, I have yet to see a guide that has a
> problem free installation, if there is such a guide or a fix on how to get
> php5, apache and mysql all working on winxp sp2, after having moved
> libmysql.dll to the c:\php directory as well as the c:\windows\system
> directory,. and amended php.ini to show the path to c:\php\ext (although
> this version of php didn't automatically create an ext directory) and
having
> amended pathn the system environments to point to c:\php, as well as
> numerous other recommendations, I am stuck as to how to proceed. Any help
> will be greatly appreciated.

Well, not to be rude, but best help I can give is to take this to another
newsgroup. This is for Microsoft SQL Server specifically, so the amount of
MySQL knowledge here is pretty slim.

Installing and using Developer 2005

I am currently having problems with the SQL Server 2005 Developer.

1. I have a Windows XP SP2 Japanese version.

2. This machine is connected to a domain managed by Linux server.

3. I login with a domain account and install.

Initially, the intallations were failing with an error message that I do not have

administrator right.

We created an account on my machine with the same user name as that used

for the domain, and gave this administrator rights.

With this the installation was completed. However, there is another problem,

I cannot connect to the SQL Server.

For the installation, I chose "Local System" with Windows Authentication,

but the connection to the database still fails with the error message that remote

connection is not supported. I do not understand why I need TCP to accesss a local

installation of the SQL Server.

However, I followed the procedure outlined in a MS KB to enable TCP. But the

connection to the database still fails.

I am using the Management Studio to connect to SQL Server. I have also tried creating

a database in VS. NET 2005 and this also fails. I have checked the services and all are running.

What is wrong and what can I do? (it takes more than an hour to install this stuff and it is

really consuming my time). Any help?

Best regards,

Paul.

Actually you are missing a lot the Developer edition and Express comes locked down you have to go in and enable all you need with the Configuration Manager and Surface area configuration tool. It also helps if you use both TCP/IP and Named Pipes. I have covered all in the last posting in the thread below, the instructions are for Express and the developer edition but ignore the server registration section. I would also recommend mixed authentication mode so VS2005 will not cause you problems during development. Post again if you still need help.

http://msdn2.microsoft.com/en-us/library/ms188670.aspx

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

|||

Thanks for the reply.

I mentioned in my post, I followed the MS KB to enable the TCP. To be precise, it is this KB

http://support.microsoft.com/kb/914277

That never helped or solved the connection problem.

That KB starts like...

"When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message."

I installed "Local System" and do not see how this statement applies to my case when I am only trying to use the SQL Server on the same machine.

Best regards,

Paul.

|||

I have found the problem. I was connecting to the server listed and not the localhost.

Best regards,

Paul.

Installing and Configuring SSRS on Vista

This config stuff is getting a little bit ridiculous. I already had a
default instance of SQL Server 2005 SP2 down on the machine. I got all of
the IIS components installed on Vista in order to get an installation of
SSRS to go through. There was no installation option for configuration.
After installing, I applied SP2. Then I opened up IIS Manager and set the
app pool to Classic ASP.NET. When I launch RS Configuration, I select my
default instance, click connect, it it promptly blows up with the following
error:
YES, the SQL Server instance is started. If I click continue, it constantly
throws WMI errors. I managed to get to the database configuration and
create the reportserver and reportservertemp databases. Doing anything to
the virtual directories causes RS Configuration to simply abort and shut
down. I obviously can't get to either the reports or reportserver website,
because the config tool crashes and won't setup the virtual directories in
the config. (If I look in IIS admin, neither of the sites has a virtual
directory configured and the connection string is set to SQLEXPRESS and NOT
the default instance that I have on the machine.) This is getting
ridiculous. Does anyone have a manual config checklist which does NOT
require this Config tool, because the RS Config simply does NOT work.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
occurred and no additional error information is available. -->
System.Runtime.InteropServices.COMException (0x8000000A)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
-- End of inner exception stack trace --
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
itemName)
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
---
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase:
file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
---
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
---
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
---
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
---
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.netI hacked my way around and manually added the virtual directory within IIS
Admin for the Reports website. I then hacked and manually input the
<ReportServerVirtualDirectory> within the RSWebApplication.config file. It
at least finds the website now when I go to http://<machine>/reports.
However, it fails on the connection attempt with the VERY unhelpful error
message of:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
So, since I know that it is all compatible, I'm assuming that I missed
something when I manually created the connection string in IIS Admin. Does
anyone have a sample connection string from a working SSRS configuration?
--
Mike - mhotek@.mssqlserver.com
President FilAm Software Technology, Inc
Vice-President MHS Enterprises, Inc
MCITP - SQL Server DBA, MCT
http://www.mssqlserver.com
http://www.mhse.net
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
> This config stuff is getting a little bit ridiculous. I already had a
> default instance of SQL Server 2005 SP2 down on the machine. I got all of
> the IIS components installed on Vista in order to get an installation of
> SSRS to go through. There was no installation option for configuration.
> After installing, I applied SP2. Then I opened up IIS Manager and set the
> app pool to Classic ASP.NET. When I launch RS Configuration, I select my
> default instance, click connect, it it promptly blows up with the
> following error:
> YES, the SQL Server instance is started. If I click continue, it
> constantly throws WMI errors. I managed to get to the database
> configuration and create the reportserver and reportservertemp databases.
> Doing anything to the virtual directories causes RS Configuration to
> simply abort and shut down. I obviously can't get to either the reports
> or reportserver website, because the config tool crashes and won't setup
> the virtual directories in the config. (If I look in IIS admin, neither
> of the sites has a virtual directory configured and the connection string
> is set to SQLEXPRESS and NOT the default instance that I have on the
> machine.) This is getting ridiculous. Does anyone have a manual config
> checklist which does NOT require this Config tool, because the RS Config
> simply does NOT work.
> See the end of this message for details on invoking
> just-in-time (JIT) debugging instead of this dialog box.
> ************** Exception Text **************
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
> occurred and no additional error information is available. -->
> System.Runtime.InteropServices.COMException (0x8000000A)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementObject.InvokeMethod(String methodName,
> ManagementBaseObject inParameters, InvokeMethodOptions options)
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> -- End of inner exception stack trace --
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
> itemName)
> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
> at System.Windows.Forms.Form.set_Active(Boolean value)
> at System.Windows.Forms.Form.WmActivate(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> ************** Loaded Assemblies **************
> mscorlib
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> RSConfigTool
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.3042.00
> CodeBase:
> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
> ---
> System.Windows.Forms
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
> ---
> System
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
> ---
> System.Drawing
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
> ---
> System.Xml
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
> ---
> System.Management
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
> ---
> System.ServiceProcess
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
> ---
> ************** JIT Debugging **************
> To enable just-in-time (JIT) debugging, the .config file for this
> application or computer (machine.config) must have the
> jitDebugging value set in the system.windows.forms section.
> The application must also be compiled with debugging
> enabled.
> For example:
> <configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
> When JIT debugging is enabled, any unhandled exception
> will be sent to the JIT debugger registered on the computer
> rather than be handled by this dialog box.
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net|||Turn off user account control (UAC) in Vista.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Michael Hotek" <mike.hotek@.mhse.net> wrote in message
news:91E85C23-8B52-49A4-B1A4-2F0F5CF7B362@.microsoft.com...
>I hacked my way around and manually added the virtual directory within IIS
>Admin for the Reports website. I then hacked and manually input the
><ReportServerVirtualDirectory> within the RSWebApplication.config file. It
>at least finds the website now when I go to http://<machine>/reports.
>However, it fails on the connection attempt with the VERY unhelpful error
>message of:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> So, since I know that it is all compatible, I'm assuming that I missed
> something when I manually created the connection string in IIS Admin.
> Does anyone have a sample connection string from a working SSRS
> configuration?
> --
> Mike - mhotek@.mssqlserver.com
> President FilAm Software Technology, Inc
> Vice-President MHS Enterprises, Inc
> MCITP - SQL Server DBA, MCT
> http://www.mssqlserver.com
> http://www.mhse.net
> "Michael Hotek" <mike.hotek@.mhse.net> wrote in message
> news:2D164AE8-B582-4478-8D92-96C284E996DA@.microsoft.com...
>> This config stuff is getting a little bit ridiculous. I already had a
>> default instance of SQL Server 2005 SP2 down on the machine. I got all
>> of the IIS components installed on Vista in order to get an installation
>> of SSRS to go through. There was no installation option for
>> configuration. After installing, I applied SP2. Then I opened up IIS
>> Manager and set the app pool to Classic ASP.NET. When I launch RS
>> Configuration, I select my default instance, click connect, it it
>> promptly blows up with the following error:
>> YES, the SQL Server instance is started. If I click continue, it
>> constantly throws WMI errors. I managed to get to the database
>> configuration and create the reportserver and reportservertemp databases.
>> Doing anything to the virtual directories causes RS Configuration to
>> simply abort and shut down. I obviously can't get to either the reports
>> or reportserver website, because the config tool crashes and won't setup
>> the virtual directories in the config. (If I look in IIS admin, neither
>> of the sites has a virtual directory configured and the connection string
>> is set to SQLEXPRESS and NOT the default instance that I have on the
>> machine.) This is getting ridiculous. Does anyone have a manual config
>> checklist which does NOT require this Config tool, because the RS Config
>> simply does NOT work.
>> See the end of this message for details on invoking
>> just-in-time (JIT) debugging instead of this dialog box.
>> ************** Exception Text **************
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
>> occurred and no additional error information is available. -->
>> System.Runtime.InteropServices.COMException (0x8000000A)
>> at
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
>> errorCode, IntPtr errorInfo)
>> at System.Management.ManagementObject.InvokeMethod(String methodName,
>> ManagementBaseObject inParameters, InvokeMethodOptions options)
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> -- End of inner exception stack trace --
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
>> itemName)
>> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
>> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
>> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
>> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
>> at System.Windows.Forms.Form.set_Active(Boolean value)
>> at System.Windows.Forms.Form.WmActivate(Message& m)
>> at System.Windows.Forms.Form.WndProc(Message& m)
>> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
>> m)
>> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
>> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
>> IntPtr wparam, IntPtr lparam)
>>
>> ************** Loaded Assemblies **************
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
>> file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
>> ---
>> System.Windows.Forms
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
>> ---
>> System
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
>> ---
>> System.Drawing
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
>> ---
>> System.Xml
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
>> ---
>> System.Management
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
>> ---
>> System.ServiceProcess
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
>> ---
>> ************** JIT Debugging **************
>> To enable just-in-time (JIT) debugging, the .config file for this
>> application or computer (machine.config) must have the
>> jitDebugging value set in the system.windows.forms section.
>> The application must also be compiled with debugging
>> enabled.
>> For example:
>> <configuration>
>> <system.windows.forms jitDebugging="true" />
>> </configuration>
>> When JIT debugging is enabled, any unhandled exception
>> will be sent to the JIT debugger registered on the computer
>> rather than be handled by this dialog box.
>> --
>> Mike - mhotek@.mssqlserver.com
>> President FilAm Software Technology, Inc
>> Vice-President MHS Enterprises, Inc
>> MCITP - SQL Server DBA, MCT
>> http://www.mssqlserver.com
>> http://www.mhse.net
>

Installed SQL Server 2005 CTP.. wheres enterprise manager?

Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murray
There is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluat...0/default.mspx
http://www.microsoft.com/sql/evaluat...5/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>

Installed SQL Server 2005 CTP.. wheres enterprise manager?

Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evalua...00/default.mspx
http://www.microsoft.com/sql/evalua...05/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>

Installed SQL Server 2005 CTP.. wheres enterprise manager?

Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.mspx
http://www.microsoft.com/sql/evaluation/sysreqs/2005/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>

installed sp3a but @@version still says sp2

Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
installed on F:\ (NOT C:). I choose default on the
installation because that is all it gave me, could not
type in. The installation went through and restarted
machine. MDAC got updated, but @.@.version in sql still
gives me 8.00.534.
Looks like databases have a updated modified date on them
bu they all say old version. Where did my update go? Any
files I can check for? Did it install it on C:'
Please help!Look for *.out files. If there are none, run the installation again with
the verbose logging option on (see the readme file for running setup from a
command line to change switches.)
"Kada" <kadahoffman@.hotmail.com> wrote in message
news:01a901c37faa$e952c730$a301280a@.phx.gbl...
> Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
> installed on F:\ (NOT C:). I choose default on the
> installation because that is all it gave me, could not
> type in. The installation went through and restarted
> machine. MDAC got updated, but @.@.version in sql still
> gives me 8.00.534.
> Looks like databases have a updated modified date on them
> bu they all say old version. Where did my update go? Any
> files I can check for? Did it install it on C:'
> Please help!|||Do you mean if I do not see something called sp3_repl.out
and sp3_serv_uni.out? Or what Out files should I see?
Thanks!
>--Original Message--
>Look for *.out files. If there are none, run the
installation again with
>the verbose logging option on (see the readme file for
running setup from a
>command line to change switches.)
>
>
>"Kada" <kadahoffman@.hotmail.com> wrote in message
>news:01a901c37faa$e952c730$a301280a@.phx.gbl...
>> Ran the sp3a (setup.bat) on server from G:\ then MSSQL
is
>> installed on F:\ (NOT C:). I choose default on the
>> installation because that is all it gave me, could not
>> type in. The installation went through and restarted
>> machine. MDAC got updated, but @.@.version in sql still
>> gives me 8.00.534.
>> Looks like databases have a updated modified date on
them
>> bu they all say old version. Where did my update go?
Any
>> files I can check for? Did it install it on C:'
>> Please help!
>
>.
>

Installation support for XP SP2

When I try to install SQL Server 2005 on my computer (Windows XP with SP2) I get a warning from the installer telling me that my operating system is not supported, this is the warning I get.

- SQL Server Edition Operating System Compatibility (Warning)
Messages
SQL Server Edition Operating System Compatibility

Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.

now I'm not able to install SQL Server itself, just the client components, does any one know a solution to this? thanks.
SQL Server Enterprise edition is not supported on Windows XP. You either need to change to a different edition (all other editions are supported on XP) or move to a different OS (like Windows 2003).|||

i installed sql 2005 enterprise edition on windows xp pro ,sp2 .

but it doesn't find any servers on my system,what should i do so?

|||

The servers from SQL Server 2005 Enterprise Edition can only be installed onto a Server OS (Windows 2000 SP4 Server, or W2k3 SP1 Enterprise) and cannot be installed onto Windows XP.

You may be able to install the Tools from Enterprise Edition onto XP, but that is it. You can install Developer Edition to XP if so desired...

-Jeffrey

Installation problem - Enterprise x64 on WS2K3 SP2

All,

I am attempting to install SQL Server 2005 x64 on a pristine WS2K3 R2 SP2 system. The only thing I have installed on the system so far is the .NET framework 3.0 for SharePoint.

The SQL Server installer works until I get to the Feature Selection screen. The only two features that are supported are the client tools and the Documentation. Nothing else.

Any ideas?

Scott

Sounds like you have a 32bit OS.

SQL Server 64 bit will NOT install on 32 bit OS.

|||

I just double checked... it's the 64-bit version of Windows Server 2003. I have also installed service pack 2.

Scott

|||

Are you using right CD?

I have seen two CD/DVDs somties, one contains client componets and other complete sql...

so you may need to double check your installation media.

Installation problem - Enterprise x64 on WS2K3 SP2

All,

I am attempting to install SQL Server 2005 x64 on a pristine WS2K3 R2 SP2 system. The only thing I have installed on the system so far is the .NET framework 3.0 for SharePoint.

The SQL Server installer works until I get to the Feature Selection screen. The only two features that are supported are the client tools and the Documentation. Nothing else.

Any ideas?

Scott

Sounds like you have a 32bit OS.

SQL Server 64 bit will NOT install on 32 bit OS.

|||

I just double checked... it's the 64-bit version of Windows Server 2003. I have also installed service pack 2.

Scott

|||

Are you using right CD?

I have seen two CD/DVDs somties, one contains client componets and other complete sql...

so you may need to double check your installation media.

Installation on Windows XP SP2

I try to install SQL Server 2000 SP3 on my Windows XP server.

During the installation, the setup process inform me database services can't be install on my machine.
I can only install client tools.

It seems to success, but when I try to connect register a new database in the Enterprise Manager tool, connection to my server databases always fail with error:
"waiting time expire"

If I try to connect to the same database with the Querty Analyzer it works.

How can I solve this problem ? His there a patch ?SQL Server 2000 is designed to run on a server OS so it won't install on XP. You can install msde and run small databases just fine.|||sql server standard and sql server enterprise editions are designed to install on server OS's. However, SQL Server Developer edition runs just fine on my windows xp with sp2 laptop.

the developer edition is exactly like SQL Std and Ent in tools looks and function. it is just limited in its client support. somewhere around 8 clients i believe.

on a side note, i worked on a really slow sql server once and found out that they had installed the dev edition on a production server......
pop the cd in
choose upgrade
restart
finished in 2 minutes. that'll be $100.00 please