yes,You have to sign in on both node as a domain admin.Also services must be start with a domain admin account.The following link may  useful to you

http://weblogs.asp.net/steveschofield/archive/2004/06/09/151588.aspx

The following links are useful in this regard

BOL : Namedpipes Vs Tcp/Ip sockets

http://www.rlisolutions.com/article/96/sql-server-connection-clients

Rafi-

Are u running a small business unit to get around 50-75 systems then it is better for u to try Windows 2003 Small business server Premium edition.Which is a bundle...

U can surely go for VB as the front end if u know it.

DBCC stands for Database Consistency Checker .

Database shrinking: When a database grows on its own it will create free spces. Also re-indexing the table  create free spaces in DB as if you...

try to write a script using  sp_adduser sps

Is this is happening after you restarting the server? may be after restarting the server u should have to manually start SqlserverAgent service sometimes, and this maty prevent running the...

That is right philcart, It is better to use our own preventive and maintenance plan rather than sqlmaint. If no plan is there Sqlmaint is to be used as a better...

First of all it is better don't allow remote access to Data server .I don't know what is specific to u to give remote access to users to eneter server.

You...

use the following sps

sp_who

sp_ monitor

also

slect * from syslogins

to know total no. of users.

on which os your sql server installed?.

To All,

Thank u for all the comments and suggestions.It all are useful and valid...

Rafi-

yes that is vidas i am asking any third party tool to recover deleted data .ldf and .mdf.Can u mention the name of the tool which u had used.Also any...

yes that is vidas i am asking any third party tool to recover deleted data .ldf and .mdf.Can u mention the name of the tool which u had used.Also any...

Pls make it legible what u r searching for.That is what u mean by amend