I'm trying to create a new login to my sql server 2005 developer edition so i can connect through it from a remote client.
Unfortunately i fail to create the new login.
In "object explorer", "security" i right click "logins" and i select "new login"
At the "Login - new" form i assign values as follows:
"login name" myName
I sign "sql server authentication" and at the "password" text box i assign:1234
as well as at the "confirm password".
I sign "enforce password policy" and "enforce password expiration" and i unsign:
"user must change password".
At the "default database" i assign "myDatabase" and i click the OK button.
Then, in "object explorer", "security" i find that at the "logins" list "myName" is added.
From: "object explorer" , "databases" "myDb" database, "security" i right click on "users"
and select "new user" and assign the followin values at the "database User - new" form.
"user name" i assign "myUserNmae"
"login name" i browse login name and sign "myname".
At the database roles membership at "Role members" list i sign "db_owner".
I click OK and from "Windows' "start" menu i select "microsoft sql server"
"sql server management studio".
in "server name" text box i assign my server's name.
in "authentication" i select "sql server authentication"
in "login" i assign" "myNmae and in "passord" i assign "1234".
Then i click connect just to get an error message that says:
"myNameis not associated with a trusted SQL Server connection."
Why is that ?! Is iy a mistake i made ? Something i forgot? or just bad luck ?
Thanks