Added User but cannot Connect on 2005? 2

[litton1]

Hi all, first I will apologies if this a simplistic question…. Here goes. I need to learn SQL Server 2005 for work so I have installed and created a DB without much trouble, so far so good. I created a new Login user on this local machine with the following commands

CREATE LOGIN myUser with PASSWORD = 'password'

use Forum
CREATE USER myUser

go
grant connect to myUser
go

Alter login myUser with CHECK_EXPIRATION = off
go

alter LOGIN myUser with CHECK_POLICY = OFF
go

When I try to switch users from within management studio I am unable to connect. Does anyone know why this is? I am not doing something. Thx in advance T

Age is a consequence of experience

 

[ptheriault]

you can change it. Follow the instructions that George provided.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[gmmastros]

Scroll up a little and read my post. Time stamp is: 26 Feb 07 15:06

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

Ooops, I missed step:

Open 'Microsoft SQL Server management studio'
Right click the server in the 'object explorer' window.
[!]Click Properties[/!]
click the 'security' tab.
Check the 'server authentication' section.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[litton1]

OMG! I am in!!!!! Yes, it was in windows authentication mode
Yes I dumb its official.
I wish I had read that post better but anyways… I have learnt much from you all. Thx Guys, I will give out the stars now

Age is a consequence of experience

 

[ptheriault]

I'm glad I could help.

- Paul
- If at first you don't succeed, find out if the loser gets anything.