-
SQL connection fails
My SQL connection fails when I try to connect to SQL server on a network.
I tried ODBC, SQLCLient and OLEDB.
Message says server does not exist or connection denied.
Though I connect with no problem to local Server and work on network server from Query Analyzer.
Can be this problem caused by the fact that network sql server does not have .net framework installed ?
-
If SQL Server on the network is using windows authentication it may be because the ASP.Net account is trying to access it and it doesn't have permission.... not sure though.