Connection Problems

Each time a user tries to connect to an application, they
keep getting the following error:
Unable to create ADODB Connection - [DBNETLIB]
[ConnectionOpen (connectionOpen()).]SQL Server does not
exist or access denied.
This has been happening for the last three days and each
time this happens the server has to be rebooted before
users can connect to the database. The application uses
windows authentication. The database is SQL Server 2000
SP3a.
Can you use the same accounts to connect to sql server ? Anything you see
in the Application and system event logs? Try connecting locally (on the
same box) and checking.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Thanks Vikram,
I have solved the problem.
>--Original Message--
>Can you use the same accounts to connect to sql server ?
Anything you see
>in the Application and system event logs? Try connecting
locally (on the
>same box) and checking.
>Thanks,
>Vikram Jayaram
>Microsoft, SQL Server
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Subscribe to MSDN & use
http://msdn.microsoft.com/newsgroups.
>
>.
>