Hi Casper,
I have tried that until I'm blue in the face. And I see nothing at all
referring to SQL Server. I don't even have a hint why it has not showing. I am
running GeoServer as a service. I also updated to 2.3.2 and notice that I have
two instances of GeoServer running being 2.3.1 and 2.3.2 which I don't
understand since both are installed the same directory. I have tried with each
version of the service and still no Sql Server is showing up. Pulling my hair
out.
Mark
From: Casper Span
<i...@spatially-oriented.com<mailto:i...@spatially-oriented.com>>
Date: Tuesday, June 11, 2013 4:04 AM
To: "Mark R. Paulson" <ma...@proseals.com<mailto:ma...@proseals.com>>
Cc:
"geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>"
<geoserver-users@lists.sourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>
Subject: Re: [Geoserver-users] SQL Server 2008 e Geoserver
I have it working on multiple machines.
It's really only:
- Installing the sql server plugin (copy to web-inf\lib)
- Copy sqljdbc4.jarto web-inf\lib
- copy sqljdbc_auth.dll & sqljdbc_xa.dll to c:\windows\system32\
You should copy the 64-bit dll's to C:\Windows\SysWOW64 if you are using a
64-bit JRE (and thus not running geoserver as a service)
If you are using the 32-bit JRE, you should also use the 32-bit sql dll's.
Then if you reboot geoserver (or restart service) you should be able to see 2
entries of SQL server on the create datastore page.
If you only see 1 (JNDI), then the dll's can't be found.
Hope this helps!
Casper
On Tue, Jun 11, 2013 at 12:30 AM, txrpls
<ma...@proseals.com<mailto:ma...@proseals.com>> wrote:
I am having the same issue. I am running Windows Server 2008 R2 and SQL
Server 2008 R2. I have installed the files as directed with no luck. I am
not running Tomcat. installed so the first file is installed in
D:\Program Files (x86)\GeoServer 2.3.1\WEB-INF\lib the others as in step two
below. I have restarted GeoServer, SQl Server and Windows Server and nothing
is showing up. Server is the 64 bit version BTW
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/SQL-Server-2008-e-Geoserver-tp4664552p5059240.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Casper Span
T: @Span_Droid<https://twitter.com/#%21/Span_Droid>
W: http://www.spatially-oriented.com
M: i...@spatially-oriented.com<mailto:i...@spatially-oriented.com>
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
