Reelection choose wants used agreement, (This place ought to be enabled TCP/IP and name conduit the service! ) click “ application ” , you can see next informations:
After “ serves till engine of the new database that start, alter ability to what what join setting does meeting become effective. ” , click “ to decide ” pushbutton is returned
◆ 4. Spread out ” of “ database engine, pitch on “ serves ” , “ is clicked to stop ” in right, when MSSQLSERVER service stops,
Click “ to start ” next, the new MSSQLSERVER that start serves.
Enable SQLServer browser service
◆ 1. Point to “ to begin - > program - > Microsoft SQL Server 2005-> configures a tool - > SQL Server periphery applies configuration implement”
◆ 2. In “SQL Server 2005 periphery application is configured implement ” page, click “ service and configuration of connective periphery application implement”
◆ 3. Click next spread out “SQL Server Browser” , pitch on “ serves ” , in right “ ” of the type that start chooses “ automatic ” ,
Click “ to start ” again, click “ to decide ” pushbutton is returned
Exception is founded for “SQL Server 2005” in Windows firewall
◆ 1. In interface of Windows firewall setting, choice“Exceptional”Option gets stuck, click “ to add a program next”
◆ 2. Program window is added in “ “ is clicked to browse in ””
◆ 3. Find “C:P nextRogramFilesMicrosoft FilesMicrosoft SQL Server MSSQL.1 MSSQLBinnsqlservr.exe” ,
Click “ to decide ” is returned
Attention: Method may differ according to installation of SQL Server 2005 and differ. MSSQL.1 is to take an a surname, ID of corresponding database example.
◆ 4. To every need opens the example of SQL Server 2005 of long-range visit, repeat measure 1 to 3.
Exception is founded for “SQLBrowser” in Windows firewall
◆ 1. In interface of Windows firewall setting, choice“Exceptional”Option gets stuck, click “ to add a program next”
◆ 2. Program window is added in “ “ is clicked to browse in ””
◆ 3. Find “C:P nextRogramFilesMicrosoft FilesMicrosoft SQL Server90Sharedsqlbrowser.exe” ,
Click “ to decide ” is returned
Attention: Method may differ according to installation of SQL Server 2005 and differ. When use.net development undertakes, can encounter use join string to join database of SQL Server 2005 uses machine name and Localhost to be able to join, but use IP address however cannot connective problem, settlement way is this locality and long-range join are enabled on SQL Server example, and when choosing an agreement use TCP/IP is mixed name conduit service to be able to be solved.
Previous 1 23 Next