Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2009-04-05 : 06:52:17
|
hello everyoneI'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" myNameI sign "sql server authentication" and at the "password" text box i assign:1234as 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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-04-06 : 14:58:33
|
Check what mode is your sql server? If it is in windows mode it won't allow you to acsess with sql user. Go to properties of server and see what you have under security , whether it is in single mode or mixed mode. |
|
|
|
|
|