command line local login to SQL failed

Pardon if this has been asked before. If so, please post the URL.
Could someone please tell me how to fix this login/pipe? Notice the 3rd
login is fine with "/E". It is a SQL2005 Enterprise on Win2003 Server Ent.
C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin>osql /
SMIAMI /U junk
Password:
Login failed for user 'junk'. The user is not associated with a trusted SQL
Server connection.
C:\Program Files\Microsoft SQL Server\90\Tools\Binn> osql /SMIAMI /U junk
Password:
[SQL Native Client]Shared Memory Provider: No process is on the other en
d of
the pipe.
[SQL Native Client]Communication link failure
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>osql /SMIAMI /E
1> use adventureworks
2> go
1> select count (*) from person.address
2> go
19614
(1 row affected)It appears that SQL Server is set for Windows Authentication and that you
are attempting to login using SQL Authentication (Username/Password).
If you must use SQL Authentication, you need to change the authentication
mode of the server.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:2A01AFB3-3447-46CA-B69B-BA527E620F3D@.microsoft.com...
> Pardon if this has been asked before. If so, please post the URL.
> Could someone please tell me how to fix this login/pipe? Notice the 3rd
> login is fine with "/E". It is a SQL2005 Enterprise on Win2003 Server
> Ent.
> C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin>osql /
> SMIAMI /U junk
> Password:
> Login failed for user 'junk'. The user is not associated with a trusted
> SQL
> Server connection.
> C:\Program Files\Microsoft SQL Server\90\Tools\Binn> osql /SMIAMI /U junk
> Password:
> [SQL Native Client]Shared Memory Provider: No process is on the other
end
> of
> the pipe.
> [SQL Native Client]Communication link failure
> C:\Program Files\Microsoft SQL Server\90\Tools\Binn>osql /SMIAMI /E
> 1> use adventureworks
> 2> go
> 1> select count (*) from person.address
> 2> go
> --
> 19614
> (1 row affected)|||Hi,
Go to SQL Server program groups, select SQL Server management studio.After
connecting to SQL Server instance do;
1. Right click above server
2. Select properties
3. Select Security option and click the option button, SQL Server and
Windows authentication
4.click ok and restart SQL Server
After this you wil be able to connect using SQL Authentication.
Thanks
Hari
SQL Server MVP
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:2A01AFB3-3447-46CA-B69B-BA527E620F3D@.microsoft.com...
> Pardon if this has been asked before. If so, please post the URL.
> Could someone please tell me how to fix this login/pipe? Notice the 3rd
> login is fine with "/E". It is a SQL2005 Enterprise on Win2003 Server
> Ent.
> C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin>osql /
> SMIAMI /U junk
> Password:
> Login failed for user 'junk'. The user is not associated with a trusted
> SQL
> Server connection.
> C:\Program Files\Microsoft SQL Server\90\Tools\Binn> osql /SMIAMI /U junk
> Password:
> [SQL Native Client]Shared Memory Provider: No process is on the other
end
> of
> the pipe.
> [SQL Native Client]Communication link failure
> C:\Program Files\Microsoft SQL Server\90\Tools\Binn>osql /SMIAMI /E
> 1> use adventureworks
> 2> go
> 1> select count (*) from person.address
> 2> go
> --
> 19614
> (1 row affected)