Showing posts with label std. Show all posts
Showing posts with label std. Show all posts

Friday, March 30, 2012

Install RS on SQL2000

I have SQL2000 Developer installed my XP box. Look like I can't put any
except the trial version of RS. Does RS run on SQL Std and Ent only? I
want to play with RS but don't want to install the trial version. Is there
a workaround? Thanks.Hi,
I have SS2000 Developer SP3 AND RS2000 SP2 on my XP SP2 machine with no
problem.
You need to double-check what is the problem with your installation.
Best Regards
Jordi Rambla
SQL Server MVP
Solid Quality Learning
Spain

install Reporting service problem on SQL 2005 Express advanced Help please

Hi All,
I try to install reporting services with a french version of SQL 2005
Express Advanced on W2003 std SP1
Install of SQL2005 OK
When setup programm reach reporting service installation, i get an error
message( in french) :
"Le programme d'installation de SQL Server n'a pas pu récupérer le nom du
certificat SSL"
in English from my own translation : "SQL server installation program has
not been able to find SSL certificate"
This stop installation
detail of error give :
Linkid 20476
Nom du produit Microsoft sql Server
Version du Produit 9.00.2047.00
Source du mesage setup.rll
ID du message 29561
evtType
sqlca\sqlrsguica.cpp@.CheckRSSetupRequirements@.CheckRSSetupRequirements@.x7379
I try to install anyway reporting services via RSConfigTool
Install seems ok . Reporting services start ok
but http://mydomain/reports/Pages/folder.aspx give : Red cross Error
and message : "The request failed with HTTP status 400: Bad Request."
That we can find in C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\LogFiles:
----
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: The request failed with HTTP status
400: Bad Request.
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 400: Bad
Request.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
-----
Any idea '
MERCI beaucoup
Philippe
C.I.A ITI work around by desintalling IIS et re_install.
In fact i had installed a certificate via selfssl prior install reporting
services, as i have no option to remove this cerificate, the only way i
found, was to uninstall IIS
Philippe
"Philippe" <ph.boussaroque@.Espace-NTIC.com> a écrit dans le message de news:
ecmCyToUHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> I try to install reporting services with a french version of SQL 2005
> Express Advanced on W2003 std SP1
> Install of SQL2005 OK
> When setup programm reach reporting service installation, i get an error
> message( in french) :
> "Le programme d'installation de SQL Server n'a pas pu récupérer le nom du
> certificat SSL"
> in English from my own translation : "SQL server installation program has
> not been able to find SSL certificate"
> This stop installation
> detail of error give :
> Linkid 20476
> Nom du produit Microsoft sql Server
> Version du Produit 9.00.2047.00
> Source du mesage setup.rll
> ID du message 29561
> evtType
> sqlca\sqlrsguica.cpp@.CheckRSSetupRequirements@.CheckRSSetupRequirements@.x7379
> I try to install anyway reporting services via RSConfigTool
> Install seems ok . Reporting services start ok
> but http://mydomain/reports/Pages/folder.aspx give : Red cross Error
> and message : "The request failed with HTTP status 400: Bad Request."
> That we can find in C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\LogFiles:
> ----
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: The request failed with HTTP
> status 400: Bad Request.
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad
> Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> -----
> Any idea '
> MERCI beaucoup
> Philippe
> C.I.A IT
>
>

Wednesday, March 21, 2012

Install Error - SQL 2000 Std/ NT4SP6a

I get an error, saying a previous instance of setup did not complete, select
continue or cancel to end.
Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
for MSSQLSERVER, service entries etc., but setup keeps coming back with the
above message. Have not removed any files from \winnt or system32. Server
rest several times.
Is there some registry key in CurrentControlSet I need to delete'
Thought I knew SQL !!!
--
Thanks for any help!
Neil MillingtonCan you post the exact error message?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> I get an error, saying a previous instance of setup did not complete, select
> continue or cancel to end.
> Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> above message. Have not removed any files from \winnt or system32. Server
> rest several times.
> Is there some registry key in CurrentControlSet I need to delete'
> Thought I knew SQL !!!
> --
> Thanks for any help!
> Neil Millington|||Tibor... will post tonight as server is in ISP and I need to get behing
firewall!
Much appreciated.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>|||I suspect the error is that you have another setup (doesn't have to be a SQL Server setup) which is
in "pending" state. If so, search KB for a suitable part of the error message and you will find the
KB which describes the registry modification you need to perform...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:CDC4EFFD-BCDA-4C08-9DA5-E938DDA4DB72@.microsoft.com...
> Tibor... will post tonight as server is in ISP and I need to get behing
> firewall!
> Much appreciated.
> "Tibor Karaszi" wrote:
> > Can you post the exact error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> > news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > > I get an error, saying a previous instance of setup did not complete, select
> > > continue or cancel to end.
> > >
> > > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > > above message. Have not removed any files from \winnt or system32. Server
> > > rest several times.
> > >
> > > Is there some registry key in CurrentControlSet I need to delete'
> > >
> > > Thought I knew SQL !!!
> > > --
> > > Thanks for any help!
> > > Neil Millington
> >
> >
> >|||This was not the error message I was thinking of, I'm afraid. I suggest you start searching Google,
the newsgroup archives and KB. If you don't find anything there, consider posting this to the .setup
group. And be prepared to include the sqlstp.log file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:A8921334-D3E0-4AE1-9225-31E8FCAE562F@.microsoft.com...
> Tibor,
> Thanks for the reply, here is the message:
> <<
> setup has detected that the previous install attempt was not completed.
> Retry to continue installation or cancel to exit setup
> >>
> ...when selecting 'Retry' setup starts to file copy into \program
> files\microsoft sql server but fails when trying to run script 1 (as
> everything has been removed from drive/registry).
> Neil.
> "Tibor Karaszi" wrote:
> > Can you post the exact error message?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> > news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > > I get an error, saying a previous instance of setup did not complete, select
> > > continue or cancel to end.
> > >
> > > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > > above message. Have not removed any files from \winnt or system32. Server
> > > rest several times.
> > >
> > > Is there some registry key in CurrentControlSet I need to delete'
> > >
> > > Thought I knew SQL !!!
> > > --
> > > Thanks for any help!
> > > Neil Millington
> >
> >
> >|||Thanks Tibor...will post tonight, as server is in remote ISP and I need to
get behing the firewall.
Much appreciated,
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>|||Tibor,
Thanks for the reply, here is the message:
<<
setup has detected that the previous install attempt was not completed.
Retry to continue installation or cancel to exit setup
...when selecting 'Retry' setup starts to file copy into \program
files\microsoft sql server but fails when trying to run script 1 (as
everything has been removed from drive/registry).
Neil.
"Tibor Karaszi" wrote:
> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> > I get an error, saying a previous instance of setup did not complete, select
> > continue or cancel to end.
> >
> > Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> > for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> > above message. Have not removed any files from \winnt or system32. Server
> > rest several times.
> >
> > Is there some registry key in CurrentControlSet I need to delete'
> >
> > Thought I knew SQL !!!
> > --
> > Thanks for any help!
> > Neil Millington
>
>

Install Error - SQL 2000 Std/ NT4SP6a

I get an error, saying a previous instance of setup did not complete, select
continue or cancel to end.
Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
for MSSQLSERVER, service entries etc., but setup keeps coming back with the
above message. Have not removed any files from \winnt or system32. Server
rest several times.
Is there some registry key in CurrentControlSet I need to delete?
Thought I knew SQL !!!
Thanks for any help!
Neil Millington
Can you post the exact error message?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
> I get an error, saying a previous instance of setup did not complete, select
> continue or cancel to end.
> Have removed the SQL foldersfrom \Program Files\xxx and the registry keys
> for MSSQLSERVER, service entries etc., but setup keeps coming back with the
> above message. Have not removed any files from \winnt or system32. Server
> rest several times.
> Is there some registry key in CurrentControlSet I need to delete?
> Thought I knew SQL !!!
> --
> Thanks for any help!
> Neil Millington
|||Thanks Tibor...will post tonight, as server is in remote ISP and I need to
get behing the firewall.
Much appreciated,
Neil.
"Tibor Karaszi" wrote:

> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||Tibor... will post tonight as server is in ISP and I need to get behing
firewall!
Much appreciated.
"Tibor Karaszi" wrote:

> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||I suspect the error is that you have another setup (doesn't have to be a SQL Server setup) which is
in "pending" state. If so, search KB for a suitable part of the error message and you will find the
KB which describes the registry modification you need to perform...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:CDC4EFFD-BCDA-4C08-9DA5-E938DDA4DB72@.microsoft.com...[vbcol=seagreen]
> Tibor... will post tonight as server is in ISP and I need to get behing
> firewall!
> Much appreciated.
> "Tibor Karaszi" wrote:
|||Tibor,
Thanks for the reply, here is the message:
<<
setup has detected that the previous install attempt was not completed.
Retry to continue installation or cancel to exit setup[vbcol=seagreen]
...when selecting 'Retry' setup starts to file copy into \program
files\microsoft sql server but fails when trying to run script 1 (as
everything has been removed from drive/registry).
Neil.
"Tibor Karaszi" wrote:

> Can you post the exact error message?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Belmann" <SQLServer@.belmann.co.uk> wrote in message
> news:17D3E6B5-4465-4927-85F1-B73B5ADD70E7@.microsoft.com...
>
>
|||This was not the error message I was thinking of, I'm afraid. I suggest you start searching Google,
the newsgroup archives and KB. If you don't find anything there, consider posting this to the .setup
group. And be prepared to include the sqlstp.log file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Belmann" <SQLServer@.belmann.co.uk> wrote in message
news:A8921334-D3E0-4AE1-9225-31E8FCAE562F@.microsoft.com...[vbcol=seagreen]
> Tibor,
> Thanks for the reply, here is the message:
> <<
> setup has detected that the previous install attempt was not completed.
> Retry to continue installation or cancel to exit setup
> ...when selecting 'Retry' setup starts to file copy into \program
> files\microsoft sql server but fails when trying to run script 1 (as
> everything has been removed from drive/registry).
> Neil.
> "Tibor Karaszi" wrote: