Hi Justin,
I’m able to create datastore for SQL Server. But I got “Unable to obtain connection” if entering database name in database field
When creating or editing a datastore.
Other issues were to create FeatureTypes for the datastore created by SQLServer.
I downloaded st99_d00.shp, st99_d00.shx, st99_d00.dbf and imported it to PostgreSQL database by PostGreGIS tool
and SQLServer 2008 database by Shape2Sql.exe. Then I created a datastore for the PostgreSQL database and a datastore for the
SQLServer 2008 database respectively.
I created a FeatureTypes for the PostGreSQL datastore without any problem.
Then I did samething for the SQLServer datastore. When clicking the button Generate at Bound Box: it displayed error message

I copied Min Long, Min Lat, Max Long, Max Lat from the FeatureType created for PostGreSQL datastore and pasted to
the SQLServer FeatureType’s.
Then, I viewed the FeaterTypes by clicking OpenLayers in geoServer at welcome.do. I selected the FeatureType
Created for PostGreSQL datastore, it displayed map well (I got same result by the FeatureType created by shape file directly).
But when clicking the FeatureType created for SQLServer, it shown a screen without map inside

When playing around and tried to find map, I got error message

Can you help for it?
Thanks
Keith C
-----Original Message-----
From: Chan, Keith (LESA IT)
Sent: Tuesday, March 24, 2009 8:12 AM
To: ‘Justin Deoliveira’
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] failed to create SQL server datastore
Hi Justin,
I installed SQL Server 2008 Ent. Edition to another machine, it worked. I don’t know if the issue is linked to
SQL Server 2008 Express or that I have several SQL Servers (2005, 2008) installed in same machine.
Thanks
Keith
-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Monday, March 23, 2009 2:51 PM
To: Chan, Keith (LESA IT)
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] failed to create SQL server datastore
Hi Keith,
So this error seems different, and that the port number is not specified
properly.
Check out this previous user list email:
http://www.nabble.com/SQL-Server-2008-datastore-connection-td22461607.html
Step one mentions making sure the ports are set up properly… and that
static ports are used. Can you verify that list of stuff is set up?
-Justin
Chan, Keith (LESA IT) wrote:
Hi Justin,
I tried both 1.7.2 and 1.7.3 version of sql server extension and failed
for both with the errors.
And SQL Server used is the edition of SQLExpress.
I created DSN to connect to the SQL Server and no problem. That means
the sql server is running and the sa account is working.
Thanks,
Keith
-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Friday, March 20, 2009 4:12 PM
To: Chan, Keith (LESA IT)
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] failed to create SQL server datastore
Hi Keith,
IN step 9, the blue box on the side denotes the error so the datastore
is not being set up properly. To me that errors indicates that there
could be a version mismatch with some of the geotools libraries. You are
running geoserver 1.7.2, did you download the 1.7.2, or 1.7.3 version of
the sql server extension?
-Justin
Chan, Keith (LESA IT) wrote:
I downloaded stable version SQL Server extension and put these jar
files to
WEB-INF/lib directory. And downloaded SQL Server JDBC driver and put
sqljdbc.jar to the same directory.
Then started geoserver version 1.7.2, clicked Config, clicked Data,
click DataStores, clikced New. Then did followings
- Select Microsoft SQL Server in dropdown list Feature Data Set
Description.
- Enter an unique id and clicked
- Select namespace in dropdown Namespace
- Enter sql server name (the sql server is in same machine)
- Enter 1433 for port
- Enter a database name in the sql server
- Enter sa for user
- Enter the password for the sa account in sql server
- Clicking Submit button gets the screen.
- Clicking Apply button gets the screen
- Then click Data, click DataStores, select the DataStore just
created and click Edit, it prompts a form like to create a new datastore.
I did same thing to create postgres datastore and it is fine.
Can you help to fix the problem?
Thanks
Keith
Apps built with the Adobe(R) Flex(R) framework and Flex Builder™ are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse™based
development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
Geoserver-users mailing list
Geoserver-users@anonymised.comet
https://lists.sourceforge.net/lists/listinfo/geoserver-users
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
–
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.