bngala5
asked on
How to connect to the SQL server database from a client PC remotely
I am new to database technology currently I am using SQL server 2008 and SQL server 2008 R2 trial versions, I would like to connect to the SQL server remotely to access a specific databases to view tables and queries. Which application or client software can I use to accomplish this tasks.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
lamaslany
You need Microsoft SQL Server 2008 R2 Management Studio.
You also have to bear in mind if you want to access out of the network - which means through the internet.
If so you have to open up for port 1433 and 1434 in your firewall. You have to use SQL Studio Management Studio R2 as the experts says above.
If so you have to open up for port 1433 and 1434 in your firewall. You have to use SQL Studio Management Studio R2 as the experts says above.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
