I have a user that is unable to open an Excel document properly. It has a bunch of connections it uses that go back to an SQL server on the network called LS1. It was working correctly until we added TCP and Named pipes using the cliconfg.exe to fix the connection that broke between their ERP software and the database. It did fix the ERP but this spreadsheet spits out [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. It then prompts for SQL server login and populates the Server box with the correct LS1\MSSQL_08 but both Trusted Connection and putting in his credentials spits out:
SQL Server Error: 17
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
The weirdest part(s) is that he can connect to the server using SQL Server Management Studio just fine and a user in an office next door to him can access the Excel doc without receiving any errors at all and she had the same tcp and named pipes alias added to her machine as described above. I'm lost.
Any help would be greatly appreciated.