SQL Server 2005 mixes mode to log onto configuration

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.