You can use it without the @, just have to specify the user and pass in the connection string. If you want to use a domain login, put the doman then the backslash then the username, in the username field. 'trusted_connection' yes, that means it will pass through the authentication that the web2py service is using, or if it's not run as a service, it will pass through the current user's credentials.
On Wednesday, October 2, 2013 4:20:40 PM UTC-7, Josh Myers wrote: > > I'm not a database expert. > > Aren't both of those connection strings equivalent in the DAL? Why are > you saying they are different? I will try it without the @. > > Does the Trusted_Connection = YES part tell it to connect to the database > using Windows Authentication? The main thing I'm trying to do is tell it > to connect via Windows Authentication in SQL Server 2005 and not SQL Server > Authentication. I thought Brian/Massimo had worked out a patch to allow > for windows authentication, but I was unclear as to how the connection > string should look in that case. Brian asked the same question, but it > seems it was never answered. > > > > On Wednesday, October 2, 2013 4:50:34 PM UTC-4, Niphlod wrote: >> >> use mssql://oledb_connection_string where oledb_connection_string is the >> "default" oledb formatted connection string. >> >> >> http://www.connectionstrings.com/sql-server-native-client-11-0-oledb-provider/ >> >> basically as long as there isn't a @ in it, the connection string will be >> used as it is with pyodbc, while if there is a @ in it, the connection >> string is "similar" to the usual user:pass@host/database >> >> On Wednesday, October 2, 2013 9:56:15 PM UTC+2, Josh Myers wrote: >>> >>> Brian and/or Massimo, >>> >>> Did this issue ever get resolved so that the DAL can connect with >>> windows authentication? If so, what is the syntax for the connection >>> string? >>> >>> Thanks. >>> >>> - Josh >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
