The latest programs developed by Aviation Databases, makes use of SQL server to store and manipulate the data. This is a robust method but we have found that users new in the SQL environment experience problems to connect to the server from a non-server station.
There is a detailed article available on the internet assisting users to configure the SQL server environment for connection from a remote PC. Click here for a summary to configure the server and click here for a summary of how to open the Firewall. The basic requirements are as follows:
On the Server
- Ensure that the SQL Server Browser is running and the start mode is automatic (SQL Server Configuration manager)
- Enable TCP/IP protocol (SQL Server Configuration manager)
- If the server is not operating in a Domain environment, Windows Authentication will not be available. Select SQL Server and Windows authentication (SQL Server Management Studio)
- Firewall must allow the programs “sqlbrowser.exe” and “sqlserver.exe” access. Also open the default listening port TCP 1433
Also look into our other Blog on installing SQL Server 2008.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.