ARCGIS question

Hi there,

I have a problem and I need a suggestion.
I have a GIS SERVER and another server that is the SQL DB server. One of the GIS spatialist is connecting to the SQL DB server using SQL server management studio and he can create Databases on it. Now he wants to activate the database using the ARDSDE service that is installed as part of SQL DB server.

My quest is does he need to login to the SQL DB server to activate the databases that he creates or can he do this part on his own laptop? Can he use another tool to activate databases within the SQL DB server.

I need some one who can explain the process.

Thanks,
LVL 4
Habib ZakariaNetwork Solutions ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MlandaTCommented:
The answer to your question is probably YES. I have no experience with ARDSE, but if the real question is whether someone can connect to SQL Server remotely and/or manipulate SQL Server from outside SQL Server Management Studio, the answer is yes.

SQL Server Management Studio is just a client tool to manage the database engine. There are many other client tools, so for example: http://stackoverflow.com/questions/5170/sql-server-management-studio-alternatives. With all these you can connect to the SQL Server instance and manipulate them.

In order to connect to an SQL Server instance and manipulate databases and/or server settings, one does not need to log into the Windows desktop of the computer running SQL Server. The connections can be made remotely, with any tool or application, provided the firewall is opened and/or depending on the authentication mechanism being used (SQL Server authentication or Windows authentication).
0
Habib ZakariaNetwork Solutions ArchitectAuthor Commented:
Ok thank you for your swift answer.
The user wants to run a tool on the server known as ARCSDE Post installation script. This is install as part of the sql DB server. here is the Run command of the tool.
"C:\Program Files\ArcGIS\ArcSDE\sqlexe\tools\ArcSdeSetupSql.exe" 1033

My question is how can this user access this tool with out RDP access to the server. Are there any ways he can access windows console just to run this post script tool.

Regards,
0
MlandaTCommented:
As I indicated, I have no experience with ARDSE, however, in a general sense... the requiments for connection to ANY sql server are:

- name/ip address of the sql server & the name of the sql server instance (NOTE: it is possible to have a default instance, in which case, there will be no instance name). these two would be user to identity the specific sql server installation to connect to and would be specified as either <MachineName>\<InstanceName> or just <MachineName> (for a default instance).

- port number of sql server on that machine. default is normally 1433

- sql server username and password

- database name

Unfortunately, I am not sure how ARCSDE works or what the install wizard asks for etc etc... however, maybe this link can help a bit:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/003n/003n0000006z000000.htm and
http://resources.esri.com/help/9.3/geodatabase/pdf/install_gd_sqlserver.pdf  (page 4 onwards)
http://oneresponse.info/resources/imtoolbox/publicdocuments/ArcGIS9%20ArcSDE%20Config%20GD%20SQLServer.pdf


this one might help (but seems to point to an older version of both ArcGIS and SQL Server http://resources.arcgis.com/content/kbase?q=content/kbase&fa=articleShow&d=29320&print=true
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Habib ZakariaNetwork Solutions ArchitectAuthor Commented:
Excellent help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.