Good morning, the jdbc driver does support it, but it would be usable on windows only. The current user (in this case the user account running GeoServer) would be used for accessing the DB, and therefore would need access rights for SQL Server. According to this site http://msdn.microsoft.com/en-us/library/ms378988%28v=sql.90%29.aspx it is only required to add "integratedSecurity=true" to the jdbc url. I am not sure, if it in that case simply ignores the username and password provided in the jdbc url or if they must not be present.
I could probably implement it myself, but I don't know where to start. I had a look at the source code yesterday, but as I am not that familiar with the internal workings of GeoServer I was not able to find where I would have to do changes. Best Regards, Mirko On 08.03.2011 17:31, Justin Deoliveira wrote: > Hi Mirko, > > I actually don't know... if the jdbc driver supports it then there is no > reason why we can't add that option. If you can find out if the jdbc driver > supports connecting that way let us know and open a feature request to enable > it. Better yet if you have some java skills submit a patch. > > -Justin > > On Mon, Mar 7, 2011 at 10:27 AM, Mirko > Bothe<[email protected]<mailto:[email protected]>> wrote: > Hello, > > I have a question about the GeoServer Extension for MS SQL Server > datastores. It seems to require database internal authentication (= > users managed by the DBMS). Would it also be possible to use the > integrated windows authentication (= users managed by windows)? If it is > possible at all, how do I do it? Using a Windows Username and Password > did not seem to work. > > Best Regards, > Mirko Bothe > > ------------------------------------------------------------------------------ > What You Don't Know About Data Connectivity CAN Hurt You > This paper provides an overview of data connectivity, details > its effect on application quality, and explores various alternative > solutions. http://p.sf.net/sfu/progress-d2d > _______________________________________________ > Geoserver-users mailing list > [email protected]<mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > -- > Justin Deoliveira > OpenGeo - http://opengeo.org > Enterprise support for open source geospatial. > > ------------------------------------------------------------------------------ Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
