User Interface for SQL Server?

Migrating from Access to SQL Server you realise, that you suddenly do not have any user interface....
I have created an Access front end with an ODBC connection to the SQL Server, but surely there must be alternatives?
IbDyhrAsked:
Who is Participating?
 
jamcosCommented:
There is SQL Reporting Services...probably way overkill for what you want. http://www.microsoft.com/sql/technologies/reporting/default.mspx
For forms, we write our own ASP.Net applications. It's definitely crossing into a different world than basic Access forms and reports. Using Access as a front end isn't a bad way to go if you are comfortable with it and it does what you need.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Check for "Sql server manage ment studio "  under start-> programs -> sql server 2005

Or else type "sqlwb.exe" at the start->run  prompt
0
 
jamcosCommented:
The UI for SQL Server is SQL Server Management Studio. The part that is a pain is that it's not installed by default. Managerment Studio is part of the "Workstation components, Book online, and development tools" item in the components to install screen of the setup.  Or, if you pick advanced on the components screen, it's in Client Components / Management Tools.
0
 
IbDyhrAuthor Commented:
Thanks - I already have the Server Management Studio (Express) up and running, but I was thinking along the lines of creating forms and reports - a real application so to speak, and not just table data and query-results.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
there is no other client tools associated with SQL server, if you need to create forms and other stuffs you need to make use of either access forms or some other programmin languages.
0
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.

All Courses

From novice to tech pro — start learning today.