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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2008-09-26 : 10:32:36
|
| Hello everyone.I am just playing around in developer edition with creating users and logins.I create a user & login. Assign the user to the login.Now i just want to know. how do i login with the new user?I am only using my laptop. am i able to logon as a basic user using mixed authentication?can someone help pleaseRegardsRobMCTS certified |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 10:34:36
|
| Yes you can. Put your username and Password in your Database Connect. |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-09-26 : 10:35:30
|
| I do that and i get a message saying login not validMCTS certified |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 10:40:14
|
| Did you enable Mixed Authentication in Server Properties-Security? |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-09-26 : 10:44:31
|
| ahathat would be a good ideaDoes it matter if i log on with the basic as well as me (admin) on the same instanceMCTS certified |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-26 : 10:47:52
|
quote:
Originally posted by masterdineen
ahathat would be a good ideaDoes it matter if i log on with the basic as well as me (admin) on the same instanceMCTS certified
Why you have login like that? So did the test work or not? |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-09-26 : 10:56:12
|
| I shall do it later on tonight i going home from work in a bit. I just playing around with users and logins. No reason for the way im loging in. But does it matter that i use the same instance to log in as admin and user. or is there a better way for testing users and logins |
|
|
|
|
|
|
Testing new user & Login in Developer edition