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


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

Unable to connect to sql server in network but working fine over VPN

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :Sql Server
 

Hi,

 

I have a sql server 2005 named instance running on windows 2003. I have an issue  in sql connectivity:

When the client system is in the network, client is not able to connect in management studio to the SQL server without specifiying the port number i.e. tcp: abc\xyz. If the client specifies the port number, he is able to connect to it like tcp:abc\xyz,20001.

Now the strange thing is : The same client system when connected over vpn works fine without specifying the port number in the connection string  like tcp: abc\xyz,20001.

then why is it failing to get the port number when the system is in the network?

I verified sql browser service. it is running fine. Firewall is in stopped state. What new components would come into picture over vpn that allow browser to service the port number? It's pretty strange issue and hence looking for any thoughts.

Note: SPN is not registered for the sql service.

-Praveen




View Complete Post


More Related Resource Links

need help about "Unable to connect to remote server." using HttpWebRequest

  


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

Unable to Connect to server

  
I have install sql server 2008 on window 7. But connection to server is failed. These are the options. Sever Type Server Name. Authentication. Login. Pasword. anybody have answer my question????

Unable to connect to the ASP.NET Development Server

  
 I have VS 2008 with SP1 installed on Win XP. I have .NET 3.5 with SP1 installed When I ran and opened an existing project for the first time, I got the below error WebDev.WebServer.exe has encountered a problem and needs to close. After this error, I continusly get  "Unable to connect to the ASP.NET Development Server." whenever I run the website. I checked the internet and ASP.NET forum and tried all the following Making port numbers auto assign Making it to a specific port number using the Custom web server Tried creating new web site and checking Replaced WebDev.WebServer.EXE after downloading it from a website My anti virus have not blocked any websites as such I tried resetting VS settings by running devenv /resetsettings Can any one help me, what else might be the problem? Thanks in advance

Unable to connect to SQL Server 2005 remotly, all client protocols are blank

  
I have an installation of SQL 2005 and had issues connecting remotly. Looking at the client protocolols, they are all blank. I can see that TCPIP, Named Pipes, VIA, etc. are 'enabled', but where the words 'TCPIP', 'Names Pipes', etc. should be, it's just blank. I tried to install SQL 2008R hoping the Client Protocols would be corrected during the installaion, but they were not. I'm assuming the issue with the Client Protocols not showing up is a symptom of the problem. Does anyone have any ideas? Thanks!

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

  
Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

Outlook Unable to connect to MySite's "Social Network"

  
Running into a really odd issue. I have to farms configred pretty much identically, a production farm and a dev farm. For some reason I'm able to set up a social network connection from outlook to my dev farm without any problems but I get "invalid user name or password" when I try and connect tot he production farm. There's no errors showing in the SPLogs or the event viewer. I've checked everything I can think of but knowing me I'm missing something really small.

Crystal Reprort:unable to connect with sql server

  
Hi Guys,               i have a Problem in crystal report which is unable to connect with the hierarchy...can any one give me the solution..i have done this with .xsd nd My code is as Under...Imports SystemImports System.Data.SqlClientImports CrystalDecisions.SharedImports CrystalDecisions.CrystalReports.EngineImports CrystalDecisionsImports CrystalDecisions.ReportSourcePartial Class Default2    Inherits System.Web.UI.Page    'Dim cn As New ConnectionInfo    Dim crtableLogoninfos As New TableLogOnInfos()    Dim crtableLogoninfo As New TableLogOnInfo()    Dim crConnectionInfo As New ConnectionInfo()    Dim CrTables As Tables    Dim CrTable As Table    'Dim TableCounter    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        Dim crReportDocument As New ReportDocument()        crReportDocument.Load("C:\Users\Utpal\Documents\Visual Studio 2008\WebSites\Report 2\CrystalReport.rpt")        With crConnectionInfo            .ServerName = "\SQLEXPRESS"&nb

Unable to connect SQL Server 2008

  
Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

local pipes vs. network pipes (to connect to SQL Server)

  
Choosing a Network Protocol (SQL Server 2008 R2) tells: "It is also important to clarify if you are talking about local pipes or network pipes. If the server application is running locally on the computer that is running an instance of SQL Server, the local Named Pipes protocol is an option. Local named pipes runs in kernel mode and is very fast" Well, it is not me who is talking in cited article, I believe so. Should it be understood that "If the server application is running locally on the computer that is running an instance of SQL Server" and configuring/choosing Named Pipes mean running "local Named Pipes"?

Unable to connect to Visual Studio's Localhost Web Server

  
I've been running Visual Studio 2005 for about three weeks now and everything has worked just fine. Now all of the sudden I'm getting this error "Unable to connect to Visual Studio's Localhost Web Server" Any ideas how I can fix it?

unable to connect to visual studio's localhost web server

  
Hello, I created a simple web page in Microsoft Visual Web Developer 2005 Express Edition.  Then I pressed Ctrl/F5. Build succeeded. Next I reseived an error message "unable to connect to visual studio's localhost web server". Does anybody know why?  

Report builder 3.0 - Unable to connect to server

  
Hi there, We've been using Report Builder 2.0, and its been working pretty nicely. We have the option 'Use this report server or sharepoint site by default' option set to http://<server>/reportserver - and users can connect via the 'Open' dialog, save, etc. However, some of our users have been testing Report Builder 3.0 - and they are unable to connect, even though the URL is set exactly the same.  They have Report Builder 2.0 and 3.0 installed on the same client workstation. With the same settings, 2.0 can connect, but 3.0 can not. The target installation is SSRS is SQL 2008. The error is: Connection failed. Unable to connect to the server that is specified in the URL... Make sure that the server is running, the URL is correct and you have permission to use the server. Does anybody have any ideas? thanks, mark

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

asp menu working fine in the dev environment but not on server

  
Hi guys,        I am sorry to be asking what is probably a really stupid question, but i have a problem with my asp menu, when i run it on my dev machine(thru vs2010) it works perfectly, all the menu's are displayed correctly with the correct child items in the correct order but when i publish it to the server all the menu items become flat and take up the whole page. I am populating the menu using a reentrant function as follows to call the function and add the menus i am using Dim childMenuItems As List(Of MenuItem) = CreateMenuLevel(0, uniquemenulist)childMenuItems.ForEach(Sub(n) NavigationMenu.Items.Add(n)) Public Function CreateMenuLevel(ByVal parentId As Integer, ByVal menulist As List(Of MenuList)) As List(Of MenuItem)        Dim menuItems As New List(Of MenuItem)        For Each menuListItem As MenuList In menulist.Where(Function(n) n.ParentId = parentId)            Dim MenuItem As New MenuItem            If (Not String.IsNullOrEmpty(menuListItem.PagePath)) Then                MenuItem.NavigateUrl = menuListItem.PagePath           

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

  
Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &

Unable to connect to the ASP.Net Development Server

  
I'm getting the error ''Unable to connect to the APS.Net Development Server" in MS Visual Studio 2008

System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketExcept

  

I have a scenario where there is a web service (WS2) which resides behind WSLX authentication. There is another web service (WS1) which is outside of this WSLX authentication. Now we have blackberry application which calls WS1 & send its login credentials which gets passed to WS2 & token is returned back to the blackberry app. For subsequent request the same token is passed in order to ensure that it is the same session. I have seen the similar error as mentioned below earlier in the log but now after migration to SQL 2005 from SQL 2000 this has become more frequent. The error is:

 

System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond     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)    

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