LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » SQL Server Security » Sql Authentication login

Sql Authentication login

Options

Previous Topic · Next Topic

Jumbuck

Posted: Friday, April 24, 2009 12:30:56 AM

Rank: Newbie

Joined: 4/22/2009
Posts: 2
Points: 6
Where do you live?: US

I've tried creating a login name and password in Management Studio Express with Sql Server authentication and the desired database selected as the default. If I then try to connect to that database outside Management Studio using that login, I get the error message, login failed for user <name>. If I try to open the database in Management Studio Express via Sql Server authentication, the database is listed in the left window in outline only (for example, if I open its Tables folder, none of its tables are listed).

What does this rendering in outline signify? Perhaps that provides a clue as to what I'm doing wrong.

Scott Whigham

Posted: Monday, April 27, 2009 1:27:06 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

Hi there -

It sounds like you have Windows security set for your SQL Server (the default). To change, you need to fire up SSMS and connect using Windows authentication, right click on the server and select Properties. Then go to the Security tab and change to mixed mode. Once you restart your SQL Server service, you should be able to get in!

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.