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 MSDE SP3 to Win98 causes an error.

Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

To create the installation I used the VisualStudio installer. Afte the installtion I use ORCA and edit the MSI with the following values in the property table.

ProductLanguage = 1033
SqlBlankPwd = 1
SqlSecurityMode = SQL

No special actions are being used by my installer. Yet according to MS the reason for my error is that I am using a special action with a non-c++ dll (KB Article (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B306627)) . I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Mike Villaronga
mike_villaronga@.yahoo.com

LogFile:

Internal Error 2737. StreamSupportFiles.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B, C:\WINDOWS\TEMP\MSI60B6.TMP, StreamSupportFiles
=== Logging stopped: 2/3/03 10:06:17 ===I have not gotten SP3 to install on win98. I have tried to do it manually as well as from an install shield application. I get an error message that there is a dll missing. It doesn't specify which dll or give any kind of clue.

[SIZE=1]Originally posted by mvillaronga
Ok I have an MSI file that installs an instance of the MSDE. I recently updated my install to used the SP3 MSMs of the MSDE. I have the installation working correctly on XP. However it fails rather quickly on install to Win98. I will paste the log file of the failure below.

I am guessing that this is something that MS is doing. Has anyone else gotten a successful install of SP3 onto Win98? Any info would be helpful.

Installing MSDE SA password error.

I've been trying to install MSDE so i could run ASP.Net Forums. But whenever i run the setup.exe file, it gives me a pop up message with the following message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to the readme for more details. Set up will now Exit."

Could any body please tell me what to do??...

Yes. I'm stupid. And please excuse my ignoracne.Go to run and type the following replace path and password optionally you can specify authentication mode (default is windows) SECURITYMODE=SQL.

f:\sql2ksp3\MSDE\setup.exe sapwd="password"

Hope this helps

Regards
S(:

installing msde 2000a

I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following......

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit"

Does any one know what I need to do to fix this?

-Thanks

Try reading the 'Readme' file. There you will see the instructions to include the /SAPWD switch and also include a password during installation.

|||To install a new instance of Desktop Engine

1.. Open a command prompt window.

2.. From the command prompt, use the cd command to navigate to the folder
containing the MSDE 2000 SP3a setup utility:
cd c:\MSDESP3aFolder\MSDE

where c:\MSDESP3aFolder is either the path to the folder into which you
extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the
SQL Server 2000 SP3a CD.

3.. Execute one of the following commands:

The following is from the "sp3readme.htm" file located in the same folder as
the setup.exe file.

You have to install a named instance configured to use Mixed Mode, execute:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"Where
AStrongSAPwd is a strong password to be assigned to the sa login and
InstanceName is the name to be assigned to the instance.

installing msde 2000a

I tried to install the MSDE 2000A to have a copy of the SQL Server northwind datbase on my machine. When I was installing it I got an error that said the following......

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Set up will now exit"

Does any one know what I need to do to fix this?

-Thanks

Try reading the 'Readme' file. There you will see the instructions to include the /SAPWD switch and also include a password during installation.

|||To install a new instance of Desktop Engine

1.. Open a command prompt window.

2.. From the command prompt, use the cd command to navigate to the folder
containing the MSDE 2000 SP3a setup utility:
cd c:\MSDESP3aFolder\MSDE

where c:\MSDESP3aFolder is either the path to the folder into which you
extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the
SQL Server 2000 SP3a CD.

3.. Execute one of the following commands:

The following is from the "sp3readme.htm" file located in the same folder as
the setup.exe file.

You have to install a named instance configured to use Mixed Mode, execute:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"Where
AStrongSAPwd is a strong password to be assigned to the sa login and
InstanceName is the name to be assigned to the instance.

installing MSDE

Hi:
I'm just getting started with ASP.net and am trying to install MSDE. I am getting the error message : Instance specified name is invalid.
I have followed the directions in the downloadpage. Any help??

Thanks
Crystal.How are you installing it?|||Do you have another version of SQL Server running, i.e. 7.0? You may not be able to install MSDE with MSSQL7 running.

Installing MSDE

Hello All:

I am having a problem with installing MSDE. I do not have SQL Server 2000 installed on my computer, but I am getting the error, "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same..." If I am not running SQL Server, how can I get an SA password so I can complete the install. Thanks for the help in advance.

- Jesse Williamsthere's a command-line swicth in the MSDE installer program for setting the SAPWD

check the readme file that came with the installer, or run this:

setup.exe /?

I can't recall the usage off the top of my head I'm afraid.|||Take a look at this as well:http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1. More info on MSDE can be found on support.microsoft.com.|||I figured it out after I posted and did some research on this forum and read the read me. Correct, it is a command line switch. There are two ways to configure the installation: thru the setup.ini or at the command line. If you go with setup.ini add these parameters under [Options]:
instancename="nameofyourserver"
targetdir="C:\path"
datadir="C:\path"
securitymode=sql

targetdir is the folder that setup will install the executables for MSDE
datadir is the folder that will house the data
instancename is the name of your server instance

After saving the setup.ini return to the command prompt and type
setup /settings "setup.ini" sapwd="strongpwd"
This will allow you to set the sa password more securely.

You can also achieve the same at the command prompt instead of using the setup.ini:

setup instancename="nameofyourserver" targetdir="C:\path" datadir="C:\path" securitymode=sql sapwd="strongpwd"

Hope this helps for the future. Thanks for everyones help.

- Jesse

Installing Microsoft Dynamics 10.0 with Microsoft SQL Server 2008 "Katmai"

Hi,

I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:

******************************************************************

Your current SQL Server is not a supported version.

Req: Microsoft SQL Server 8.0

Act: Microsoft SQL Server code name "Katmai" (CTP) - 10

You need to upgrade to SQL Server 8.0 before continuing.

******************************************************************

Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?

Assad

Well, not supported.

http://www.microsoft.com/dynamics/gp/using/10systemrequirements.mspx

Database

One of the following:

?

SQL Server 2005 SP2 Standard Edition 32-bit, Workgroup Edition, or Express Edition

?

SQL Server 2000 SP4 Standard Edition or Workgroup Edition

?

MSDE 2000 SP4

In this phase nothing is designed to work with a beta :-)

Jens K. Suessmeyer

http://www.sqlserver2005.de

Installing Express Issue

I have just installed Sql Express

But one installed all I have available to me is

Sql Server Config Man

Sql Server Error reporting Usage

Surface area config

IDoes any one know how to get the other features like the databases and reporting installed

thanks for any help Sammy

YOu will have to install the advanced edition for that. The normal edition does not include the reporting Service nor any database administration surface like the Management Studio.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing error for SQL Server 2000 SP4

I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.
<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegr oups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
sql

Installing error for SQL Server 2000 SP4

I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Installing error for SQL Server 2000 SP4

I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Installin sqlserver 2005 error

I get the following error message when I install sqlserver 2005.

TITLE: Microsoft SQL Server 2005 Setup

The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5

BUTTONS:

&Retry
Cancel

Anybody got an idea?

Thanks

Hi ttfo,

Are you remotely installing SQLExpress? If so please see this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;896613
You cannot connect to Visual Studio SQL Server Express on a remote Windows XP Service Pack 2-based computer

HTH

Jeremy

|||

Jeremy,

Thanks for the reply.

I am not remotely installing.

ttfo

|||does the directory have write permission?|||

ahmedilyas,

Not sure which directory it is trying to update.

Thanks,

Tony

|||

Hi Tony,

Thanks for the update.

TITLE: Microsoft SQL Server 2005 Setup

The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5

1. Regarding the error message when you install sqlserver 2005. Can you confirm the following points, cheers:
a. Operating System? (XP?)

b. OS Service Pack level? (SP2?)

c. What flavour of SQL? (Express?)

c. Is this a second instance of SQL or the default one thats failing? (first based on the registry key error?)

d. Have you logged on as local administrator, cleared the temp directory, copied the files onto to the C:\ and tried to install from harddisk?

2. Should you continue to experience problems with this machine, is it possible to test with another PC or rebuild the problematic one?

I've encountered this issue on one PC, yet I was able to install SQL Express successfully on another PC via RDP at the same site but not on another PC that was producing the error your seeing. To cut a long story short, we got onsite staff to reboot the (WinXP SP2) Pc and it started showing symptoms seen in this KB article:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;826955
"Virus alert about the Blaster worm and its variants"

3. If you can NOT get another PC to rule-out virus, hardware, media &/or etc related issues as the root cause and would like to pursue troubleshooting.. Can you please run FileMon & RegMon traces (and provide the SQL SETUP LOGS) on the PC while your installing SQL?

Based on the error message, the problem stems from "Error opening file for write: 5." and the API for GetLastError reports a Registry key is to blame: "GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup." - hence the FileMon and Regmon traces are needed to aid troubleshooting,

To get a FileMon & RegMon traces

goto www.SysInternals.com (I believe the company and its tools were recently purchased by Microsoft - Mark Russinovich and Bruce Cogwell)

Search for FileMon/Regmon
Scroll to bottom of pages
Download the Programs

0. Remote in as Admin and clear the Temp directory.

1. Save Filemon and Regmon to the PC
2. Get ready to start the SQL Express install
3. Launch open Filemon and Regmon. - To start with I recommend stopping the traces and clearing the logs (with tool bar buttons) because when you launch open the programs they quickly start tracing out Disk and Registry Activity
4. When you get very close to the problem occurring start FileMon/RegMon together - tracing out all the activity in real-time.
5. After you encounter the problem, stop the FileMon/Regmon traces
6. Zip up ALL the traces INCLUDING ALL THE SQL SETUP LOGS YOU CAN FIND - hehe and also RUN THE "mps reports" -sql flavour, on the pc - and post them online!!

Regarding the error messages link: setup.rll 2380 error, try looking in your application event log for the events leading up to the problem and cross reference them with www.EventID.net

HTH

PS the tip to analysing these Regmon/FileMon files is (off the top of my head) > Excel > Data menu > Filter item > Auto Filter item. Then select the combobox with Success, Path not found > and set it to DEVICE DATA ERROR or ACCESS DENIED & hunt down those leads!!

|||

Thanks for the reply, although I am a little late in responding. I ended up formating the disk and starting over. It worked ok then.

Thansk for the help.

|||

Thanks for the update Tony,

Good move reformatting the HDD... as your dont want a production system thats potentially been corrupted.

Cheers,

Jeremy

installiation error help plz

when i start to install SQL and followed this guide:
Run SQL Setup
Select "SQL Server 2000 Components"
1. Click "Install Database Server"
2. Click Next
3. Select "Local Computer" and click Next
4. Select "Create a new instance of SQL Server,or install Client Tools" and
click next
5. Put name and company and click Next
6. Click Yes to Agreement
7. Select "Server and Client Tools" and click Next
8. Select Default at the top of the screen (So that there is a mark in the
little box) and click Next
9. Select "Typical" and click Next
10. Select "Use the same account for each service. Auto start SQL Server
Service"
11. In the same screen also select "Use the Local System account" and then
click Next
12. Select "Windows Authenticatication Mode." and click Next
13. Click Next and install
then i install and he makes the files but when he gonna confrigate the
server it stopez with an error <cant finisch. for more information look
c:/microsoft/fttp.log>
and the .log says this:
----
Starting Service ...
Latin1_General_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=cp685845-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=cp685845-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
driver={sql server};server=cp685845-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()).
SQL Server configuration failed.
----
someone now whats wrong? help would be nice
I have had the same thing happen to me. I noticed that we both have hyphens in our computer name.
Did you get this fixed?
Please let me know how.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

installiation error help plz

when i start to install SQL and followed this guide:
Run SQL Setup
Select "SQL Server 2000 Components"
1. Click "Install Database Server"
2. Click Next
3. Select "Local Computer" and click Next
4. Select "Create a new instance of SQL Server,or install Client Tools" and
click next
5. Put name and company and click Next
6. Click Yes to Agreement
7. Select "Server and Client Tools" and click Next
8. Select Default at the top of the screen (So that there is a mark in the
little box) and click Next
9. Select "Typical" and click Next
10. Select "Use the same account for each service. Auto start SQL Server
Service"
11. In the same screen also select "Use the Local System account" and then
click Next
12. Select "Windows Authenticatication Mode." and click Next
13. Click Next and install
then i install and he makes the files but when he gonna confrigate the
server it stopez with an error <cant finisch. for more information look
c:/microsoft/fttp.log>
and the .log says this:
----
----
----
--
Starting Service ...
Latin1_General_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=cp685845-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General networ
k error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
(recv()).
driver={sql server};server=cp685845-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General networ
k error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
(recv()).
driver={sql server};server=cp685845-a;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General networ
k error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead
(recv()).
SQL Server configuration failed.
----
----
----
--
someone now whats wrong? help would be niceI have had the same thing happen to me. I noticed that we both have hyphens
in our computer name.
Did you get this fixed?
Please let me know how.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Installed OK but cannot logon

I just installed MSDE (got successful install msg in Log) but now cannot logon.
I get 'Connection failed SQL State 08001 Error 17
I'm using the SA userid and password I entered upon installing
I'm attempting this via Visual Studio 2003
What could the problem be?
-David
hi David,
mscertified wrote:
> I just installed MSDE (got successful install msg in Log) but now
> cannot logon. I get 'Connection failed SQL State 08001 Error 17
> I'm using the SA userid and password I entered upon installing
> I'm attempting this via Visual Studio 2003
> What could the problem be?
is this a local or remote connection?
try connecting via oSql.exe and verify the full exception you are prompted
with
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installation: SQL Server 2005 surface area configuration, error WI

Hello,
I'm trying to install RS 2005 on my server.
First the installation is ok, to validate it I checked (as explained in the
installation guide) with "SQL Server 2005 surface area configuration", but I
have always an error when I want to validate the "windows intergated
security".
The error is: "Argument value wa not passed for the argument reporting
service URL. (Microsoft.sqlsac.public)".
Details are: "--
Program Location:
at
Microsoft.SqlSac.Public.ReportingServices.GetReportingServiceProxy(String
reportingUrl)
at Microsoft.SqlSac.Public.ReportingServices.GetSettings(String
givenInstanceName, ReportingFeature feature, String serverName)
at
Microsoft.SqlSac.MainPanel.WindowsIntegratedSecurity.GetCurrentSettings(String machineName)
at Microsoft.SqlSac.MainPanel.FormFeatures.DisplayLeaf(TreeView tree,
ETreeNode selected)
at Microsoft.SqlSac.MainPanel.FormFeatures.OnTimer(Object source,
ElapsedEventArgs eArgs)".
I don't want to continue the installation (use reporting service
configuration tool) before resolve this issue.
Thanks for your help.
PascalHi,
I am also trying to install RS 2005 on my server
and getting the same problem, can any one pl. help us to resolve this
issue.
Thanks
plkumar
pbrel wrote:
> Hello,
> I'm trying to install RS 2005 on my server.
> First the installation is ok, to validate it I checked (as explained in the
> installation guide) with "SQL Server 2005 surface area configuration", but I
> have always an error when I want to validate the "windows intergated
> security".
> The error is: "Argument value wa not passed for the argument reporting
> service URL. (Microsoft.sqlsac.public)".
> Details are: "--
> Program Location:
> at
> Microsoft.SqlSac.Public.ReportingServices.GetReportingServiceProxy(String
> reportingUrl)
> at Microsoft.SqlSac.Public.ReportingServices.GetSettings(String
> givenInstanceName, ReportingFeature feature, String serverName)
> at
> Microsoft.SqlSac.MainPanel.WindowsIntegratedSecurity.GetCurrentSettings(String machineName)
> at Microsoft.SqlSac.MainPanel.FormFeatures.DisplayLeaf(TreeView tree,
> ETreeNode selected)
> at Microsoft.SqlSac.MainPanel.FormFeatures.OnTimer(Object source,
> ElapsedEventArgs eArgs)".
> I don't want to continue the installation (use reporting service
> configuration tool) before resolve this issue.
> Thanks for your help.
> Pascal

Installation probs

I keep getting errors while trying to install SQL 2000 enterprise edition.....

Internal Error: Contact MS Tech Support

Help !!!

Hi

Which version of Windows Server are you using for installation ?

There should be a sqlstp.log files in your Windows directory, you can find detailed error information in it.

oshener

|||

I use Windows server 2003

The log file says

"04:08:54 BEGIN SETUP

04:08:54 8.00.194

04:08:54 Mode=Normal

04:08:55 Install the product by running setupsql.exe"

Thats it.....

When I run setupsql.exe, it gives me an error....

|||

Do you use a CD or network share ?