The database system that just installs, according to the word of acquiescent installation, having fault of long-range join times probably, it is a mistake normally: "When receiving SQL Server 2005 repeatedly, below acquiescent setting SQL Server does not allow to undertake this fails joining remotely may be bringinged about. (Provider: Name conduit to offer a program, error: The join that 40 - cannot open SQL Server) " , sum up as follows in the light of this problem now:
Understanding SQL Server is the database saw a network with respect to Ke Yingren, simple cent is a few kinds of circumstances below.

◆ 1. Database engine was not started. Have two kinds of kind that start:

(1) begins - > program - > periphery of Microsoft SQL Server 2005->SQL Server 2005 applies configuration implement, the connective periphery that clicks " service in the interface that open applies configuration implement " , database Engine is found in the interface that open, click " to serve " , in on the right side of examine whether to already start, if was not started,can click " to start " , ensure " starts type " to be automatic, do not be a hand to move, the hand wants to move the; that start again when switching on the mobile phone next time otherwise

(2) can open:  ?> program - > Microsoft SQL Server 2005-> configures a tool - > SQL Server Configuration Manager, the SQL Server(MSSQLSERVER) in service of pitch on SQL Server 2005, the " in clicking tool column starts service position instead service " pushbutton;

Use above when two kinds of means, the mistake may appear when be being started occasionally, cannot start, be about to examine "SQL Server 2005 to configure management at this moment implement the network of SQL Server 2005 in " is configured - > whether was the VIA in MSSQLSERVER agreement already enabled, if already was enabled, prohibit it. It is OK to carry out a kind of afore-mentioned meanses to operate again next.

◆ 2. Whether had allowed long-range link. The cent with this OK and simple part is 4 respects, it is respectively long-range join is enabled on SQL Server, enable SQL Server to browse a service, found for SQL Server 2005 in Windows firewall exception and exception is founded for “SQLBrowser” in Windows firewall. A few particular mode of operation are below:

Long-range join is enabled on SQLServer example

◆ 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 ” of “ database engine, ” of long-range join of pitch on “ , in ” of join of this locality of “ of right pitch on and long-range join,
Previous12 3 Next