I have a problem I have never had. I have a MS Sever 2008 running MSSQL 2008. I have installed 35 computers with Windows 7 and added ODBCs for all my users before. I have 2 AD goups that have the SQL rights and everything is working fine for them.
I just purchased a new PC for a new user. It also is Win7. I can add ODBCs (Via System DSN) as an administrator to this machine without any problem. However, when I attempt to add the ODBC's as a specific user (Under User DSN) it tries to connect to the database and then times out saying: "Connection failed: SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][ODBC SQL Server Driver]Login timeout expired".
Anyone have any thought on how to rectify this?
Thanks ahead of time!