"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:5BA98536-A8CE-4CF4-B489-E650B89E8A62@microsoft.com...

"Charles A. Lackman" wrote:

> Hello,
>
> I installed SQL Express using the following Silent Install:
>
> SQLEXPR.EXE /qb SECURITYMODE=SQL SAPWD=MyPassword ADDLOCAL=ALL
> INSTANCENAME=SQLExpress DISABLENETWORKPROTOCOLS= 0 SQLAUTOSTART=1
>
> I cannot login using SQLCMD - E or -U sa -P MyPassword or with
> MyComputer\SQLExpress
>
> Using ADO doesn't work either. All gives me the same error.
>
> Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while
> establishing a connection to the 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.
>
> Please Help,
> Thanks,
> Chuck
>
>
>

"Charles A. Lackman" wrote:

> Hello,
>
> I am trying to connect locally.
>
> Chuck
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:5BA98536-A8CE-4CF4-B489-E650B89E8A62@microsoft.com...
> Hi Charles
>
> You don't say if this is trying to connect locally or remotely? Have you
> checked the installation log files?
> http://msdn2.microsoft.com/en-us/library/ms144287.aspx
> The may also help
> http://msdn2.microsoft.com/en-us/library/ms345154.aspx#sseover_topic6
>
> John
>
> "Charles A. Lackman" wrote:
>
> > Hello,
> >
> > I installed SQL Express using the following Silent Install:
> >
> > SQLEXPR.EXE /qb SECURITYMODE=SQL SAPWD=MyPassword ADDLOCAL=ALL
> > INSTANCENAME=SQLExpress DISABLENETWORKPROTOCOLS= 0 SQLAUTOSTART=1
> >
> > I cannot login using SQLCMD - E or -U sa -P MyPassword or with
> > MyComputer\SQLExpress
> >
> > Using ADO doesn't work either. All gives me the same error.
> >
> > Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while
> > establishing a connection to the 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.
> >
> > Please Help,
> > Thanks,
> > Chuck
> >
> >
> >
>
>