Re: Error 10061, SQL Server 2005 DEV actively refuses connection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Worked. Thank you. New to 2005.

On Tue, 17 Apr 2007 11:45:22 -0600, Sue Hoegemeier
<Sue_H@xxxxxxxxxxxxx> wrote:

First is to open up the Surface Area Configuration tool, select to
view Services and Connections. Under Database Engine, go to Remote
Connections. Change it to allow remote connections using whichever
protocols you plan on using from remote clients.

-Sue

On Tue, 17 Apr 2007 12:50:23 GMT, algernon bonzo <bonzo@xxxxxxxxxx>
wrote:

I just installed a fresh SQL Server 2005 MSDN and tried to use the
management console, but all attempts to logon fail.
Message says 'failure may be caused by the fact that under the default
settings SQL Server does not allow remote connections.'

How can I change these settings or otherwise get a connection?

Thanks.
.



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: Cannot connect to SQL Server 2005 on XP Professional
    ... sure you have enabled protocols other than shared memory? ... When you enable remote connections in the Surface Area ... >I have an SQL Server 2005 running on an XP Workstation for testing. ...
    (microsoft.public.sqlserver.setup)
  • 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: Unable to successfully setu p and use .Remote Desktop Connection.
    ... PRO and Win98SE OS's with Remote desktop installed ... > the computer might be too busy to accept new accept connections. ... Letters in Passwords must be typed ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Unable to successfully setu p and use .Remote Desktop Connecti
    ... I continue to avoid installing SPII. ... > for remote access. ... > It should be the username and password for the account on the WinXP Pro ... >> the computer might be too busy to accept new accept connections. ...
    (microsoft.public.windowsxp.help_and_support)