I am new to sql server express and i installed sql server express 2008 R2 with windows authentication as an administrator of the machine.
我的目标是建立一个数据库,管理一些文字,以制作表格和数据,并从申请表与数据库连接。
I created a new database abc with owner as default. I create a new login and lets call it bob with sql server authentication.(am i doing it right?) Here i chose default database for that login as abc THen i created a new user (same name bob) within the folder of my database and mapped to the existing login bob.
究竟是怎样做?
when i try to connect through sql server management studio with sql server authentication and entered the username and password for the user bob, i get an error saying that i cant connect. please clarify what steps i am missing.
感谢。