Please check virtual IP address assigned to SQL Server is an public IP address. In SQL Server Error log this should state that the SQL Server is listening on the...

Hi Nivedita ,

  Are you able to ping the SQLServer box?

Just try pinging the SQL Server Virtual IP.

Also check whether TCP is enabled for this server?

Check the level of SP.

I found that the above errors were related to case where in SQL Server trying to bring the database online at that time some of the database files

namely *.mdf or...

Please try creating of alias using SQLServer Client Network Utility on the Webserver to the SQLServer. You can create alias either using TCP or Namedpipes.

Refreshing the current activity in turn calls the sp_MSset_current_activity

Lock request time out period exceeded.

Server: Msg 1222, Level 16, State 1,...

I got the same error:

"An Internal read Error has occured on C:\DOCUME~1\SQLADMIN\LOCAL.INS. Unable to load Instructions.

Error 703"

I changed the Temp and Tmp environment variable defined under Mycomputer-> right click-->...

Hi Vidaz,

 Please check the Virtual IP address, by which you are connecting on Query Analyser. If the IP address by which you are attempting to connect to Query Analyser it...

Please Check on Start -->> All Programs-->>Microsoft SQL Server--> Server Network Utility, Where TCP/IP appears on enabled protocols.

Otherwise add it.

Hope this helps..

SQL Server 2000 Frequently Used DBCC Commands

Courtesy : By Joseph Sack

I apologise for my comments...

But still I am waiting for answers to query rather than to my comments.

If you require more input please let me know.

Noel,

This option would work for independent of user. Am I right?

In this case where the SQL Server Registation information would be stored?

Can this information can be edited by anyone?

Try on code similar like this

CREATE TABLE #errors

(errorlog varchar(255), continuationrow int)

INSERT #errors

(errorlog, continuationrow)

EXEC xp_readerrorlog

SELECT errorlog

FROM #errors WHERE errorlog LIKE '%Login failed%'

DROP TABLE #errors

Steve,

What would you like to say by your comments?

It does not make any sense for me.

Colin

It is better you avoid generic reply, if you can't give direct answer.