Re: [Geoserver-users] Problem in connection between Geoserver and SQL Server

2013-11-07 Thread Mauro Bartolomeoli
Hi Mary, to be able to connect to SQLServer from GeoServer, you should enable the mixed mode authentication in SQLServer (if it's not already enabled) and connect using a SQLServer user credentials, not the PC user ones. You can use the sa system user or create a new one from SQLServer Admin UI and

Re: [Geoserver-users] Problem in connection between Geoserver and SQL Server

2013-11-06 Thread Mary
Hi Phil, Could you please have a look to the attached file? It's print screen from Geoserver and SQL Server. Maybe I entered something wrong?! Regards, Mary On Thu, Nov 7, 2013 at 12:04 PM, Mary [via OSGeo.org] < ml-node+s1560n5087800...@n6.nabble.com> wrote: > Hi Phil, > > Thanks indeed for a

Re: [Geoserver-users] Problem in connection between Geoserver and SQL Server

2013-11-06 Thread Mary
Hi Phil, Thanks indeed for answering :) I've already connected to my database in SQL Server 2008 R2 and can see all details and spatial part of my shpefile. As it mentioned in error message the problem is about the USER! Do I need to create any username and password in SQL database? Actually I j

Re: [Geoserver-users] Problem in connection between Geoserver and SQL Server

2013-11-06 Thread Phil Scadden
>So could anyone please help me and show me the solution or tell me what is the problem? Any guidance >would be greatly appreciated... Well at risk of being too simple, but have you checked that you can log into the sql server database with those credentials from the server with geoserver inst