Sql 2005 express about remote access and the sa password problem

Sql 2005 express about remote access and the sa password problem 
sqlserver2005 version now more, have express version, there are enterprises such as the development of version, I used to express the current version, 
Occupied system resources, or very little, unlike the Internet said, one is running the development version, it ate more than 400 M memory, the great majority of our 
Most people, in order to take a look at sqlserver2005 new features, there is no need no formal Developer Edition installed, Express version of the small, and it 
The function of the individual spent enough. 
       Bahrain sqlserver2005 (Express version), in order to manage, you need to manage to go to the next manager, Microsoft's official website has 
Under the Manager manage installed after the procedure to connect sqlserver2005, are the following points should be noted. 
       1. Sql2005 to open remote connection features, open approach is as follows, 
            Configuration tools -> sql server configurator external applications -> services and applications connected to the external configuration device -> open the MSSQLSERVER node under the Database Engine node, the first optional "remote connection", to take over the proposed choice of "At the same time the use of TCP / IP and named pipes ", are identified, restart the database service it. 
       2. Landing settings changed, Sql server and windows Authentication mode is selected at the same time, the specific settings are as follows: 
          manage manager -> windows Authentication (the first time the way into windows), -> Object Explorer, select your database server - right-> properties> security> Sql server and windows Authentication mode is selected at the same time. 
       3: Sql server to set up a way the user name and password, the specific settings are as follows: 
     manage manager -> windows Authentication> new query> sp_password null, 'sa123456', 'sa' 
     This will set up a user name is sa, password: sa123456 of users, the next landing, you can use Sql server mode 
User name is sa, password: sa123456 users into a database. 
      4: After finishing the above steps, this Writing connection string can be a smooth entry into the database, 
         (server =. \ \ sqlexpress; uid = sa; pwd = sa123456; database = master ";