.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

SQL Server 2008 R2 stopped accepting remote connections

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server
 

OS:  Microsoft Windows Server 2008 R2 Enterprise x64
SQL Server:  Microsoft SQL Server 2008 R2 Standard x64   [Product Version: 10.50.1600.1, Product Level: RTM]

Last night the SQL server we are using decided at random to stop accepting remote connections.  We could access the database directly from the server, but not remotely.  The services were all up and running, but when we ran NETSTAT -an we found that the SQL server had stopped listening on the configured port (1540).  The app server shows that it stopped at 1:35 in the morning, but we have scoured every log we can find on the SQL server (event logs, SQL server logs, trace logs) and have been unable to locate anything abnormal.  We ended up having to restart the service "SQL Server (InstanceName)" in order to get the SQL server to start listening on the configured port again.

Has anyone experienced this issue before?  How did you locate the root cause?

Thanks for any help!
-Rob




View Complete Post


More Related Resource Links

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

  
Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Remote access to SQL-Server 2008 R2 on Windows Server 2008 denied

  
Hello, after successful installation of SQLServer 2008 R2 and providing my account as a 'sysadmin' I failed to access the server from a management studio of a SQL-Server 2005 release installation. The TCP/IP access is enabled and the server is configured to allow access from remote connections.  The error message reads a follows: ' A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify ... (Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error:2)' Accessing the SQL-Server by the management studio from the local host works fine but trying to acces by command line using the '-E' parameter fails. Is there any additional configuration on the operation system level needed to open a SQL-Server 2008 instance to be selected by other members of  domain groups from the non-local host? Thank you for the answer  

Server 2008 R2 Express accepts only local connections?

  
My question SQL Server 2008 R2 Express accepts only local connections? [closed] was closed unanswered and my account (with the same username/nick vgv8) was banned in 1 min without any warning and notification from all StackExchange sites (StackOverFlow.com, ServerFault.com, SuperUser.com). I could not understand can MS SQL Server 2008 R2 Express  accept remote connections? And what are local connections - in the same subnetwork, AD, workgroup, the same machine? 

Remote Connection to SQL Server 2008

  
Hi everyone,    I'm allowing remote connections, have started the SQL Server Browser, and have the TCP/IP protocol enabled for my server instance, but I still can't connect to my SQL server remotely.   I have my router forwarding to the local IP for it when using port 1433 and it works when I put the router ip with 1433 locally, but it gives me an error when I try this remotely. It throws a timeout error, so it isn't even reaching it.   Any suggestions?

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

  
I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

  
I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " 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.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

PERFMON: Cannot see SQL Server 2008 R2 64 bit instance counters from remote machine

  
Hi, I have 2 machines X and Y. I am using X machine to run perfmon which will remote connect to Y machine and collect the counters for Y machine. I am surprised to see that I am not able to see the counters for SQL Server 2008 R2 64 bit when I remote connect the perfmon on X machine to Y machine. However, when I directly log in to Y machine and open perfmon, I can see the counters for SQL Server 2008 R2 64 bit !! What is not allowing me to see those counters while connecting remotely? I have same adminstrator rights on both machine for my login and use same login details to log into both machines. Both machiens X and Y are in same network and same domain. Any help will be appreciated.

Max connections using WCF on Windows Web Server 2008 R2?

  

Might not be the right forum for this but I give it a shot:

We're investigating which Windows Server version might suit our needs. Now, all communication with the server will be over WCF services and we need to support around 150 different clients and possibly up to 2000 in the future.

Does anyone know if Windows Web Server 2008 R2 might be suitable for this or is there a limitation in the operating system how many clients that can be connected to the WCF services? If it matters the services runs PerCall instance context mode and Multiple in Concurrency mode.

Thanks for help!


Setup Remote IIS server for Visual studio 2008

  

I tried to setup the remote web server (IIS6.0) for visual studio 2008 . I get the following error. Can you please somebody help me?

Thank you in advance.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.IO.FileNotFoundException: Could not load file or assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Assembly Load Trace: The following information can be helpful to determine why t

what the configuartion to Enable Remote Connection on SQL Server 2008

  

I have  server and I install windows server2003 With sqlserver 2008

and I have Application with vb.net2008  and i want to make connection between the application and sql server 2008

wht Is steps to make them>>>>??


(XP Professional sp3) Cannot connect vs 2008 professional edition to remote sql server 2008 on hosti

  

Hi,

I can  successfully connect Sql Server Management Studio 2008 express with remote sql server 2008 on hosting machine but when I try to add connection in vs 2008 professional edition by following the same procedure which i did in ssms to connect with remote sql 2008 I cannot connect, no dialog box appear in select a database list is empty but when i click test connection it says connection successful. However vs 2008 is  connected sucessfully on local sql 2008 express.

I would appreciate if some one could give useful suggestion.



how to enable remote Connection sql server 2008

  

Hi

I've just installed sql server 2008 on a vista server, unfortunately I forgot to enable remote connection when I was installing it. As I need this feature really I tried to enable I but "Surface Area Configuration" of sql 2005 seems to be vanished in this new version. Despite  I searched like 2 hours, I couldn't find any useful solution,  interestingly all the results are either nonsense or related to 2005 version.

Please me what the hell should I do and I believe many people will use your answer!

Thank you in advance


Max connections with SQL Server 2008

  

Hi all,

      I want to know how many connections can I open with a single sql server 2008 std edition and sql server 2008 express edition?

 

 

Nilkanth Desai

 


How to check for file exists on remote server in ssrs 2008?

  
I have a report that needs to display images that are stored on a remote web server. The problem is that I also need to check if the file exists first otherwise I get those annoying image not found red X's.

I tried entering the code at the bottom in the custom code section of the report which works if I run it on my local machine however it doesn't work in SSRS 2008. After doing a little trial and error I found it seems to be failing on the first line in the function,

Dim request = System.Net.WebRequest.Create(New Uri (fileURL))

Is there some specific permissions or configuration change needed on the SSRS2008 server for this code to work? Or is there a better way to do this?

Thanks,
Robert


Public Function CheckRemoteURL(ByVal fileURL As String) As String
Dim request = System.Net.WebRequest.Create(New Uri (fileURL))
request.Method = "HEAD"

Dim returnURL = ""

Try
Dim response = request.GetResponse()
returnURL = fileURL
Catch ex As Exception
returnURL =""
End Try

Return returnURL
End Function

How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.

  

how to write SMO's conn.ConnectionString with IP address and port?


Sql Server 2008 logs Authentication mode incorrectly avoids remote login

  

Im trying to connect SQL server 2008 Express R2 installed on XP sp3 pc through ODBC SQL Server driver with a Windows 7 PC. I managed to define static IP ports and setup firewall. Now the ODBC connection successfully gets created by accepting uid : sa and my password given.

Now Im getting "login failed for user ". " msg from my application. When I run the same application with same ODBC connection created in the SQL server PC it works fine. The two pcs operate in a workgroup.

Following  is the error log. Im surprised to note that the server logs its in Mixed mode initially and later makes a cry that its in Windows Authentication mode. !!!!

010-07-25 15:19:53.76 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
    Apr  2 2010 15:53:02
    Copyright (c) Microsoft Corporation
    Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3, v.3311)

2010-07-25 15:19:53.76 Server      (c) Microsoft Corporation.
2010-07-25 15:19:53.76 Server      All rights reserved.
2010-07-25 15:19:53.76 Server      Server process ID is 3552.
2010-07-25 15:19:53.76 Server      Auth

SQL Server 2008 R2 Setup has stopped working

  

Hi, I have a server with Windows Server 2008 R2 Standard Edition English and when I try to install SQL Server 2008 R2 Standard Spanish the installer give to me:

"SQL Server 2008 R2 Setup has stopped working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."

Previously I changed the Current Format in Regional and Language Options to Spanish to solve a problem with OS Local. The mentioned error appears during the step of install the Setup Support Files, the step stop and show me the error with a "Close program" button, after press the button the installation finish. Thanks in advance.

DELL PowerEdge T710
2 Intel Xeon CPU E5502 1.87GHz
32 GB RAM

Windows Server 2008 R2 Standard 64bit ENU (english)
SQL Server 2008 R2 Standard 64bit ESN (spanish)


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend