Cannot connect to SQL Server

[FRED_EMMERICH_(Guest)]

I have an ODBC connection to a SQL server database that works fine when I use it to set up linked tables in Access. It lets me do whatever I want to. When I try to create a report (v12) I get an error that says server does not exist or access denied. This is from the same ODBC connection (which always tests fine).____What would cause this error? It sounds like a possible security issue but since I can hit it with Access that does not seem likely.____thanks__Fred

[kfleming]

Try editing the file c:windows sw.ini____Add a section named DATABASE and then in this section add a line:____USEQECONNECT=1____and see if that helps.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

Adding that to rsw.ini did not work.____thanks__Fred

[kfleming]

I was able to set up an Access link to SQL Server and use the same ODBC connection using R&R without a problem. I am connecting to SQLServer 2000 using TCP/IP.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

I tried the same thing. As soon as I create a new report, and select the ODBC connection, it sits for a few seconds, and then I get the error message. It looks asif it is trying to log into the server and the loging fails. Which makes no sense because I can link to that same database using MS Access and the same ODBC connection. Of course MS products may have a special way of talking to each other.____I am guessing there is some setting on the SQL server causing this, but until I know what R&R is doing, I won^t be able to figure out what is going wrong. Ver 8.1 acts the same way.