We are trying to create an ODBC connection from a terminal server running server 2008 to a SQL server 2008 (also on a server 2008).
When creating the connection from a server 2003 terminal server the connection is successful and i am able to gain access to my databases. However, when trying to create the same connection from the server 2008 terminal server we get an error that the server
does not exist or access is denied. We have gotten the connection to work on the server 2008 terminal server but only if we use the FQDN or the IP address. We need to be able to use the hostname to make the connection easier for users who are making connections
to the SQL server using access or excel. WE have exhausted our efforts to correct this problem. We have checked DNS records and created a service principal name (SPN) in active directory. Thank you in advance for your help in resolving this issue.
View Complete Post