Hi issue is when thay try to connect database from front end application

getting error like this :

connection failed please check with database connection settings and network setting

i have...

Hi

Thanks for above responce

still some more clarification please

is there any problem with SQL 2000 server DB in xxxxx server as we have applied service pack 4 for...

Thanks for support

its working fine

Thanks very much

i have rebooted the server it is live server(production server)

some more information

iam using

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38...

thanks for response

any other solutions please

Thanks in advance

thanks for replying gail

but how can i find which table require indexes and

how to check wether indexes present in the table

for performence tuning

pls reply

experts pls reply soon

experts

update please

its urgent

thanks

HI GUYS

But finally I got the solution and resolved.

To resolve this problem:

1. I changed Log On information of MSSQLServer from Windows Services.

2. I also changed Log On information of SQLServerAgent...

How did you create the mail profiles for sql server and sql agent services?

iam using sqlserver 2000 sp2

when i tried to test sql profile iam getting this error

Error 18025:xp_test_mapi_profile:...

hi experts

please reply to this issue.

Thanks

update pls

Experts

Update pls.

Hi experts update please

i stopped 2000 services(named) then started 2k5 services(default)(now the services are running

but if i restarted the system again same problem 2k5 services are stopping

Errorlog.5

2009-06-10 15:53:38.21 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Developer Edition on Windows NT 5.1...