Hey Robert,
I figured it out. I had to create a user on both servers and have the Witango service start with the user. Then I had to set up odbc with that windows account and it worked. 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 3:15 PM To: [email protected] Subject: RE: Witango-Talk: Connecting to SQL Server Not the ODBC settings, but the settings that you use to ‘open’ the database in the Studio. Try right-click > Modify on the ODBC data source name and verify that the username/password is correct there. Then right-click > Set Data Source on the database action in question and select the data source on the left and check the “same as development” on the right. That should work provided that the same ODBC DSN is setup on your workstation and the Witango server machine. Robert From: Rick Sanders [mailto:[email protected]] Sent: Thursday, February 24, 2011 1:40 PM To: [email protected] Subject: RE: Witango-Talk: Connecting to SQL Server I can connect fine from the studio. I've set up the odbc driver to use the SQL username and password I gave it. I can connect fine with odbc. Note that the witango app is on one server, SQL server is on the database server, and the studio is on my desktop machine. All machines can connect fine with odbc to sql server. It's just the app server that doesn't send the username and password. I though the app server was supposed to use the odbc settings but I guess not? 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:51 PM To: [email protected] Subject: RE: Witango-Talk: Connecting to SQL Server 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. _____ 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.
<<image002.jpg>>
<<image003.jpg>>
