FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


How to access MSSQL server ?





refinedruffian
How to interact with MSSQL server? Is there something similar to phpmyadmin? How can i query for list of dbs using php ??
shkumbin
My bet would be to install a trial of the MS SQL Server and after installing it you can do pretty much anything with the Database, if you are familiar with SQL it will be easier otherwise there are wizards for importing/exporting data from DB.
The link: http://technet.microsoft.com/en-us/sqlserver/bb462637.aspx
Bockman
I think what he wanted was an interface to interact with an already existing MS SQL Server.

The MS response to that (the free one obviously Wink ) would be

Microsoft SQL Server Management Studio Express Service Pack 2

Be Well Cool
mOrpheuS
refinedruffian wrote:
How to interact with MSSQL server? Is there something similar to phpmyadmin? How can i query for list of dbs using php ??

Here are the functions to connect to mssql - http://www.php.net/mssql

mssql_connect(), mssql_close()

The query to list all databases will look something like :
Code:
SELECT name FROM master..sysdatabases


hint : mssql_query()


A free premade php based administration tool may be hard to find, but there are other web based alternatives available.
You can try Microsoft SQL Web Data Administrator.

Since every kind of administration activity in mssql server can be achieved through T-SQL queries, a simple form page that allows you to enter and run queries against a mssql database is the most complete administration tool that you'll ever find. (not talking about ease of use here)

If you're looking for something easier to use, try the tool that Bockman has suggested in the post above.
froginabox
If you're looking for a GUI interface, I would highly suggest SQLyog.
Related topics
*OFFICIAL* Which Browser do you use?
Port Forwarding
Ragnarok Online private server...
how to set up a server
Using databases
Difference between a Jr. Admin & MOD
Network Domain
MySQL access on server 2
Cisco 2821 port forwarding
server speed/overload
Apache server with php???
SHELL ACCESS
server is down?
LAMP server with Ubuntu and VirtualBox help needed
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.