|
|
|
|
Steps to Setup MsSqlSpatial
This is a way how I installed and setup MS SQL Server and
MsSqlSpatial .
- Install
SQL Server 2005 Express
Enable Windows and SQL Authentication
- Install SQL Server Management Studio
Express
- Enable TCP/IP and Named Pipes
Run 'SQL Server Configuration Manager' from 'Start -> Programs
-> SQL Server 2005 '
Under 'Network Configuration' select 'Protocols' and Right-click
and enable TCP/IP and NamedPipes
- Using Management Studio Express Create new
Database 'FdoUnitTest'
- Enable CLR integration
Using Management Studio Express execute:
sp_configure 'clr_enable', 1; reconfigure;
- Download and extract MsSqlSpatial
latest version
- Run
MsSqlSpatial Command Line Tool, msscmd.exe
msscmd -deploy -deploy_permission=EXTERNAL_ACCESS -server=localhost\sqlexpress
-db=fdounittest -login=sa -password=YourSaPassword
- Using Management Studio Express create
'unittest' user
Create login unittest
Add user to 'FdounitTest' database
Add roles dbo.ddladmin,dbo.datawriter,dbo.datareader
- Setup ODBC connection 'mssql' to SQL server
From Control Panel select Administrative Tools
Select Data Sources (ODBC)
Choose Tab System DNS and click Add
Select SQL Native ( or SQl Server )
Enter Name for DNS 'mssql' in my case and select server (
e.g. localhost/SQLExpress )
Enter user credentials and Test Connection
More information about MsSqlSpatial you can get on
MsSqlSpatial site
|
|