Citrix and Sql authenication

[mollyking]

We have an application that using SQL 200 for the database. The applications requires SQL authenication, not Windows. We can run the application if we log into Citrix explicitly. If we log into Citrix anonymously, the application cannot find the database. Any ideas on what the problem maybe? Both servers are Windows 2000 and Citrix is Metaframe 1.8.

 

[Syty]

Two things, one you when you "log on" Citrix explicitly, are you using a Domain User ID and a password? If you are then you are allowed to browse the network as a member of "authenticated users" on the server, and your user account permissions. If you are anonymous, you have a connection to the server itself, but no domain rights. If the database is in say a server farm, you may not have access to it. I understand that the application requires authentication separately, is this account the same as your domain account? If so you may be experiencing "pass-through authentication" where the server is using your credentials to browse the network.

Are you loggin onto a "direct desktop connection" or are you "Publishing applications?"

Is this application used over the Internet or locally internally? Regardless, upgrade to Citrix MetaFrame XP and lose that clunky ICA client on the client footprint. With the NFUSE plug in, all 1494 traffic will be redirected over 443-SSL, and the database will be executable from your browser.

enjoy.

 

[mollyking]

The problem turned out to be in the ini file used by the program. In it, the sql server was listed by netbios name. I changed that to the server's ip address and everyone is able to connect.