May 5, 2011 at 1:48 am
Hi,
i m not able to connect remote database server using sql server managemet studio 2008.
its through error like:
client was unable to connect to establish a connection because of an error during connectioninitialiation process before login.possib;e causes include the following:the client tried to connect to an unsupported version of sqlserver;the server was too busy to accept new connection;or there was resource limitaion (insufficient memory or maximum allowed connection)on the server(provide :Name Pipes provider,error:0 -No process os on the other end of pipe)microsft SQL server ,Error :223)
even i m able to connect another remote database system sql server 2000 using same way in our office network.
May 6, 2011 at 8:11 am
What version is the remote server? You're using SSMS 2008 right?
Can you ping the remote server and get a reply?
Check
the credentials you're using are correct,
the server will accept remote connections,
named pipes protocol enabled etc.
the firewall is allowing traffic to / from SQL Server on the remote box.
May 6, 2011 at 8:19 am
Can you connect on the same Server with SSMS ?
SQL Server 2008 or SQL Server 2008 R2,client and server both are ?
If client is SQL Server 2008 and Server is R2 then it will not make a connection just apply the service pack or Cummulative updates of SQL Server 2008 on the client machine for the client SSMS or install a R2 Client
If this not a scenerio then check the port of Server side default port is 1433 and no need to define on the client side when you are connection with SSMS but if default port changed then you have to define on the client side to connect the server with SSMS or any other like SQLCMD etc
If this not a scenerio then check the firewall of the Server or Client as well
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply