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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 adding a new login to sql server 2005

Author  Topic 

pssheba
Yak Posting Veteran

95 Posts

Posted - 2009-04-05 : 06:52:17
hello everyone

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



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.
Go to Top of Page
   

- Advertisement -