Re: SQL Server 2005

Hi,

When you get this error, the reason of it is mostly using a wrong password for your SQL Login. Ensure your password is correct. Users mostly say "I'm sure it's correct!" However when I investigate the SQL Error Log, I see that it says ""Login failed for user '...'. (Microsoft SQL Server, Error: 18456)". So the password is wrong...

--
Ekrem Önsoy



"saw" <swexpress(remove)@hotmail.com> wrote in message news:%23OwFkLSaIHA.4140@xxxxxxxxxxxxxxxxxxxxxxx
Misty:

Using your recommendation, I was sucessful in resolving the prior issue. But now, I am facing this issue,

When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server
Management Studio Express, I get the following error:

Cannot connect to (SERVER NAME) which both are on the same machine, I am
using one machine for everything since it is a lab machine.

Additional Information:
A connection was successfully established with the server, but then an error
occurred during the login process. (provider: Shared Memory Provider,
error: 0 - No process is on the other end of the pipe.) (Microsoft SQL
Server, Error: 223)

This error prevents my application on the same server machine from
connecting to the sql server on the same machine.

Please let me know what I can do to correct the issue.

Your help is greatly appreciated.

"Ross Mistry" <Ross@xxxxxxx> wrote in message news:%23A%23sgZRaIHA.4684@xxxxxxxxxxxxxxxxxxxxxxx
Additonal thoughts, you should be able to connect to SQL Server via SQL Server Management Studio. This will provide you with whether or not SQL Server is operational and if you can connect to the server at least locally. If you cannot connect let me know what error messages you receive in your logs (SQL Server and Event Viewer)




"Ross Mistry" <Ross@xxxxxxx> wrote in message news:...
Comments Below

Ross Mistry

"saw" <swexpress(remove)@hotmail.com> wrote in message news:OjA0xRPaIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I have an application that requires an database to be installed on the same machine as a backend database. I downloaded SQL Server 2005 as well as the SQL SERVER TOOLS 5.

Since the application as well as the sql are on the same machine I am receiving error message as follows:

Not Recommended, however, it is fine provided that you don't run into performance issues.

[SQL Native Client]Shared Memory Provider: No process is on the other end of the Pipe. [SQL Native Client] Communication Link Failure.

At the bottom right side I don't the icon that the SQL Server is running however within the services it is running.

This is a depreciated feature as of SQL Server 2005. If the services are running then you should be in good shape.

No client will be connected to this server as it is purely a lab environment.

Could you also tell me how to test the ODBC as well as how to test SQL Server?

Create an ODBC Connection, select the desired SQL Server, Database, provide credentials (Windows or SQL Mixed) and click Test Connection)

Thank you.








.

Relevant Pages

  • RE: Getting Challenged when using SQL connection on .aspx page
    ... What would happen if i removed integrated security=sspi from the connection ... Just want the login token to be passed, ... Have webpage with following connection in the ... I have account to the database on the SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (microsoft.public.sqlserver.connect)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
Loading