SQL Server problem

[Marivic]

Hello All,

I have finished an ASP.Net application and already put in production. This was being accessed by over a hundred users. My application is connecting to an SQL Server 2000 db.

My question is: SOME of my users are experiencing an "SQL Server does not exist or access denied" runtime error sometimes but not always. Is this related to a network error? or an application error? I'm just thinking if I missed out something during development.

Please shed me some light.

Thanks in advance.

[ptran]

What connection are you trying to use to make to the sql server? Make sure the permission in sql is grant.

[hellswraith]

SQL Server does not exist or access denied

That seems pretty vague. Maybe the network is preventing a fast reply, and the timeout on the connection is happening? Not sure though. You might want to provide some logging so you can troubleshoot better. You could match up the log times with the errors and the network traffic at the time.

[Marivic]

Hi,

Thanks for replying. How can I provide logging? Do I have to modify my application?

Thanks.

[hellswraith]

Yes, you would have to modify the app and include in some error catching to log the error and such. .Net has some built in logging classes and such.

Check the System.Diagnostics namespace, I think the functionality is in there.