There should be a username between the ‘’ (unless you removed it)
Is this in the Studio (trying to open the data source) or from the Server? Robert From: Rick Sanders [mailto:[email protected]] Sent: Thursday, February 24, 2011 12:45 PM To: [email protected] Subject: RE: Witango-Talk: Connecting to SQL Server Hey Robert, My SQL server is already in mixed mode. I've tried authenticating with both a SQL server account and windows account and get the error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection. 28000 Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca <http://www.webenergy.ca/> From: Robert Shubert [mailto:[email protected]] Sent: Thursday, February 24, 2011 1:13 PM To: [email protected] Subject: RE: Witango-Talk: Connecting to SQL Server Rick, This usually happens when your SQL Server is setup to allow connections through Windows authentication only. Witango users SQL Server Authentication (a username and password). This KB article goes into the details: http://support.microsoft.com/kb/889615 Robert From: Rick Sanders [mailto:[email protected]] Sent: Thursday, February 24, 2011 11:30 AM To: [email protected] Subject: Witango-Talk: Connecting to SQL Server Hey all, When I'm trying to connect to my database it tells me the account isn't associated with a trusted SQL server connection. I've tried using both a windows account and sql server account and no dice. I know it's the way the server connects to the SQL server. Is there a way to set the database username and password in WiTango server? I have no problems connecting to it using other technologies like CF. Kind Regards, WebLogomailsig Rick Sanders Webenergy Software 902-401-7689 http://www.webenergy.ca <http://www.webenergy.ca/> _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
<<image001.jpg>>
