Did you enable remote connection?
From
http://sql.veranoest.net/sql_faq.htm#RemoteConnectionError
Q: "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". How do I solve this?
A: For security reasons, the default installation of SQL 2005 does
not allow remote connections.
You will have to enable remote connections and [optionally] start
the SQL Server Browser service. If there is a firewall between your
client and the SQL server, you will also have to open the
appropriate ports on the firewall.
Detailed information:
914277 - How to configure SQL Server 2005 to allow remote
connections
_________________________________________________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
TS troubleshooting: http://ts.veranoest.net
___ please respond in newsgroup, NOT by private email ___
Post by Jassim RahmaTITLE: Connect to Server
------------------------------
Cannot connect to 192.168.0.1.
------------------------------
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. (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server)
(Microsoft SQL Server, Error: 53)
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtS
rc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------
OK
------------------------------
Post by Jassim RahmaI just received a Dell server for our company with SQL server
2005 installed by the vendor but when i try to connect from my
Login failed for user 'sa'. The user is not asscoitaed with a
trusted SQL Server connection. Error 18452
what is the problem? how can I fix?