Does anyone know of a thread/threads on this list discussing the various
perils and pit falls of connecting to MS-SQL as a data store?
I'm trying with a vanilla install of MS SQL 2008 Express and keep getting
the following error:
"Error creating data store, check the parameters. Error message: Unable to
obtain connection: Cannot create PoolableConnectionFactory (The TCP/IP
connection to the host (local), port 1433 has failed. Error: "null. Verify
the connection properties, check that an instance of SQL Server is running
on the host and accepting TCP/IP connections at the port, and that no
firewall is blocking TCP connections to the port.".)"
And yes, SQL Server is running just fine on this box, I can connect with
MSSQL Management Studio Express, and SHP2SQL.
Using JRE 1.6, which requires me to use sqljdbc4.jar.
Connection parameters as follows:
Workspace > SQLServer
Data Source Name > MSSQL
Description > MSSQL
Host > (local)\sqlexpress and <machine>\sqlexpress and 127.0.0.1\sqlexpress
Port > 1433
Database > HFN
schema > <blank>
user > sa
passwd > ********* J
Namespace > http://geoserver.cloverpoint.org
(The rest is default).
Cheers, Samo
Bottom of Form
Samuel Smith
Groundlevel Geographics [DBA]
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
