acess denied from network clients

[rodfiuza]

Hi there! I'm facing a strange situacion: i configured a database and a user with all acess and permissions. This user would be configured in my app so all users that use the app could acess data. The problem is that i have acess denied just when i firs try to login to the server, but it denies the acess to my machine name (its name in network) and not for the configured user. Some people already said to me that i have to configured sqlserver clients in the client machine. is that correct? Thanks for helping!

 

[tlbroadbent]

You must open the connection with the SQL Server login. Make sure the connection string doesn't specify trusted connection or the drivers will attempt to open the connection using your Windows login.

If you are using the ODBC drivers for SQL Server, you may have encountered a bug in the driver. Check the following link.

FIX: SQL Server ODBC Driver Ignores Authentication Setting

http://support.microsoft.com/support/kb/articles/Q279/5/26.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rodfiuza]

Thanks Terry, i do use sqlserver odbc driver and i'm sure that i didn't check the "trusted connections" option and the login is refused because my login don't grant acess to the server (this is bad). I didn't try the patch yet, but i'm pretty sure that it will match the question.