Configure Reporting Service - Unable To Connect To The Remote Server

Feb 20, 2008

Vista + SQL Server 2005
Reporting Service Configuration Tool: No Red Cross.
http://localhost/reportserver get this error:
HTTP Error 403.1 - Forbidden
You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run.
http://localhost/reports get this error:
w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: Unable to connect to the remote server
w3wp!ui!4!20/02/2008-17:17:04:: 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 127.0.0.1:443
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.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!4!20/02/2008-17:17:06:: 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)



I googled but not found anything useful.
Thanks in advance!!!

View 8 Replies


ADVERTISEMENT

Unable To Configure Reporting Service

Oct 12, 2007

Hi all, I tried to configure reporting services configuration by the following

step 1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and click Reporting Services Configuration.


when i did the above step, i received the following error..

No report servers were found on the specified machine.
Details: Invalid namespace


But i installed SQL server 2005 version.
Pls help me to solve this..

Thanks in advance..

Regards Nataraj.C

View 1 Replies View Related

Unable To Configure Database Setup In Reporting Service 2005

Apr 29, 2008



Hi,

I have installed SQL Reporting Service on one server. Using the config tool, I am trying to setup the Reporting Database on a seperate SQL instance. This SQL instance is running on a Clustered SQL 2005 server.

The creation of the Database is sucessful. However when I give the Windows credentials to connect to this database on the same page, I always fail at the following task : Setting Connection Info for Reporting Server. The error message is :

"System.Runtime.InteropServices.COMException (0x800706B3)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.Get()
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetDatabaseConnection(String server, String database, ConfigurationCredentialsType credsType, String userName, String password)"

The Windows Account I am using has Full SQL Rights to the Clustered SQL Server. I have seen other posts on the forums about the 0x800706B3 error, but most of them are related to a problem with RPC.

The Reporting Services account is runing under 'Network Services'. I am not sure if this is causing the problem?

Thoughts anybody?

Thanks,

Mahmood




View 8 Replies View Related

Configure Distribution Wizard - Unable To Connect To Server

Apr 25, 2007

I am been trying to setup replication on my local Developer edition copy of SQL Server 2005 SP1, but I keep running to into this unable to connect to server error within MS SQL Server Management Studio environment. I tried various connection settings under the configuration manager and things like adding entries to my host file with no luck. Understand that this requires the server name but failing at providing this for the connection to start the wizard. I am missing something simple here?



Darryl

View 9 Replies View Related

Unable To Connect To A New Remote SQL Server

Jul 22, 2005

My VS 2005 website project was connecting to a remote SQL Server. But after I move the database to the second SQL Server, I got the following error message from running my website project:
 
Named Pipes Provider: Logon failure: unknown user name or bad password.
 
 
I do everything same like what I did in the first SQL server:
 

Using “SQL Server and Windows� authentication and “System account�;
Create a domain account IIS_WPG;
Grant this IIS_WPG as db_owner for the database;
In web.config, add the name and password to the end of connectionstring;
Make sure the SQL Server has “Named Pipes� and “TCP/IP� protocols.
 
I have no idea what I can do else, anybody has suggestions?
 

View 3 Replies View Related

Unable To Connect To The Remote Server

Jul 13, 2006

Greetings:

We have a copy of SQL2k Report Services running on a Windows 2003 Server. But the database used by the Reports is actually on another box in our network. (This is a option you can use during install.) This setup worked fine for about a year but now neither the reports and ReportManager no longer run. The Reporting services Log error is:

System.Net.WebException: The underlying connection was closed: Unable to connect to the remote server.

In a browser we get the error:

---

"Directory Listing Denied"

"This Virtual Directory does not allow contents to be listed."

---

Turning on the option to list directory contents in IIS does not resolve the issue.

Anyone seen this creep up before? I am unaware of any changes to the machine's security in the last few weeks but something has obviously changed.

I can ping the remote servers where the DB's are stored.
I am using Windows Integrated Authentication.
I have a dev box with a similar configuration, except everything is hosted locally, and it runs fine.

Any ideas?

Thanks.

View 13 Replies View Related

Unable To Connect To The Remote Server

Apr 7, 2007

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2050.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__04_07_2007_10_54_49.log</Path>
<SystemName>PC24HOURS</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!4/7/2007-10:54:49:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!4/7/2007-10:54:58:: e ERROR: Unable to connect to the remote server
w3wp!ui!1!4/7/2007-10:54:58:: 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.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!4/7/2007-10:54:59:: 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)


-------------------------------------------------------------------------------------------------------------------------------------------------



<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2050.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__04_07_2007_10_41_11.log</Path>
<SystemName>PC24HOURS</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!4/7/2007-10:41:12:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!4/7/2007-10:41:35:: e ERROR: Unable to connect to the remote server
w3wp!ui!1!4/7/2007-10:41:35:: 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.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!4/7/2007-10:41:37:: 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)
w3wp!ui!1!4/7/2007-10:41:45:: e ERROR: Unable to connect to the remote server
w3wp!ui!1!4/7/2007-10:41:45:: 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.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!4/7/2007-10:41:46:: 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)
w3wp!ui!1!4/7/2007-10:53:55:: e ERROR: Unable to connect to the remote server
w3wp!ui!1!4/7/2007-10:53:55:: 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.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!4/7/2007-10:53:56:: 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)
w3wp!ui!5!4/7/2007-10:54:01:: e ERROR: Unable to connect to the remote server
w3wp!ui!5!4/7/2007-10:54:01:: 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.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!5!4/7/2007-10:54:02:: 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)

View 3 Replies View Related

Configure Report Server From Reporting Service Configuration Manager

Jan 25, 2008

When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace

What is the problem and how to solve it.

View 1 Replies View Related

Unable To Connect To Remote Server - On Localhost...

Mar 30, 2007

Hi!



When trying to log into Reporting Services in SQL Server 2005 Management Studio, I receive the following error message:



TITEL: Verbindung mit Server herstellen
------------------------------

Es kann keine Verbindung mit 'RD2MWD000349' hergestellt werden.

------------------------------
ZUSĂ„TZLICHE INFORMATIONEN:

Unable to connect to the remote server (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------

No connection could be made because the target machine actively refused it (System)

------------------------------
SCHALTFLĂ„CHEN:

OK
------------------------------


Has anybody had that problem before? Happens right after installation, no customisation of the SQL Server has been done yet. And I run the server on localhost.......

View 3 Replies View Related

Unable To Connect To Remote Webhost Server

Jun 12, 2007

I've recently got a new webhosting account with hostinguk who have do the following:


We have created a SQL 2005 database for you named: DBCOX10289
and a system DSN named: DBCOX10289
To access your database you will need Microsoft SQL Server Management Studio / Express
If you do not have a copy of this you can download Microsoft SQL Server management Studio Express at the following location:
http://msdn.microsoft.com/vstudio/express/sql/default.aspx
In enterprise manager you should register the server: sql5.hostinguk.net
You will need to use the following login name and password when registering the server and accessing your database.
SQL 2005 username: COX10289
SQL 2005 password: password
To use this server within your web site code please ensure that you refer to the server as sql5.hostinguk.net
PLEASE NOTE: Do NOT use the IP address of this server directly as this will cause problems for you should we make network changes at any point in time.



I have tried and am in despair but still am unable to connect to the server. Running a XP machine In Administrative tools ODBC I have created a DSN called DBCOX10289 with the server name sql.hostinguk.net. upon completing the ODBC setup I get this:

Microsoft SQL Native Client Version 09.00.3042

Data Source Name: DBCOX10289
Data Source Description: Keystages
Server: sql5.hostinguk.net
Use Integrated Security: No
Database: (Default)
Language: (Default)
Data Encryption: No
Trust Server Certificate: No
Multiple Active Result Sets(MARS): No
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes



I then click on test connection and get



Microsoft SQL Native Client Version 09.00.3042

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
Disconnecting from server

TESTS COMPLETED SUCCESSFULLY!



Whne I'm scrolling through the options in ODBC it can see all the other databases on the server.



When I then try register the server in SQL server management studio express



Servername: sql5.hostinguk.net

Authentication: SQL Server Authentication

Username: COX10289

Password : password



===================================

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

===================================

Login failed for user 'COX10289'. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
Server Name: sql5.hostinguk.net
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536


------------------------------



I try this servername as well: sql5.hostinguk.netDBCOX10289 and still get



===================================

Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

===================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)



I can ping the servername and get the IP address

I can telnet the server and port 1433 and connect successfully

The hosting company do not support sql 2005 express



I have tried researching this as much as possible, all to no avail. What can

I do?





View 5 Replies View Related

SSIS - Unable To Connect To The Remote Server

Mar 14, 2007

Hi,

I€™m using a Script Component in SSIS to call a Web Service. The web service is wrapped, using the wsdl tool. The package works, on my local enviroment. Script component calls the web service and returns the data. I€™ll move the web service to another server, web service as Anonymous access is enable. Deployed the Package on a SQL server. But, when excuting the package I get the below error. I can view and invoke the web method and see data even. SSIS is running under a NT AUTHORITYNetworkService account. I know that the problem is permission, but how would I resolve the issue.

Error:
OnInformation,SERVER,DOMAINSqlAdmin,MISPackage,{190832FB-4FF1-4ECD-BF53-4A49864089B4},{D7BF27CD-BDF1-418A-ABFE-BA0A24B921FB},3/14/2007 10:59:11 AM,3/14/2007 10:59:11 AM,0,0x,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 ScriptComponent_6386cd9eab6a49e7b1a90f69dcc24beb.Service.GetMISAccounts()
at ScriptComponent_6386cd9eab6a49e7b1a90f69dcc24beb.ScriptMain.CreateNewOutputRows()

Any Help will be appreciated

View 1 Replies View Related

Unable To Remote Connect, SQL Server, Error: 1326

Nov 18, 2006

SQL Express running on Server 2003 SP1, not a domain controller - but prior to installing SQL Express, I did dcpromo promote and then demoted it back to a workgroup server.

Connecting with Vista build 5600, Studio express 9.00.2047 with MDAC 6.00.5600.1638. Server 2003 MDAC is 2.82.1830.

I came across this article on the net:

http://www.developersdex.com/sql/message.asp?p=1867&ID=%3C309C7496-F36B-4398-9C52-322E6CB8DE3B%40microsoft.com%3E

Is my mis-matched versions of MDAC causing me this grief?

Otherwise, I have remote set up for TCP and Named Pipes, I've run sp_configure 'remote admin connections', 1; my login is set to SQL Authentication with everything granted. I've tried running the service as network, local and MachineAdministrator; ports are open per:

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

I wanted to ask before I start replacing the MDAC on either the Vista or Server 2003 machine... If that's the problem, which version(s) do I change? to?

Full error message:

An error has occurred while establishing a connection to the server. While connecting to SQL Server 2005, this failure may be cuased by the fact that under the default settings SQL Server does not allow remote connecitons, (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

Thanks, John



View 7 Replies View Related

Unable To Connect To SQL Server After Service Restart

Oct 19, 2004

Hi

We have been having a problem with on of our servers, applications connecting to it are experiencing poor performance, even though the server is only running at a peak of 50%.

The odd thing is that after a sql service restart we couldnt connect at all on the SQL port. We were only able to re-connect after rebooting the actuall box. Is there anything that can be done about this? Its strting to look like a network related problem instead of SQL

View 5 Replies View Related

HTTP Connection Manager Err:unable To Connect To Remote Server

Jan 23, 2007



Hi all,

i am trying to consume an webservice which under secure layer (HTTPS)

eg: https://test.com/test.asmx

i'm connected thro' a proxy server.

when i use the same url in IE it works fine, but when i connect thro' http connection manager it always throws me a error saying "unable to connect to remote server "

can anyone provide me solution to over come this problem

View 1 Replies View Related

Unable To Connect To Remote Report Server From Windows Forms App

Jan 14, 2008

Hello Everyone,

I have a Report Server setup on my laptop (XP Pro SP2). I have developed a report which I would like to view from a Windows Forms Application (VB.NET) using a ReportViewer. When I try it from the local machine it works correctly, but if I try to connect and preview the same report from my other PC (Vista Home Premium) I am getting the "Unable to connect to the remote server. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because the connected host failed to respond." error.

I have setup the Processing mode to Remote and correctly setup the ReportPath and ReportServerUrl using:

With rptRetEmp
.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote
.ServerReport.ReportServerUrl = New Uri("http://192.168.1.2/CPMReports")
.ServerReport.ReportPath = "/CPM_Reports/Test"
.ServerReport.Refresh()
.RefreshReport()
End With

Where CPMReports is the Report Server virtual directory and CPM_Reports is the folder where the report Test resides.

I do not know if this has anything to do with the fact that Vista Home does not have Report Services enabled or it is just a permissions problem. I have red several posts that describe similiar problems, but I could not find a solution.

Thank you for your help.

Daniel D.

View 1 Replies View Related

Unable To Connect To Analysis Service Using HTTP On A Different Server

May 18, 2007

Hi all,



This one has really stumped me! I set up HTTP to connect to an Analysis Services cube within an ASP .NEt application. On inititial setup it worked well and I was able to connect and view the data in my ASP application.



However, for NO reason that I can see it is now coming up with the following error:







Either a connection cannot be made to the localhost server, or Analysis Services is not running on the computer specified.



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Either a connection cannot be made to the localhost server, or Analysis Services is not running on the computer specified.






I have tried everything I can think of to fix it but can't get it to work. I have even gone through the technet document titled "Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios" but it hasn't helped.



I am using SQL Server (Analysis Services) 2005 and ASP .NET 2.0. The application is developed in VS 2005.



I'm at a loss...can you help?



Cheers in advance!

View 1 Replies View Related

Recovery :: Unable To Connect To Availability Group Listener From Remote Server Without Using FQDN

Jul 21, 2015

Environment: SQL Server 2014 on Windows Server 2012 R2.

We have our availability group configured and working.  However, when we try to connect to the AG listener from a remote server, we have to use the fully qualified domain name (FQDN) to connect.  We'd like to be able to connect just using the host name.  Interestingly, ping actually resolves the IP correctly for either.

View 3 Replies View Related

SQL 2012 :: Reporting Server - Unable To Connect

Jun 22, 2015

I am unable to connect to reporting server , services are running fine .Checked in logs and found

ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

How to resolve this ..

View 8 Replies View Related

Unable To Configure Reporting Services With Vista/IIS7

Jan 10, 2007

I am trying to configure a reporting server on my laptop at work. This laptop is running Vista and IIS 7. When I install reporting services, the option for "Install the default configuration" is disabled (greyed out) during setup. The install is successful, but then when I try to connect in the Reporting Services Configuration Manager, I get an unhandled exception ("A WMI error has occurred an no additional error information is available."). If I continue, this error continues to crop up as I attempt to configure the Report Server. When I attempt to configure the virtual directory, the configuration manager crashes. Then, when I navigate to the reportserver page, I get a page that states:
Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

Any ideas for a solution or workaround would be greatly appreciated.

Thanks,

Dave

View 1 Replies View Related

Unable To Configure Reporting Services To Use SSIS Datasource

May 16, 2008

I've created a SSIS package with a DataReaderDestination and a SSRS report that points to it.

I referenced these links during development and I have everything working as expected locally. **I changed the config files as stated on both my local machine and our server. My config matches the example exactly.

http://msdn.microsoft.com/en-us/library/ms345250.aspx
http://msdn.microsoft.com/en-us/library/ms159215.aspx

When I attempt to deploy my report project to the server I get this error message:
"An attempt has been made to use a data extension 'SSIS' that is not registered for this report server."

In the report manager data source properties page it reads:
"The data processing extension used for this report is not available. It has either been uninstalled, or it is not configured correctly."

In SQL Server Management Studio data source properties page SSIS is not a data source type option.

I've tried restarting both the Reporting Services and Integration Services on the server to no avail.

Any suggests? My problem is I can't get the SSIS to be recognized source on the server.

View 1 Replies View Related

Configure Reporting Service Not To Work With SharePoint

Jan 30, 2008

Hi there, I have a stupid question
When I want to configure reporting service in a computer it needs Windows SharePoint Service. But When I installed and configured it in my own PC it asked for database server location instead. Anybody have any idea about this?

View 1 Replies View Related

Unable To Connect To The Remote MS SQL SMS Express

May 30, 2007

Hello
I am able to connect to the server and most of the time I can't connect.
It is important to be able to connect so I can manage my mdf - database.
To test ... I disable the firework but I still can't connect 90% of the time.
Thank you in advance.
~ Peaches ~ 
 

View 3 Replies View Related

Unable To Connect Remote Connection

Sep 25, 2007

Server Error in '/Dive' Application.


An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 
this is the error message I found when I run my asp.net application and the connection string as follows:
<add key="ConnectionInfo" value="Server=(local);Database=Dive;Trusted_Connection=yes;" />
can someone tell me how to connect and how to specify username and password in Visual Web Developer 2005 Express Edition..........
I'm a little bit new on VWD 2005 I need an assistance on it.

View 4 Replies View Related

Unable To Connect To A Remote Database From Vista

Jan 3, 2008

We have a problem to connect to a specific database on our local network from a specific Vista machine. Several other XP and Vista machines are able to connect to the database without any problem. However, with the two latest Vista machines we received, it is impossible to connect to the database. In Microsoft SQL server Management studio express, we have the error 26 "error locating server/instance specified". We are sure the server name we entered is correct. We suppose the server is correctly configured as we are able to connect from other computers. From the machines that are not able to connect to the database, we can connect without problem to other databases. We also see the server, where the database is, on the network servers list in Microsoft SQL server Management studio. .
The version of the components are:
Microsoft SQL Server Management Studio Express 9.00.3042.00
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 7.0.6000.16575
Microsoft .NET Framework 2.0.50727.312
Operating System 6.0.6000
We verified we have the same version of components on the Vista machine from which the connection is successful.
The network database has the version 8.0.
We are usinng sql server authentification method.
We try to specify the IP address instead of the server name in the connection string. We also tried to specify the port.
We also tried to disable the firewall.
Unfortunatetly, we are not able to connect to this database. Any suggestion ?

View 3 Replies View Related

Unable To Export Sub-report Data In Excel Format In SQL Server 2005 Reporting Service

Dec 20, 2006

Hello,

I am using 'SQL Server 2005 Reporting Service' in my project. I am using sub-reports in many cases. Whenever I export such reports containing sub-reports to 'Excel' format which is the major client requirement in our project, the exported excel file shows 'Subreports within table/matrix cells are ignored.'

Can anybody tell me the solution for this? If not possible in reporting service then is there any other way to get data in excel format?

Thanks.

-Salil



View 1 Replies View Related

How To Connect To Analysis Service Database Through Reporting Service?

Mar 31, 2006

Hello,

In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports.

I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either.

I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source.

As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated.

Thank you very much,

Annie

View 5 Replies View Related

XP Home -LAN Remote Access - Unable To Connect From One Single Computer.

Jan 5, 2007

Hi,

I have Windows XP Home Workgroup LAN.

I am treating one of the XP Home system as 'Server' and installed SQL Express 2005 SP1. Enabled remote connections access.

I have total 4 XP Home systems, out of which one i am treating as Server, from the rest 3 computers, 2 are successfully connected to the Server and able to access SQL Express without any problems. But the 3rd system is unable to communicate with the Server. I disabled all firewalls in this 3rd system but still unable to connect to the server. I am able to ping the server, browse for shared folders on the server. Except SQL Express remote connection, everything else in the network is accessible from this 3rd computer.

Can anyone help me on how to troubleshoot this 3rd computer sql express connection problem to the server.

I don't have any error message to provide here. It just says, unable to connect to sql server, verify username/password etc.

Is there any limitation on SQL Express remote connections ?

View 1 Replies View Related

Replication :: Unable To Connect To Remote Distributor From Publisher Using Administrative Link Password?

Jan 29, 2008

I am not able to connect to Remote Distributor from Publisher using Administrative Link Password. I have configured the Distributor on 1 m/c and Publisher on another m/c. When i use the wizard to configure the publisher using remote distributor. I have also specified the same Admin Password link (distributor_admin) in the distributor m/c.
 
I am getting the following message:
 
TITLE: New Publication Wizard------------------------------
SQL Server could not connect to the Distributor using the specified password.

[URL]

------------------------------ADDITIONAL INFORMATION:

Connection to server [SANMENON] failed.OLE DB provider "SQLNCLI" for linked server "D956CF83-AE2E-4FC5-83DD-BE90D84A3950" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "D956CF83-AE2E-4FC5-83DD-BE90D84A3950" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". (Microsoft SQL Server, Error: 21670)

[URL]

------------------------------BUTTONS:
OK------------------------------

View 12 Replies View Related

Unable To Connect To Reporting Services In Mng S

Apr 24, 2008

All,
While trying to access the Reporting Services in Mng studio.I receive the following error
Cannot Connect To ServerA
Client found response content type of 'text/html; charset=uf-8,but expected 'text/xml'
While trying to access the report on reportmanager.I receive an error."The report server is not responding.Verify that the report server is running and can be accessed from this computer"
Any suggestion?

View 4 Replies View Related

Unable To Connect To Reporting Services

Aug 23, 2007

Hi all,

I am new to reporting services. I have created a report project in SQL Server BIDS. The datasource is SQL Server. I was able to see the preview of the report and could build and deploy the report. But when I try to run the report, it gives me error. So I tried connecting to Reporting Services through SQL Server Management Studio.

There I am unable to connect to the Reporting Services.
I am getting a very long error message. Giving below few lines which made sense to me.

Client found response content type of text/html; charset=utf-8, but expected text/xml.

Parse Error Message : An error occurred loading a configuration file: Access to the path c:Inetpubwwwrootweb.config is denied



I have given full rights to ASPNET, AuthenticatedUsers.

Pl help to resolve this issue.

Thanks,
Tejaswini

View 14 Replies View Related

Unable To Initialize Reporting Service After Installing SP2

Jul 12, 2007

hi, I have problem initialize report server after upgrade to SP2.. It keep saying Could not locate entry i sysdatabases 'myDatabaseName'. while i'm sure my database existing. Here's the log



<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3161.00</Product>
<Locale>en-US</Locale>
<TimeZone>Malay Peninsula Standard Time</TimeZone>
<Path>C:Program Files (x86)Microsoft SQL ServerMSSQL.2Reporting ServicesLogFilesReportServerService__07_12_2007_11_38_15.log</Path>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!12/07/2007-11:38:15:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!12/07/2007-11:38:15:: i INFO: Reporting Services starting SKU: Enterprise
ReportingServicesService!resourceutilities!4!12/07/2007-11:38:15:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!library!8!12/07/2007-11:38:16:: i INFO: Catalog SQL Server Edition = Enterprise
ReportingServicesService!library!8!12/07/2007-11:38:16:: i INFO: Current DB Version C.0.8.40, Instance Version C.0.8.54.
ReportingServicesService!library!8!12/07/2007-11:38:16:: i INFO: Starting upgrade DB version from C.0.8.40 to C.0.8.54.
ReportingServicesService!library!8!12/07/2007-11:38:16:: e ERROR: Exception caught while starting service. Error: System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'CCGM_'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!12/07/2007-11:38:16:: e ERROR: Attempting to start service again...

View 6 Replies View Related

Configure A Server To Allow Remote Connections?

Nov 3, 2007

I already asked this question at the MSDN forums, but I'm asking it here because I got conflicting answers.

I want to configure my server to allow remote connections. For some unknown reason, I'm unable to do this with the Surface Configuration Tool. My understanding is that I can accomplish this using the sp_configure stored procedure. Is this correct? If so, can someone please give me an example of the correct syntax? BTW, I'm running SQL Server 2005 on winxp pro sp2.

Thanks in advance.

View 2 Replies View Related

Help With How To Configure SQL Server 2005 To Allow Remote Connections

Nov 14, 2006

Hi there! I've been trying for several days now to configure SQL Server 2005 to allow remote connections, apparently, with no luck.
I always have this error message: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
I've followed the instructions at this link -> http://support.microsoft.com/?kbid=914277&SD=tech, but I have been having the same problems.
I've already adjusted my firewall settings.
What should I do? 
Please help me...
 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved