Hi!

I need help on SQL Server Connectivity. I have a problem that it is always coming back. I'm currently using VB 6.0 to make a Database app. it is working fine when users connect to SQL Server but most of the time with in the day if a user log off and then log back to sql server then the problem while arise that "SQL Server connection.. Access Denied or does not exist." What is the remedy of this problem? Most of the Time i will restart the SQL Server then let the users connect back to it. which is a big hustle. Could any one HELP me on this matter?

Thanx

ctanchan

 check your username, password and SQL server 2000 settings.

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

I had A similar problem here with my SQL 2k Box and one of the client machines.

1. I was using AD to manage my domain but I did not have DNS and DHCP on- I was serving DHCP from the router and had no local DNS. I installed DNS and DHCP (and set it up properly).

2. Since I am a developer, I use the MSDN version and never really bother with putting the licences in properly. I found that when I went to my Server logs that I was having lots of licencing conflicts. I put my licences in properly...

Once I did both of these things the problems went away- I don't know which one fixed it.


Hal Levy
Unemployed (Thanks GWB)
NOT a Wiley/Wrox Employee

Deepesh Jain,

Username, password are correct. because i code connect directly. and sometimes when i reconnect it would error.

Are yhou closing your SQL Server connection after you open it?

Sal