Re: SQL Server 2005 Express Native client driver

Hello mjn,

Am trying to connect to a db created in SQL Server 2005 Express by
using the native client drivers but get an error message that
connection fails due to server not allowing remote connections.
Am trying this by using Powerdesigner 11.
I can connect using the Management Studio Express client and use NT
authentication
Have never used SQL Server so if anyone
could provide some insight in how to connect would be good.
Or how do I allow remote connections?

If this instance is on a remote box, you'll need to launch the SQL Server Configuration Manager and enable listening on your desired protocol and network port (as used). You may also need to create an exception on that host's firewall (if any) that allows connection on said protocol and port.

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/


.

Relevant Pages

  • Re: administering new installation of MS SQL Server 2005
    ... By default SQL 2005 express doesnt allow remote connections to it. ... You can do that through SQL Server ... be able to access remotely are the Workgroup edition and the developer ...
    (microsoft.public.sqlserver.setup)
  • Re: Error while connecting to SQL 2005 from ASP.Net 2.0
    ... When connecting to SQL Server ... Server does not allow remote connections. ... ASP.NET webservice to the SQL Server 2005 box. ... If so, as the error message indicate, the SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ms sql server 2005 not seen in server explorer - cant see any SQL Servers
    ... exact same problem, and tried that, and much to my surprise, it ... and clicked on Remote Connections ... under my database/DatabaseEngine. ... default server settings doesn't allow remote connections'. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MOSS and move SQL database
    ... I am running the command on the local server. ... I did the procedure to allow remote connections anyway just to try it, but I get the same error message. ... SQL Server 2005 Express Edition and SQL ... Server and to the SQL Server Browser service. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RWW Accessing desktops...
    ... >> and I should be able to, as well, connect to his server ... >> Remote connections might not be enabled or the computer ... >> Domain Admins, Mobile Users and Remote Web Workplace ...
    (microsoft.public.windows.server.sbs)
Loading