Greetings.
I just installed MSDE 2000A
How can I install northwind database on it ?
I looked up on the net and it asks you to install vs2003 version of MSDE
So do I have to del this and install the other MSDE ?
Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it
did not install northwind database for me.
Thanks
Hemang
http://www.microsoft.com/downloads/d...displaylang=en
should help.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hemang Shah" <hemang@.hemang.net> wrote in message
news:CfGdnTTggswyXX_cRVn-qg@.rogers.com...
> Greetings.
> I just installed MSDE 2000A
> How can I install northwind database on it ?
> I looked up on the net and it asks you to install vs2003 version of MSDE
> So do I have to del this and install the other MSDE ?
> Coz I did run the ConfigSamples.exe from my VS 2003 sdk directory, but it
> did not install northwind database for me.
> Thanks
> Hemang
>
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Friday, March 30, 2012
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?
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
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?
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 named instance with sample.msi
I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?
Thanks for any help,
Allan Sorenson
Crossroads technologyOriginally posted by B1ueboy
I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?
Thanks for any help,
Allan Sorenson
Crossroads technology
A little more info on the last edit:
Using Orca I added the row named 'SqlInstanceName' with the desired instance name as the value to the 'Property' table.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?
Thanks for any help,
Allan Sorenson
Crossroads technologyOriginally posted by B1ueboy
I need to install a named instance of the Desktop Engine, so I followed the directions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_74qd.asp
which has instructions on using Orca to modify sample.msi. I also followed the instructions found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_8yeq.asp
on how to edit the msi file to create a named instance.
YET, when used, this altered msi installs a DEFAULT instance.
Am I missing something? If so, what?
Thanks for any help,
Allan Sorenson
Crossroads technology
A little more info on the last edit:
Using Orca I added the row named 'SqlInstanceName' with the desired instance name as the value to the 'Property' table.
Installing My Reports
Hello All,
I have designed some Reports in RS, now i want to install it on
Production Machine (Web Server) but issue is that, production machine
doesnt have RS. Can it be possible to make any setup or package which
install required dll's to production machine without installing RS?
Please help me how to solve this.
Regards
RajeshRS is required if you wish to use RS to retrieve your report data as well as
provide report management capabilities. If you just want to display a
report on your web page you should look into using the new Report Viewer
controls that shipped with VS2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134627577.603210.61580@.g49g2000cwa.googlegroups.com...
> Hello All,
> I have designed some Reports in RS, now i want to install it on
> Production Machine (Web Server) but issue is that, production machine
> doesnt have RS. Can it be possible to make any setup or package which
> install required dll's to production machine without installing RS?
> Please help me how to solve this.
>
> Regards
> Rajesh
>|||Daniel,
Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
i just want to display reports on web page, can it be possible that i
use RS's dll or supporting files and install it on Production Machine
and run the reports?|||No, it is not possible. You need to install RS if you want to process the
reports. The only other option you have is the one I mentioned, using the
VS controls in 2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134714178.861590.319450@.f14g2000cwb.googlegroups.com...
> Daniel,
> Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
> i just want to display reports on web page, can it be possible that i
> use RS's dll or supporting files and install it on Production Machine
> and run the reports?
>
I have designed some Reports in RS, now i want to install it on
Production Machine (Web Server) but issue is that, production machine
doesnt have RS. Can it be possible to make any setup or package which
install required dll's to production machine without installing RS?
Please help me how to solve this.
Regards
RajeshRS is required if you wish to use RS to retrieve your report data as well as
provide report management capabilities. If you just want to display a
report on your web page you should look into using the new Report Viewer
controls that shipped with VS2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134627577.603210.61580@.g49g2000cwa.googlegroups.com...
> Hello All,
> I have designed some Reports in RS, now i want to install it on
> Production Machine (Web Server) but issue is that, production machine
> doesnt have RS. Can it be possible to make any setup or package which
> install required dll's to production machine without installing RS?
> Please help me how to solve this.
>
> Regards
> Rajesh
>|||Daniel,
Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
i just want to display reports on web page, can it be possible that i
use RS's dll or supporting files and install it on Production Machine
and run the reports?|||No, it is not possible. You need to install RS if you want to process the
reports. The only other option you have is the one I mentioned, using the
VS controls in 2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134714178.861590.319450@.f14g2000cwb.googlegroups.com...
> Daniel,
> Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
> i just want to display reports on web page, can it be possible that i
> use RS's dll or supporting files and install it on Production Machine
> and run the reports?
>
Installing Multiple Instances of ASP.NET Application Services on ONE SQL Server Database
Hi,
I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.
Please help if you can.
Thanks,
Ezeibe
Seems not possilble in 1 databases, but should be able in different databases on 1 SQL instance. Just use aspnet_regsql.exe to create schema for membership in serveral database, and then connect to 1 database respectively in your applications.Installing MSDTC Resource after installing SQL Server 2000 cluster
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
Andy
I am not an expert on clusters but you might want to check out the following article
http://support.microsoft.com/kb/294209/en-us
Michelle
Installing MSDE200A on Windows 2003
I have done a freresh install of Windows 2003, patches and now trying to
install MSDE RelA.
I use the command line "SETUP SAPWD="Password"" and it appears to install
successfully. I restart. When I try to install an application that uses
MSDE it claims there is no database.
I do a "netstat -an" and do not see anything listening on port 1433. I've
uninstalled and reinstalled with no change. What am I doing wrong?
Hi
In Control Panel > Services, Is the MSDE service there and running?
Regards
Mike
"Brian" wrote:
> I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||I do "Net Start" and MSSQLSERVER is listed. It is also displayed in the gui
as automatic and running.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> In Control Panel > Services, Is the MSDE service there and running?
> Regards
> Mike
> "Brian" wrote:
|||MSDE installs by default with Windows Security only. Setting an sa password
doesn't influence that. You also have to add SECURITYMODE=SQL to your setup
script if you want to use SQL Security.
You can change an MSDE installation to use SQL Security after it has been
installed by changing the registry key
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode to 2.
See:
http://support.microsoft.com/default...b;en-us;285097
for extensive info.
Jacco Schalkwijk
SQL Server MVP
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||Brian,
By default MSDE RelA installs with TCP protocol turned off for security
reasons. Use svrnetcn.exe in the Binn folder to enable protocols and
configure ports.
Ron Allen
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
install MSDE RelA.
I use the command line "SETUP SAPWD="Password"" and it appears to install
successfully. I restart. When I try to install an application that uses
MSDE it claims there is no database.
I do a "netstat -an" and do not see anything listening on port 1433. I've
uninstalled and reinstalled with no change. What am I doing wrong?
Hi
In Control Panel > Services, Is the MSDE service there and running?
Regards
Mike
"Brian" wrote:
> I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||I do "Net Start" and MSSQLSERVER is listed. It is also displayed in the gui
as automatic and running.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> In Control Panel > Services, Is the MSDE service there and running?
> Regards
> Mike
> "Brian" wrote:
|||MSDE installs by default with Windows Security only. Setting an sa password
doesn't influence that. You also have to add SECURITYMODE=SQL to your setup
script if you want to use SQL Security.
You can change an MSDE installation to use SQL Security after it has been
installed by changing the registry key
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode to 2.
See:
http://support.microsoft.com/default...b;en-us;285097
for extensive info.
Jacco Schalkwijk
SQL Server MVP
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||Brian,
By default MSDE RelA installs with TCP protocol turned off for security
reasons. Use svrnetcn.exe in the Binn folder to enable protocols and
configure ports.
Ron Allen
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
Installing MSDE??
Ok I installed the MSDE and after following the steps the last message box says to go to the control panel and install and configure the components.
I'm not sure what to do once I'm in the control panel.
Thank you.Somewhere along the way did you try to install MSDE but were unsuccessful? What is the exact wording of the message you are receiving?
Terri|||I am also having a problem with the installation of MSDE. About 2/3's the way through the installation the process froze. I cannot uninstall or re-install. The message I am receiving is that the installation was tampered with and needs to be uninstalled and re-installed. When I go to My Computer, Install/Uninstall Software, SQL Server is not listed.
Any suggestions?|||Well, searching the SQL Server and MSDE Forum here for posts from others who have experienced the same thing is a good start. And then starting a new thread with your own particular situation with the exact error messages would be the next step.
Terri|||i have the same probleme.
in my case it was an error of directory\subdirectory
c:\sql2ksp3\MSDE>
don't forget the MSDE subdirectory !! ;)
then type the command : setup SAPWD=xxxx SecurityMode=SQL
i hope it can help you.sql
Installing MSDE with a different instance name
Hi All,
I'm trying (and have been for ages) to install a MSDE server with adifferent instance name than the default. Im setting theinstancename when using the setup.exe file and all seems to installfine, but when I then restart my system the SQL icon appears in thesystem tray but the white circle is completely empty. It saysthat it is not connected.
If i install with the default instance name then all seems to work fine.
Does anyone know what I am doing wrong and what I can do to fix this problem?
Thanks in advance for any help!
The text below is from the BOL (books online). Hope this helps.
(When you install SQL Server 2000 on a computer with no existing installations of SQL Server, Setup specifies the installation of a default instance. However, you can choose to install SQL Server 2000 as a named instance instead by clearing the Default option in the Instance Name dialog box.)
I'm trying (and have been for ages) to install a MSDE server with adifferent instance name than the default. Im setting theinstancename when using the setup.exe file and all seems to installfine, but when I then restart my system the SQL icon appears in thesystem tray but the white circle is completely empty. It saysthat it is not connected.
If i install with the default instance name then all seems to work fine.
Does anyone know what I am doing wrong and what I can do to fix this problem?
Thanks in advance for any help!
The text below is from the BOL (books online). Hope this helps.
(When you install SQL Server 2000 on a computer with no existing installations of SQL Server, Setup specifies the installation of a default instance. However, you can choose to install SQL Server 2000 as a named instance instead by clearing the Default option in the Instance Name dialog box.)
Installing MSDE using VS.NET
Hi all,
I want to create setup/Installer project in Visual
Studio.NET 2003 that will detect MSDE. If MSDE already
installed then setup will not install MSDE , If not then
setup will install MSDE.
So please tell me have will i installed MSDE
using /Installer project in Visual Studio.NET 2003.
Thx in Advance
Amit
Hi Amit,
You can download MSDE toolkit, that is a plug-in to Microsoft Visual Studio
that automates the process of creating an integrated package with both the
application and the MSDE database, from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
This toolkit will help you in customizing and designing a setup for MSDE
that can be integrated with your application.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you ashish great link. I installed on my system
working fine
.
My next question is how i can add my database file in MSDE
using same VS.Net installer.
Amit
>--Original Message--
>Hi Amit,
>You can download MSDE toolkit, that is a plug-in to
Microsoft Visual Studio
>that automates the process of creating an integrated
package with both the
>application and the MSDE database, from
>http://www.microsoft.com/downloads/details.aspx?
FamilyID=6e9a7403-c4ba-4d98-
>bb0b-2c9d6414071f&DisplayLang=en
>
>This toolkit will help you in customizing and designing a
setup for MSDE
>that can be integrated with your application.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
You can go through the following technical article that helps in designing
classes for MSDE installation.
http://msdn.microsoft.com/library/de...us/dnmsde/html
/msdedepl.asp
According to that you can use the "AfterInstall" event to add the database
to the MSDE server.
According to my understanding, you will have to include the database files
in your setup and extract it to the desired location, and then execute the
"attachdb" function or the sp_attach_db stored procedure from the object.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you my installation nightmare is over.
But i have still one problem.
I am using trusted connection to connect my web site with
MSDE database.
In command line i use
osql -S myserver\Instancename -E connected successfully.
while connecting with my website it will give following
error.
"Login failed for user "servername\ASPNET"
i also use SQL connection in which i provide user id and
password but the result is same an error occurs.
"Login failed for user "sa". Reason: Not associated with
trusted SQL server Connection"
please tell me where i am wrong.
Thanks
Amit
>--Original Message--
>Hi Amit,
>You can go through the following technical article that
helps in designing
>classes for MSDE installation.
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html
>/msdedepl.asp
>
>According to that you can use the "AfterInstall" event to
add the database
>to the MSDE server.
>According to my understanding, you will have to include
the database files
>in your setup and extract it to the desired location, and
then execute the
>"attachdb" function or the sp_attach_db stored procedure
from the object.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
The user servername\ASPNET is the default user name that the ASP.NET process
runs as within the operating system. It is configured in the machine.config
file. By default, it has no access to your databases.
You have three basic options:
1. Grant appropriate database access to the ASPNET user.
2. Use impersonation on the site - configured in your web.config file (ie
impersonate the windows user that the end user is connecting as - not great
for public sites of any type)
3. Have your application log on as a specific user and grant that user
access to the database.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Amit" <anonymous@.discussions.microsoft.com> wrote in message
news:213c01c42794$69f54020$a101280a@.phx.gbl...[vbcol=seagreen]
> Hi Ashish,
> Thank you my installation nightmare is over.
> But i have still one problem.
> I am using trusted connection to connect my web site with
> MSDE database.
> In command line i use
> osql -S myserver\Instancename -E connected successfully.
> while connecting with my website it will give following
> error.
> "Login failed for user "servername\ASPNET"
> i also use SQL connection in which i provide user id and
> password but the result is same an error occurs.
> "Login failed for user "sa". Reason: Not associated with
> trusted SQL server Connection"
>
> please tell me where i am wrong.
>
> Thanks
> Amit
>
> helps in designing
> url=/library/en-us/dnmsde/html
> add the database
> the database files
> then execute the
> from the object.
> confers no rights.
sql
I want to create setup/Installer project in Visual
Studio.NET 2003 that will detect MSDE. If MSDE already
installed then setup will not install MSDE , If not then
setup will install MSDE.
So please tell me have will i installed MSDE
using /Installer project in Visual Studio.NET 2003.
Thx in Advance
Amit
Hi Amit,
You can download MSDE toolkit, that is a plug-in to Microsoft Visual Studio
that automates the process of creating an integrated package with both the
application and the MSDE database, from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
This toolkit will help you in customizing and designing a setup for MSDE
that can be integrated with your application.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you ashish great link. I installed on my system
working fine
.My next question is how i can add my database file in MSDE
using same VS.Net installer.
Amit
>--Original Message--
>Hi Amit,
>You can download MSDE toolkit, that is a plug-in to
Microsoft Visual Studio
>that automates the process of creating an integrated
package with both the
>application and the MSDE database, from
>http://www.microsoft.com/downloads/details.aspx?
FamilyID=6e9a7403-c4ba-4d98-
>bb0b-2c9d6414071f&DisplayLang=en
>
>This toolkit will help you in customizing and designing a
setup for MSDE
>that can be integrated with your application.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
You can go through the following technical article that helps in designing
classes for MSDE installation.
http://msdn.microsoft.com/library/de...us/dnmsde/html
/msdedepl.asp
According to that you can use the "AfterInstall" event to add the database
to the MSDE server.
According to my understanding, you will have to include the database files
in your setup and extract it to the desired location, and then execute the
"attachdb" function or the sp_attach_db stored procedure from the object.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you my installation nightmare is over.
But i have still one problem.
I am using trusted connection to connect my web site with
MSDE database.
In command line i use
osql -S myserver\Instancename -E connected successfully.
while connecting with my website it will give following
error.
"Login failed for user "servername\ASPNET"
i also use SQL connection in which i provide user id and
password but the result is same an error occurs.
"Login failed for user "sa". Reason: Not associated with
trusted SQL server Connection"
please tell me where i am wrong.
Thanks
Amit
>--Original Message--
>Hi Amit,
>You can go through the following technical article that
helps in designing
>classes for MSDE installation.
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html
>/msdedepl.asp
>
>According to that you can use the "AfterInstall" event to
add the database
>to the MSDE server.
>According to my understanding, you will have to include
the database files
>in your setup and extract it to the desired location, and
then execute the
>"attachdb" function or the sp_attach_db stored procedure
from the object.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
The user servername\ASPNET is the default user name that the ASP.NET process
runs as within the operating system. It is configured in the machine.config
file. By default, it has no access to your databases.
You have three basic options:
1. Grant appropriate database access to the ASPNET user.
2. Use impersonation on the site - configured in your web.config file (ie
impersonate the windows user that the end user is connecting as - not great
for public sites of any type)
3. Have your application log on as a specific user and grant that user
access to the database.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Amit" <anonymous@.discussions.microsoft.com> wrote in message
news:213c01c42794$69f54020$a101280a@.phx.gbl...[vbcol=seagreen]
> Hi Ashish,
> Thank you my installation nightmare is over.
> But i have still one problem.
> I am using trusted connection to connect my web site with
> MSDE database.
> In command line i use
> osql -S myserver\Instancename -E connected successfully.
> while connecting with my website it will give following
> error.
> "Login failed for user "servername\ASPNET"
> i also use SQL connection in which i provide user id and
> password but the result is same an error occurs.
> "Login failed for user "sa". Reason: Not associated with
> trusted SQL server Connection"
>
> please tell me where i am wrong.
>
> Thanks
> Amit
>
> helps in designing
> url=/library/en-us/dnmsde/html
> add the database
> the database files
> then execute the
> from the object.
> confers no rights.
sql
Installing MSDE SQL 2000 SP4
I was working on a install for MSDE SQL SERVER 2000 when I noticed that there
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:
> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:
> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
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.
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 Engine1.. 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 2000 Release A on a XP Home Machine
Hi,
I'd like to install MSDE 2000 Release A on a XP Home machine via the
command-prompt switches and parameters. I have two areas of ignorance:
1) At first blush, it seems to me that I'll have disparate server names. By
this I mean that when I install MSDE on my computer to conduct the
development, it will have the name "Server_Name"\"Instance_Name". My
server's called "Dell," So I'll have a MSDE instance of,
DELL\"Instance_Name" On the other hand, the target server, an XP Home
machine, is called "SherPerf." So this server instance will be named
SHERPERF\"Instance_Name"
I plan on using an Access adp front end. I don't know how to code viable
connection strings around disparate server names. I.E. in development I'm
connecting to server name #1; but, in production I'm connecting to server
name #2.
What am I missing?
2) If I want to use Windows Authentication, should I create a new user? If
so, what groups should this user be part of? Is it standard practice to
create a user account for MSDE programmatically? If so, how do I do this?
LDAP?
I realize this is a lot to ask. Thanks in advance.
--
Mark Holahan
You application should utilize a configuration file or the registry to store
the ADO connection string or the parameters for the connection string. Then
you would simply change the configuration information to point to another
server. Making a connection string for a different server is easy - just
replace one server name with another. See the Books Online for more
information about ADO or ADO.NET connection strings and how to construct
them.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'd like to install MSDE 2000 Release A on a XP Home machine via the
> command-prompt switches and parameters. I have two areas of ignorance:
> 1) At first blush, it seems to me that I'll have disparate server names.
> By this I mean that when I install MSDE on my computer to conduct the
> development, it will have the name "Server_Name"\"Instance_Name". My
> server's called "Dell," So I'll have a MSDE instance of,
> DELL\"Instance_Name" On the other hand, the target server, an XP Home
> machine, is called "SherPerf." So this server instance will be named
> SHERPERF\"Instance_Name"
> I plan on using an Access adp front end. I don't know how to code viable
> connection strings around disparate server names. I.E. in development I'm
> connecting to server name #1; but, in production I'm connecting to server
> name #2.
> What am I missing?
> 2) If I want to use Windows Authentication, should I create a new user? If
> so, what groups should this user be part of? Is it standard practice to
> create a user account for MSDE programmatically? If so, how do I do this?
> LDAP?
> I realize this is a lot to ask. Thanks in advance.
> --
> --
> Mark Holahan
>
|||Thanks Jim! Yes...of course. Can you tell I haven't done this before?
Do you have any comment regarding my second question?
Many thanks.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
> You application should utilize a configuration file or the registry to
> store the ADO connection string or the parameters for the connection
> string. Then you would simply change the configuration information to
> point to another server. Making a connection string for a different server
> is easy - just replace one server name with another. See the Books Online
> for more information about ADO or ADO.NET connection strings and how to
> construct them.
> Jim
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
>
|||Regarding question #2 - If your computers are not a member of a domain then
Windows authentication will be of less importance and all user will be local
to the machine they are running on. If you have the chance to use Windows
security then what groups the users are a member of is entirely up to you.
Ideally you would make the groups the logins to the server and the add the
user to the groups. That way you do not have to add each user individually
as a login to the server.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:eaXlKZ2DFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Thanks Jim! Yes...of course. Can you tell I haven't done this before?
> Do you have any comment regarding my second question?
> Many thanks.
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
>
I'd like to install MSDE 2000 Release A on a XP Home machine via the
command-prompt switches and parameters. I have two areas of ignorance:
1) At first blush, it seems to me that I'll have disparate server names. By
this I mean that when I install MSDE on my computer to conduct the
development, it will have the name "Server_Name"\"Instance_Name". My
server's called "Dell," So I'll have a MSDE instance of,
DELL\"Instance_Name" On the other hand, the target server, an XP Home
machine, is called "SherPerf." So this server instance will be named
SHERPERF\"Instance_Name"
I plan on using an Access adp front end. I don't know how to code viable
connection strings around disparate server names. I.E. in development I'm
connecting to server name #1; but, in production I'm connecting to server
name #2.
What am I missing?
2) If I want to use Windows Authentication, should I create a new user? If
so, what groups should this user be part of? Is it standard practice to
create a user account for MSDE programmatically? If so, how do I do this?
LDAP?
I realize this is a lot to ask. Thanks in advance.
--
Mark Holahan
You application should utilize a configuration file or the registry to store
the ADO connection string or the parameters for the connection string. Then
you would simply change the configuration information to point to another
server. Making a connection string for a different server is easy - just
replace one server name with another. See the Books Online for more
information about ADO or ADO.NET connection strings and how to construct
them.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I'd like to install MSDE 2000 Release A on a XP Home machine via the
> command-prompt switches and parameters. I have two areas of ignorance:
> 1) At first blush, it seems to me that I'll have disparate server names.
> By this I mean that when I install MSDE on my computer to conduct the
> development, it will have the name "Server_Name"\"Instance_Name". My
> server's called "Dell," So I'll have a MSDE instance of,
> DELL\"Instance_Name" On the other hand, the target server, an XP Home
> machine, is called "SherPerf." So this server instance will be named
> SHERPERF\"Instance_Name"
> I plan on using an Access adp front end. I don't know how to code viable
> connection strings around disparate server names. I.E. in development I'm
> connecting to server name #1; but, in production I'm connecting to server
> name #2.
> What am I missing?
> 2) If I want to use Windows Authentication, should I create a new user? If
> so, what groups should this user be part of? Is it standard practice to
> create a user account for MSDE programmatically? If so, how do I do this?
> LDAP?
> I realize this is a lot to ask. Thanks in advance.
> --
> --
> Mark Holahan
>
|||Thanks Jim! Yes...of course. Can you tell I haven't done this before?
Do you have any comment regarding my second question?
Many thanks.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
> You application should utilize a configuration file or the registry to
> store the ADO connection string or the parameters for the connection
> string. Then you would simply change the configuration information to
> point to another server. Making a connection string for a different server
> is easy - just replace one server name with another. See the Books Online
> for more information about ADO or ADO.NET connection strings and how to
> construct them.
> Jim
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:unoBXFtDFHA.2600@.TK2MSFTNGP09.phx.gbl...
>
|||Regarding question #2 - If your computers are not a member of a domain then
Windows authentication will be of less importance and all user will be local
to the machine they are running on. If you have the chance to use Windows
security then what groups the users are a member of is entirely up to you.
Ideally you would make the groups the logins to the server and the add the
user to the groups. That way you do not have to add each user individually
as a login to the server.
Jim
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:eaXlKZ2DFHA.3824@.TK2MSFTNGP10.phx.gbl...
> Thanks Jim! Yes...of course. Can you tell I haven't done this before?
> Do you have any comment regarding my second question?
> Many thanks.
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%23ioGNN0DFHA.3536@.TK2MSFTNGP15.phx.gbl...
>
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
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 MSDE 2000 on a system with SQL Express 2005
I noticed that when I install an app that uses MSDE 2000 on my system (which
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 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.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 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.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 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.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 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.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)