Problem installing Advanced Services on Domain Controller

I try to install SQL Express Edition with Advanced Services on Small Business Server 2003 Standard Edition. Actually I install it without any problems.

I set database service (SQL SERVER (SQLEXPRESS)) to use domain account (administrator of domain). I configure report server windows identity to domain account (administrator of domain). When I try to access page Reports I have following problem . Error is

Unable to connect to the remote server.

Please, can somebody help me?

this is I found in log file

w3wp!ui!1!25.4.2006-08:00:35:: e ERROR: Unable to connect to the remote server
w3wp!ui!1!25.4.2006-08:00:37:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: Unable to connect to the remote server > System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
End of inner exception stack trace
at System.Net.HttpWebRequest.GetRequestStream()
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods()
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!25.4.2006-08:00:38:: 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)

What Reports are you trying to access? Do they have anything to do with SQL Express? (Are you talking about SQL Reporting Services?)

Why are you trying to run SQL Express on a Domain Controller in the first place?

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

I try to access http://localhost/reports$sqlexpress. (Yes this is reporting services.)

I have only one server in domain (small business server 2003). I do not want to install SQL Express with Advanced Services on client computer.

|||

I'm moving this over to the Reporting Service forum as they'll have a better idea what is going on with this issue.

- Mike