visual studio .net enterprise tools: When I attempt to create a new data connection through the
Server Explorer of my .NET project, I get the following
error:

ADO Error:'

[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not
exist or access denied.'

I have admin rights on the machine, and I attempt to
connect via integrated security.

Any help is greatly appreciated.

The error can be attributed to various network and permission issues. Is
the SQL Server on the same machine? If not then here are some steps to try:
1) Try to 'ping' the server to ensure it is accessible from your machine
2) Try to use SQL server authentication instead of integrated security
(then ensure you have the right NT permissions)
3) Confirm that you are using the 'Microsoft OLEDB Provider for SQL Server'
in the Providers tab of Data Link dialog
4) Confirm that SQL Server is running by connecting thru Enterprise
Manager/Query Analyzer etc on the server box
5) Check for any Internet connection Firewalls (on the server) or other
network related applications that prevent remote connections

Regards,
-Abhishek Lal

---------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.