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.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@.manchu.net>
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.|||Worked. Thank you. New to 2005.
On Tue, 17 Apr 2007 11:45:22 -0600, Sue Hoegemeier
<Sue_H@.nomail.please> wrote:
[vbcol=seagreen]
>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@.manchu.net>
>wrote:
>
No comments:
Post a Comment