Sunday 29 March 2009

SQL Server Remote Connection

Free management tool: SQL Server Management Studio:

--> SQL Server Management Express

Or Toads:

--> Toad ™ for SQL Server Freeware

***


How do I configure MS SQL Express Server to allow remote connections?

--> Server Setup

***

If using a different TCP/IP port for your SQL Sever remote connection:

Sever name should use format: 192.168.1.1\SqlExpress,2301
Don't forget the comma!

No comments:

Post a Comment