How to enable remote connect to SQL Server 2008? 
週三, 十月 6, 2010, 04:16 AM - SQL Server
How to enable remote connect to SQL Server 2008?

1. Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager

2. SQL Server Services > SQL Server Browser > Right Click > Properties > Service > Start Mode > Automatic > Log on > Service status must be running > If not click Start > ok

3. SQL Server Services > SQL Server Browser > Right Click > Restart

4. SQL Server Network Connection > Protocol for SQL$$$$ > TCP/IP > Right Click > Properties > IP Address >

IP1=> Active=Yes, Enabled=Yes,IP Address =<machine ip address>, TCP Dynamic Port=Empty, TCP Port=1433

IP2=> Active=Yes, Enabled=Yes,IP Address =127.0.0.1, TCP Dynamic Port=Empty, TCP Port=1433

IP3=> TCP Dynamic Port=Empty, TCP Port=1433

And click ok & Restart your SQL Server Service.

[ 發表回應 ] ( 15預覽 )   |  常註連結  |   ( 3 / 1472 )

<< <前一頁 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 下一頁> >>