Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to add my database through the "add database server" so that I can add users and maintain their permissions. We are running a dbo schema and our spatial database connection is working but not the server itself. Our database is running a SQL Server 2008 full edition instead of the Express edition.

When we are prompted to enter it, we enter ourdatabasename\sqlserver2008. Is this correct?

share|improve this question
    
I set up this connection last week with the Express version. It should be serverName\sqlserver2008. I think I just copied and pasted from SQL Server Management Tools. –  Roy Sep 24 '12 at 19:39
add comment

1 Answer

Hmm, here's the ESRI help doc regarding 'database server' connections.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Creating_a_geodatabase_on_a_database_server/003n00000028000000/

It only mentions SQL Server Express, so I'm going to guess that you won't be able to connect to the full version of SQL Server this way. I'd suggest adding users through SQL Server Management Studio (http://msdn.microsoft.com/en-us/library/ms174173%28v=sql.105%29.aspx) and then managing permissions per dataset within the geodatabase using the 'Privileges' command on the right click menu from the 'Database Connection' interface.

share|improve this answer
    
All things considered, I think it's more likely that the configuration is wrong. I'm not sure the full extent of the differences between the full version and express, but I was under the impression it had to do with data storage capacity (Express is limited to 10GB). –  Roy Sep 24 '12 at 19:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.