Saturday, February 25, 2012

remote connnect MSSQL 2005 express

Can we remote connect MSSQL 2005 express with IP address?
If can how to done it?
With regards,
GohBasically:
1. Enable remote TCP connections.
2. Open the firewall if necessary.
3. Start SQL Server Browser Service if you don't know the port.
4.Specifiy the named instance of the SQL Server Express installation.
For details, start with the tutorial at
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Goh" <goh@.noemail.noemail> wrote in message
news:OECethpFGHA.644@.TK2MSFTNGP09.phx.gbl...
> Can we remote connect MSSQL 2005 express with IP address?
> If can how to done it?
> With regards,
> Goh
>|||it work thanks.
"Rick Byham [MS]" <rickbyh@.online.microsoft.com> wrote in message
news:u9fd6FtFGHA.4036@.TK2MSFTNGP12.phx.gbl...
> Basically:
> 1. Enable remote TCP connections.
> 2. Open the firewall if necessary.
> 3. Start SQL Server Browser Service if you don't know the port.
> 4.Specifiy the named instance of the SQL Server Express installation.
> For details, start with the tutorial at
> http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "Goh" <goh@.noemail.noemail> wrote in message
> news:OECethpFGHA.644@.TK2MSFTNGP09.phx.gbl...
>

No comments:

Post a Comment