|
Home > Archive > MS SQL Server > October 2006 > Still Cannot Login sa
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Still Cannot Login sa
|
|
| Charles A. Lackman 2006-10-24, 6:38 pm |
| Hello,
I installed SQL Express using the following Silent Install:
SQLEXPR.EXE /qb SECURITYMODE=SQL SAPWD=MyPassword ADDLOCAL=ALL
INSTANCENAME=SQLExpr
ess DISABLENETWORKPROTOC
OLS= 0 SQLAUTOSTART=1
I cannot login using SQLCMD - E or -U sa -P MyPassword or with
MyComputer\SQLExpres
s
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
| |
| John Bell 2006-10-24, 6:38 pm |
| 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
[url]http://msdn2.microsoft.com/en-us/library/ms345154. aspx#sseover_topic6[
/url]
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=SQLExpr
ess DISABLENETWORKPROTOC
OLS= 0 SQLAUTOSTART=1
>
> I cannot login using SQLCMD - E or -U sa -P MyPassword or with
> MyComputer\SQLExpres
s
>
> 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 2006-10-24, 6:38 pm |
| Hello,
I am trying to connect locally.
Chuck
"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:5BA98536-A8CE-4CF4-B489- E650B89E8A62@microso
ft.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
[url]http://msdn2.microsoft.com/en-us/library/ms345154. aspx#sseover_topic6[
/url]
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=SQLExpr
ess DISABLENETWORKPROTOC
OLS= 0 SQLAUTOSTART=1
>
> I cannot login using SQLCMD - E or -U sa -P MyPassword or with
> MyComputer\SQLExpres
s
>
> 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
>
>
>
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi
Does a NET START command show that it is running? What do the logs say?
John
"Charles A. Lackman" wrote:
> Hello,
>
> I am trying to connect locally.
>
> Chuck
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:5BA98536-A8CE-4CF4-B489- E650B89E8A62@microso
ft.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
> [url]http://msdn2.microsoft.com/en-us/library/ms345154. aspx#sseover_topic6[
/url]
>
> John
>
> "Charles A. Lackman" wrote:
>
>
>
>
| |
| Andrea Montanari 2006-10-24, 6:38 pm |
| hi Charles,
Charles A. Lackman wrote:
> Hello,
>
> I installed SQL Express using the following Silent Install:
>
> SQLEXPR.EXE /qb SECURITYMODE=SQL SAPWD=MyPassword ADDLOCAL=ALL
> INSTANCENAME=SQLExpr
ess DISABLENETWORKPROTOC
OLS= 0 SQLAUTOSTART=1
>
> I cannot login using SQLCMD - E or -U sa -P MyPassword or with
> MyComputer\SQLExpres
s
>
did you (correctly) provide the server name like
c:\>sqlcmd.exe -E -S(Local)\SQLExpress
?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
--------- remove DMO to reply
|
|
|
|
|