Rank Beginner Question - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Administration

Rank Beginner Question

Author

Topic

RBurr
Starting Member

3 Posts

Posted - 2010-02-11 : 15:01:44

Here's my problem. I can't get a connection going.

Here are the steps I'm taking:

1) Login to the server with SQL Server 2008 installed, using a domain admin account.

2) Open SQL Server Management Studio.

3) Connect to the local server using Windows Authentication.

4) Right-click on Databases. Select New Database... Enter TestDB for the Database name. Click OK
...TestDB appears under Databases

5) Expand Security. Right-click on Logins. Select New Login... Enter TestUser for the Login name.
...Select SQL Server authentication. Put P@$$w0rd! in both password fields.
...Remove check from Enforce password expiration. Select TestDB for the Default database.

6) Select User Mapping in the Select a page pane. Put a check in the Map column, next to TestDB.
...TestUser appears in the User column.
...Put a check next to db_owner in the Database role membership for: TestDB pane. Click OK.

7) Close SQL Server Management Studio and re-open it.

8) At Connect to Server, select SQL Server Authentication in the Authentication drop-down.
...Enter TestUser as the Login. Enter P@$$w0rd! as the Password. Click Connect.

...The error message appears:

Connect to Server
Cannot connect to ServerName.
ADDITIONAL INFORMATION:
Login failed for user 'TestUser'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

I apologize for my lack of knowledge and understanding. I was born that way.

Thank you from a SQL Server 2008 neophyte.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-11 : 15:13:33

Connect with the windows account again.

Right-click database instance, click properties. Go to security tab. Under Server Authentication, is SQL Server And Windows Authentication mode checked?

RBurr
Starting Member

3 Posts

Posted - 2010-02-11 : 15:34:13

After right-clicking the database and opening the Properties box, I have the following pages listed in the left pane:

General
Files
Filegroups
Options
Change Tracking
Permissions
Extended Properties
Mirroring
Transaction Log Shipping

I don't see a Security tab.

Thank you from a SQL Server 2008 neophyte.

RBurr
Starting Member

3 Posts

Posted - 2010-02-11 : 15:42:14

I'm not sure of the navigation steps to get to the Security page (as it doesn't seem at all obvious to me), but I found it and that DID allow me to login. Hope I can do it again with a REAL database.

Thank you, Russel.

Thank you from a SQL Server 2008 neophyte.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-11 : 19:25:31

It's because you right-clicked the database, not the server/instance

but you found it. Glad it helped

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources