I want to define a SQL server 2008 store within Geoserver 2.3. I installed the sql Extension.
After defining the different attributes, I get the following error message :
Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. 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.".)
The data I entered : host -localhost/sqlr2 port - 1433 database - the database name within SQL scheme - dbo user & password = A geoserver user i defined within sql
Thanks in advance Lauren