Hello,
I want to connect to the remote SQL server form my comupet using SQL server Enterprize manager. How cna i do that?
I realli appreciate your help.
Many Thanks.
Nitesha
Hello all,
An ASP.NET website hosting service allows the use of Enterprize Manager to manage the backend database of a hosted asp.net website. This is not done across a VPN and I don't think it could be done on SSL so the question is : How Secure is that? would this be ok for learning but not Ecommerce? Or is it an encrypted session and I paranoid?
-Thanks
Heywade
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
Here is what I knew: usr/pwd, Domain, Server and Database.
How to set Enterprise Manager, then can I connect to DB ?
Can I connect to remote SQL 2005 server through SQL Server Management Studio Express? I always get a error code 18456 when I try to connect to SQL 2005 server through SQL Server Management Studio Express. I'm sure I enter correct username and password!
View 3 Replies View RelatedHi,I've an account with a hosting service provider online for SQL Server database. I've downloaded SQL Server 2005 Express from ASP.Net. How can I use it to connect to my SQL Server Database which is sitting on remote server? The hosting provider gave me following things to connect to the remote database.Server NameDatabase NameUser NamePasswordRegards,A.K.R
View 2 Replies View RelatedI want to connect to company's SQL Server from home and to connect to home's SQL server from company remotely.
The new released SQL Server Web Data Administrator by Microsoft seems solving my issue.
I use it to connect to different SQL servers in different domains company wide successfully, but I failed to connect to home from company( I have static IP on the home server).
Also I want to know how to configure the sever name if I want to connect to company's SQL Server from home. The company SQL server is inside the firewall with a internal IP. How it works?
Any ideas?
Thanks!
Please Help Me to do this...
Consider i hv already logged in
sql server 2005
ip no : 192.168.2.20
db name: framework
from this query window is it possible to access the objects(tables,stored porc's)
of another server's database
for example ,
sql server 2005
ip no : 192.168.2.21
db name: framework1
...................................................
Im able to access the same server's db objects
consider im frame work db
declare @qry as nvarchar(max)
set @qry= '
use [master]
select * from [Sales]
'
exec (@qry)
... but when i use use statement like,(its not working)
use 192.168.2.21
use [master]
Please help me out .....
I’m going nuts and need some help with my ASP.NET 2.0 application which has trouble talking to a remote SQL Server 2000. First, before I describe my problem let me say that everything works perfectly on my XP development workstation when I point to the local SQL Server database. Screens load fine, saves and edits all work perfectly. Problem is when I connecting to SQL Server on a remote windows 2003 server I get Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Now, I’ve researched this error and have successfully made the following changes to the remote windows 2003 server where the database resides:1) Added logins for “ASPNET”, “NT AUTHORITYNETWORK SERVICE”, and “IIS_WPG”. The reason I added NT AUTHORITY is because we plan on deploying this web site to the same windows 2003 server and I understand that IIS6 (on this server) has ASP.NET running as NT AUTHORITY acct. 2) For all the logins above I’ve added them as users to the database and given dbo role. I still get same login for user null error when attempting to connect from my XP workstation. Can anyone help?
View 7 Replies View RelatedI recently reinstalled SQL Server 2005 on a new computer, and now I can't connect to remote SQL servers for some reason.
When trying to access the remote server with SQL Management Studio or DTS I get the following error:
-----------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) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476-----------
I'm certain the servers I'm trying to connect to allow remote connections so the fault must be on my side. Does anyone have any idea what the cause and solution might be?
How can I connect to a online SQL Server with Enterprise Manager?
View 3 Replies View RelatedHi Folks I have faced a problem during my application development... The application which is manipulating data in SQL sever 2005 which resides on server Named [Mserver1]... Now in the local netwrok there are 10 Client Pcs... My application will be running on all of them... What connection string will i use for that.. Client Pcs have not got SQL on them... I am using visual studio 2005, SQL server 2005.
Any help ??
Thanks in advance
Hi, I have Windows XP Pro OS with SP2 and SQL Server 2005 installed.
I want to give Windows Authentication to my colleague sitting next to me, we are into same LAN. Is it possible to give access to my friend and if so can I create a seperate Security Group and add multiple users to them and give access.
-Senthil
From Enterprise Manager on my PC, how do I connect to a remote server overthe internet - I have the IP address, User Name and Password.Thanks
View 2 Replies View RelatedHi All,
I have created my sql database script using SQL data publishing wizard, now i want to execute the same on my shared hosting database. But i am not getting any option to connect to remote server in SSMSE.
I have developed web based application with back hand as SQL Server 2005, so now i want to execute my script file onto the server. so how i will connect with my server using SSMSE ?
My application is located under www.briskonsales.com/sales
Any idea ?
Thanks,
Jay
I am unable to connect to a remote instance of SQL Server to which I have full permissions. Names Pipes are enabled and started. All services appear to be running. The server uses windows authentication and has the domain admin account referenced.
The follwoing is the response on attempting to connect:
An error has occurred while establishing an error to the server. "....this failure may be caused by the fact that under default settings of SQL Server does not allow remote connections. (provider: Named Pipes provider: error 40. could not open a connection to SQL Server IMS SQL Server error 53)"
Any help is apprecaited
I wnat to connect to remote sql server 2005, I do the following steps:
Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
sp_addlogin 'Wind','ack@123','db'
but still can't login,tips as follwing:
Login failed for user 'Wind',The user is not associated with a trusted SQL Server connection.
Error:18452
Why? Must use "SQL Server Authentication" connect?
hi,
View 6 Replies View RelatedI have 2 Window 2000 servers. A server is a Web server (IIS 5.0). B server is a MS SQL 2000 database server.
I use the following connection string to connect successfully the B DB server from the A server.
....
cnstr = "Provider=SQLOLEDB;Persist Security Info=False;UID=xxxx;PWD=xxxx;Data Source=xxx.xxx.xxx.xxx;Initial Catalog=DDDDD;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open cnstr
......
But, I change the connection string to the following (it just only be added "Network=DBMSSOCN;", it is connecting with TCP/IP). It is failed !
....
cnstr = "Provider=SQLOLEDB;Persist Security Info=False;UID=xxxx;PWD=xxxx;Data Source=xxx.xxx.xxx.xxx;Initial Catalog=DDDDD;Network=DBMSSOCN;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open cnstr
......
The error message is :
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).] General network error.Check your network document
/TCPIP_Test.asp, line 14
Then, I use the same connection string (TCP/IP) to connect successfully the B DB server from an other C web server.
Other test on the A server :
1. ping -a <B server> : test OK !
2. telnet <B server> 1433 : test OK !
3. osql -U<xxxx> -S<B server> : test OK !
4. run VB6 apps with the TCP connection string : test OK !
What is problem in my A web server ?
This is the error: "Unable to open database. Data source name not found and no default driver specified". But there's a catch! Read on...
Our application was written using MFC (ODBC CDatabase class) and the Open function takes a connection string like this:
"Driver={SQL Native Client};Server=%s\INSTANCE;Database=dbname;Uid=loginname;Pwd=password"
The %s in the connection string is either set to "localhost" or in the case of a client/server setup, the user chooses a host from a list the first time they run the application, so it becomes "SOMECOMPUTERNAME".
Here's the catch: the application can connect to the remote server if SQL Server is installed on the client machine. When we install our application on a clean, freshly installed XP machine, we get the error.
However the ODBC Data Source Administration tool recognizes SQL Server and I can successfully create a DSN to our remote SQL Server using it.
What does installing SQL Server do to allow the connection string to work and what do I need to do to NOT install SQL Server on our client machines?
Can anyone tell me how Enterprise Manager connects to SQL Server? Does the Client Network Utility affect it? I can ping the servers with SQL on them, but I get timeouts and 'Connection Broken' in EM. Query Analyzer works sometimes and sometimes doesn't.
View 3 Replies View RelatedI have a SQL Server 2005 instance which resides on a dedicated server hosted by a third party. I am able to connect to this server through my local SQL Management Studio, however, my local ASP.NET 2.0 web application cannot connect. I get the error below. The connection string I use is formatted as...
Connection String:
Server=thesever;uid=myuserid;pwd=mypassword;database=mydatabase
Error:
Failed to connect to database: 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)
The hosting providr claims that the SQL Server configuration settings are as they should be as fars as TCP/IP and Named Pipes are concerned. Does anyone know what might be going on?
Hi all,
I am using SQL 2005 Express to store my databae on a remote server, I already set remote connections to Local and remote connections (Use TCP/IP only) and also allow it to listen all the ports. Also I disabled my firewall. Then In my web.config file I add the conncting string like below
<add name="ConnString" connectionString=" Server=123.xxx.xxx.xxxDEV11SQLEXPRESS; Database=xxx; User ID=tester; Password=test; Trusted_Connection=False" providerName="System.Data.SqlClient"/>
Then I got the following error
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)
Any ideas? Thanks in advance.
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?
Hi
What connection string should i use to connect to a remote SQL2000 server over the internet??
Thanks
I've read all of the related questions and none answer my situation. I am using Visual Studio 2005. I have not been able to connect to the remote SQL database at all. I have attempted to write a SMO to make the connection however, the info I have been able to get to on MSDN didn€™t have enough information to carry me through.
Here is the code I found it on MSDN and have been attempting to use.
Module Module1
Sub Main()
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
'Declare a ServerConnection object variable to specify SQL authentication, login and password.
Dim conn As New ServerConnection
conn.LoginSecure = False
conn.Login = xxxx
conn.Password = xxxxx
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server(conn)
'The actual connection is made when a property is retrieved.
Console.WriteLine(srv.Information.Version)
'The connection is automatically disconnected when the Server variable goes out of scope.
End Sub
End Module
The code executes however, nothing happens. I don€™t know where the IP address comes into play. Thanks in advance.
· SQL Server 2005 Standard
· TCPIP
· Server not starting (I€™m able to connect using SQL Server Management Studio
· I don€™t know whether SQL Browser is enabled enabled. I use the IP address when using SQL Server Management Studio
· I€™m not sure however, I believe it runs under Network Service with the Host provider
· I have not made a firewall exception
· Windows XPSP2
· Running Norton AntiVirus 2007
Thanks for any help or advice.
THANK YOU so much for your help.
ENVIRONMENT: Microsoft, IIS 7.0 & PHP 5 on 2003 Server No.1 & SQL 2000 on 2003 Server No.2
I AM able to connect using the below syntax just fine:
$connection_string = 'DRIVER={SQL Server};SERVER=FQDN_NAMEOFSQLSRV;DATABASE=MYDBNAME';
$user = 'MYNAME';
$pass = 'MYPASWRD';
$connection = odbc_connect( $connection_string, $user, $pass )
In other words, built in built in ODBC works fine.
PROBLEM STATEMENT: I am unable to connect using the sqlsrv extension.
I verified with phpinfo that sqlsrv extension (using sqlsrv_ts.dll) is loading fine, but the below syntax does NOT work
$serverName = "(FQDN_NAMEOFSQLSRV)";
$conn = array( "Database"=>"MYDBNAME", "UID"=>"MYNAME", "PWD"=>"MYPASWRD");
$conn = sqlsrv_connect( $serverName, $conn)
I have version 8.00.194 of ntwdblib.dll in sys32 dir and in c:php and IUSR has full control over it.
At this point, I'm not worried about security, so much as getting this thing to work. I can tighten down later if need be. So I also gave IUSR read/write over the sql server subkey in the registry odbc hive
My problem is that the customer in this case wants to use the sqlsrv extension and associated functions, not the built-in ODBC and not DSN.
I do not have the SQL client connectivity tools installed on this IIS server even though the SQL server is remote. I'd prefer to avoid that if possible.
Thanks again :-)
~p
I have an application developed by VB.NET 2005, and I need to install the Data base on a server to allow the clients access the data base from thier own computers, i need to allow all the functions on that data base (Insert, Update, and Delete).
I tried to do it by installing the SQL Server on a computer named (PC1) and the application on a computer named (PC2), and they are connected to the same subnet, I need to know what are the properties that I should do on the SQL Server in order to be visible through PC1 to make the connection string? And does the authintication mode affect the process?? whether it is Windows authintication or SQL Server Authintication??
Note: I am using SQL Server 2005 Developer Edition.
Thanking you in advance..
Mak
Hi,
How do I connect to a remote Analysis Server using SQL management studio on my local machine.
Thanks in advance..
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.
I originally posted this issue on the SSIS forum and it was suggested I cross post here. I'm trying to connect to the MSDB database on a remote SSIS server using the integration services connection listed in the drop down box on SQL Server 2005 Management Studio. Every connection attempt ends with an 'Access Is Denied' error message. I have full db_dtsadmin rights on the remote server. We followed the MSDN whitepaper on connecting to a remote SSIS server (the section on eliminating the Access Is Denied error - configuring rights for remote users). Nothing works, I always get the generic access denied error message. Are there other permissions that need to be assigned in conjunction with db_dtsadmin to get this to work? I wonder if there is something simple we're overlooking.
Thanks.
I have a VB.net app that connects to a remote SQL server via TCP/IP. Most folks can connect just fine. However some enterprise users are in a corporate environment that will only allow connections through a corporate proxy server.
The VB app does the connect to the remote SQL server via a fully routeable IP address over port 1433, implemented via a series of table adapters.
Having no such experience, I have no idea what I need to do to my app to allow it to connect THROUGH a proxy. And what sort of interaction I will personally need to have (if any) with thier IT department to configure the proxy server in any way. The user mentioned that "Only permissible outbound connection is through proxy server and it is only allowed with TCP/IP port 80 and it is only possible by authenticating with Domain ID and password." I would assume that means the connection from the VB app to the Proxy server is over port 80 and that somehow the proxy server will know (or be told) to then route to IP address of the SQL Server over port 1433.
I realize that one possible solution would be to create a WebService that runs on the same machine as the remote SQL server and have the app connect to that. However that will require a lot of rework on the application. We are looking into doing that, but right now I need a short term fix that does not require such a major rework.
Can anyone offer any insight or links that might point me in the right
direction?
Thanks!
Gary
<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)