After VS2005 is installed, can bring edition of SQL Server2005 Express oneself, manage to facilitate, still need to install a business management implement, need downloads Microsoft SQL Server Management Studio Express(to download a name: SQLServer2005_SSMSEE.msi) . Because acquiescent is,can log onto mode with Windows system only, if want to login to need to undertake as follows configuring with mixture mode:
1: Function of open SQL2005 long-range join
Configuration tool - > SQL Server periphery applies configuration implement - > service and connective periphery application are configured implement - > the DataBase Engine node that opens SQLEXPRESS to fall, choose long-range join, choice “ uses TCP/IP and Named Pipes” at the same time, after deciding, restart the database serves.
2: Entry instead mixes mode
Open government implement, with Windows means join enters a database, right key hits occupies a server - attribute, security, “SQL SERVER and ” of mode of Windows identity test and verify choose below ” of test and verify of “ server identity, "The entry ” that " of entry examine and verify chooses “ failure and success is affirmatory.
3: Build user and password, as similar as Sql2000, do not make the introduction
Can join with data string has link so, for instance (Server= . " of name of database of sqlexpress;uid=sa;pwd= password;database= )
If using time of SQLServer mode connective, “ signing up for a fault establishs link successfully already with the server, but the mistake happens in entry process”
The " security " -> that spreads out a server to go up lands a name - > pitch on SA lands an account (right key) - > condition - > land long instead to enable.
Hot Tags: