Urgently if possible
I have sql 2005 work to program by .net my problem connect by odbc connection to windows authentication but when i do connection to odbc it work but if i close the program then open again it make error like following :
connection failed sql state 28000 sql server error 18452 the user " is not associated with trusted sql connection
why it make error
My sql server 2005 setting information as following
1-sql server and windows authentication option checked support
2-when i write connection data i write name :database name server name :ip
then when it come to account windows authentication it give error message
3-every time to work the program it must restart server to work again
4-my server support tcp/ip and named pipe
and via disabled and all remaining is enabled