show code js

2010年9月16日 星期四

Create database and login at SQL Server

1.create a database=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
a.create new database=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(1)right click [Database] and click [New Database]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(2)set a name for this database (ex:newdb)=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(3)check [Use full-text indexing]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(4)click [ok] to finish.=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
b.create new user=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(1)open [security]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(2)right click [logins] and click [new login]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(3)set a name for this login (ex:newlogin)=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(4)choose [sql server authentication], set and confirm a password=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(5)uncheck [enforce password policy]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(6)choose (newdb) at [default database]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(7)at [select a page] item=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(a)click [user mapping]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(b)check (newdb) and check [db_owner] for [database role membership for:newdb]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
(8)click [ok] to finish.=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
2.if you want use web login=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
a.run [C:\WINDOWS\Microsoft.NET\Framework\v2.0.????\aspnet_regsql.exe]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
b.click [next] to choose [configure sql server for application services] and click [next] again=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
c.set [server] address=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
d.choose [sql server authentication], set [user name](newlogin) and [password]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
e.set database name(newdb) at [database]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
f.click [next] and agaion to begin insert sql data=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
g.click [finish] to finish.=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
3.project sql connect=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
a.open [web.config] and edit=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
b.find [<connectionstrings>......]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
c.modify and replace [<connectionStrings>=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
<add name="ApplicationServices"=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
connectionString="data source=(sqlserverhost);Initial Catalog=(newdb);Persist Security Info=True;User ID=(newlogin);Password=(***********)"=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
providerName="System.Data.SqlClient" />=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
</connectionStrings>]=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
d.close and save=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
e.run vs and open project, click [asp.net config] to config=eG3Uoxq4GKz7guU5V45ubBGcYk-YT+6Dit
f.click [security] create user , and enable role and create role to begin

沒有留言:

張貼留言