Re: unable to connect to sql server remotely

It is possible the port has changed and the remote connections are either using a fixed value or the value is cached and is now wrong. The local session is most likely using shared memory so it can connect.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Matt" <Matt@xxxxxxxxxxxxxxxxxxxx> wrote in message news:eQt2K8eMIHA.6060@xxxxxxxxxxxxxxxxxxxxxxx
Its a named instance
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message news:O9SF2eeMIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
Did you change the tcpip address or the port sql server is using? Is it a default or named instance?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Matt" <Matt@xxxxxxxxxxxxxxxxxxxx> wrote in message news:uoLB5gdMIHA.4912@xxxxxxxxxxxxxxxxxxxxxxx
Here is my issue. I installed SQL 2005 on one of my servers. Up until 10 minutes ago I was able to connect to the server remotely using SQL Server Management Studio but I was unable connect to the SQL server from the actual server that the SQL 05 instance resides on. Now, I restarted the SQL Server, and DB engine service and now I can connect to the SQL database from the actual server but not remotely. I have it configured to allow remote connections and have it setup to use TCP/IP or Named Pipes and still nothing. I've restarted the db engine service and all of the other SQL services and I still can't connect to it remotely.


Any suggestions on what could be causing this? I get this error when I try to connect remotely:

'An error has occurred while establishing a connection to the server. When connecting SQL Server 2005, this failure may be caused by the fact that under the default settign SQL does not allow remote connections....'

Now I also got that same error message when I logged onto the actual server that the SQL 2005 instance resides. I did fix that and now I'm able to log in to SQL SMS from the actual server but not remotely.

Relevant Pages

  • Re: Rmote Access problem
    ... The client could not connect to the remote computer. ... Remote connections ... Re-running CEICW on SBS server: ...
    (microsoft.public.windows.server.sbs)
  • Re: /remote desktop control suddenly broken - critical
    ... The client computer may not be turned on. ... Remote Desktop connections may not be enabled on the client ... Verify that Remote Desktop is enabled on the computer you are ... connection from another computer on the Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Rmote Access problem
    ... And after you select the task to connect to the server desktop it just stops ... The client could not connect to the remote computer. ... Remote connections ... the network is working. ...
    (microsoft.public.windows.server.sbs)
  • SQL 2005 Express Connection Problem
    ... The remote site is not a company ... this remote site and try to log in I get this 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 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote Access to the SBS 2003 Server
    ... If you're having problems accessing the newsgroups or finding the right ... The Microsoft public news server is msnews.microsoft.com and you can ... VBScript: Remote Desktop Disconnected ... connections might not be enabled or the computer might be too busy to ...
    (microsoft.public.windows.server.general)