SQL Server 2005 Express Native client driver

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?

Thanks
.

Relevant Pages

  • Re: why suddenly need to change option "remote connection" from off to on?
    ... Basically it just means that the client could not find the SQL Server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot connect to sql server 2005 express edition
    ... By default SQL Server 2005 Express does not allow remote connections. ... useFailoverPartner, Boolean& failoverDemandDone, String host, String ...
    (microsoft.public.sqlserver.setup)
  • Re: VB Express cant connect to anything
    ... If you are distributing SQL Server 2005 Express with your software then you ... can fully configure all options to allow remote connections at setup. ...
    (microsoft.public.sqlserver.connect)
  • Re: Login failed for user sa. Error 18452
    ... When connecting to SQL Server 2005, ... not allow remote connections". ... the default installation of SQL 2005 does ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot connect remotely to MSDE2000 database
    ... Thanks a lot - very immpressed - that did the trick - TCP/IP protocol was ... >> connections to the database. ... >> How do i configre SQL server to listen for remote connections? ...
    (microsoft.public.sqlserver.msde)
Loading