22-04-2010, 07:36 PM
REMOTE LOGIN FOR SQL SERVER
1.1 General Introduction:
Each new version of Microsoft® SQL Server seeks to automate or eliminate some of the repetitive work performed by database administrators. Because database administrators are typically among the people most highly trained in database issues at a site, these improvements allow a valuable resource to spend more time working on database design and application data access issues. The Scope of administration of such complex task is still limited to the desktop over a LAN network where the Server is installed on a Single system, which acts as server, and the other systems in the client work under the client environment to interact with the SQL Server. The Project NSQL Enterprise Manager aims to increase the scope of administration by building the remote administration tool to interact with SQL server located over the web.
1.2 Statement of the Problem:
Problem Definition:
To provide Remote login for SQL server over the network to avoid the situation of presence of administrator at the server only.
Proposed Solution:
The Project Remote Login for SQL Server aims to increase the scope of administration by building the remote administration tool to interact with SQL server located over the web.
1.3 Objective of the Study:
¢ Need of an application to administer the SQL Server from a remote location.
¢ Increase the scope of the administrator where in the administrator need not be stay at serve all the time to carry out simpler tasks
¢ An interface not different from the Enterprise manager with even simpler methods of performing administration tasks.
¢ Maintain Security for SQL Server similar to enterprise Manager
1.4 Scope of the Study:
¢ The application should be designed in a manger that its interface should be similar to Enterprise Manager.
¢ The application should run in a browser from where the administrator can connect to any server installed on some other machine by providing the name of the server, its username and password.
¢ Should connect to any server within the network.
3.5 Software Requirements :
WINDOWS NT 4 | 2000 | 9.X | ME
Visual Studio .Net 2002 Enterprise Edition
Visual Studio .Net Framework (Minimal for Deployment)
3.6 Hardware requirements:
PIII 500MHZ or above
128MB RAM
100MB Free Hard disk space
STD Color Monitor
Network interface card or Modem (For Remote Access)
LAN Network (For Remote access)