Hello,
I have a following configuration in my test environment:
DOC1 server
server 2003 with sql 2005 server and content server
IAI server
on IAI I have created ODBC connection to doc1 using sql server driver.
I have installed SQL server 2005 management studio with backward compatibility pack
SQL server 2005 management studio is able to connect to doc1 instance and browse databases with a newly created account tha has sysadmin privilages.
However while installing IAI i cannot get it to connect to the InvoicesDB that I created. it gives me the following error no matter what I change:
(I use the same credentials that I use for Management Studio)
Description: [ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)
Any help with this?