Unable to create spatial database connection to SQL Server 2008 from ArcCatalog 9.3.1
Creating spatial database connections via direct connect as below works fine for both database authentication or windows authentication: Server: myServer Service: sde:sqlserver:myServer Database: myDatabase
Creating spatial database connections via SDE connect as below works fine for database authentication but not for windows authentication: Server: myServer Service: 5151 Database: myDatabase
I've checked the following: - Log files give Error (10) a generic connection error - The Windows login in has READ and EXECUTE permissions to %SDEHOME%\bin
The esri_sde service was set up via the post installation wizard to use SQL Server authentication. I'm presuming this should not matter given the windows login as the permissions to the service as described above?
I'm having this issue when I login to the server machine and use the ArcCatlog on ther server. Making spatial database connections of any type fails from a machine other than the server.
It just weird, when you are using SQL Server EXPRESS 2008, you can Add Database Server, no more "Connections to this edition of the database server are not supported"
And, no. What we are talking about is not "Add Database Connection", but Add Database Server. Add Database Connection just both works on SQL Server 2008 and SQL Server Express 2008.
Why we resist to use Add Database Server, and consider it as important is because: to set privilege of ArcGISSOC user when we are using ArcGIS Server to create web editable map service layer (feature-access). In the manual help of ArcGIS Server, for ArcGIS server could use feature access properly, we have to right click the Database Server, and then select Permissions, and set ArcGISSOC user as user and admin on that database server.
When we use SQL Server Express 2008, we could do that without problem. But on SQL Server 2008, we can't.
Is it a bug?
We need to use SQL Server, not SQL Server Express, because the Express one has limitation: only single core used, only support 4 GB database, and more limitation.
This is not a bug, it's how the software was intended to operate -- ArcSDE Workgroup (Database Server) is *only* supported with SQL-Server Express. If you want to use Standard or Enterprise SQL-Server, you must install Enterprise ArcSDE (Database Connection), and administer it as an Enterprise install.
Hello, I read in a previous post that for Enterprise SQL one must install Enterprise SDE in order to create Database Server Connections. Is this still true? I'm asking if this is still true since from helpdesk, I am being told to avoid installation of Enterprise ArcSDE and use direct connect.
Your question is completely unrelated to this thread (which is about the difference between Workgroup and Enterprise ArcSDE). There is no requirement to install application server binaries to get Direct Connect access to an Enterprise ArcSDE installation, but Direct Connect to an Enterprise ArcSDE instance is still Enterprise ArcSDE (which technically operates against an Enterprise, Standard or Express SQL-Server instance).
If you do not understand the direction given by Tech Support, you should contact them again until it is understood.