Did you map the Login to your database?

--
Ekrem Önsoy - SQL Server MVP



"Pravin" <pravin (AT) nospam (DOT) com>, iletisinde sunu yazdi,
news:BADA3A7C-955E-4F15-88A3-E0D55ABAD62D (AT) microsoft (DOT) com...

I'm not sure how novice you are about SQL Server, however did you create the
mentioned Login using a GUI like SSMSE?

I assume you are not familiar with T-SQL so I'll try to show the way of
SSMSE to map your Login to your database...

Open up SSMSE and connect to your SQL Server instance, then in the Object
Explorer pane go to Security->Logins and then find the Login you created. Go
to its properties and you'll see User Mapping page in the left side list,
click it and you'll see the available databases. To map your Login to your
database, simply select the checkbox in the "Map" column which is in the row
of the database. You can add the user to some appropriate roles in the
following box in the same window. After completing your actions, close it by
clicking OK and now your Login is mapped to your database.

--
Ekrem Önsoy - SQL Server MVP



"Pravin" <pravin (AT) nospam (DOT) com>, iletisinde sunu yazdi,
news:uBECkNkAKHA.1488 (AT) TK2MSFTNGP03 (DOT) phx.gbl...

Hi,

I have installed Sql Server 2005 express edition as administrator of the
machine. I need to give access to end user who will be accessing it using
another account that is not given administrative priviledges. When I login
as end user then I cannot access the new DB created, though Sql Server 2005
management studio express is accessible but not the database created as
admin. I tried giving "grant all to public" as administrator but that didnt
help. Any suggestions?

Regards,
Pravin

No, I am not sure how to do the mapping mentioned here. Bit new to this
area, would be useful if you can shed some more details. Thanks for your
assistance.

Regards,
Pravin

Pravin (pravin (AT) nospam (DOT) com) writes:
First you create a login with CREATE LOGIN, and it appears you already
have done this.

Then you need, while in that database, create a user in that database for
the login in question. This is actually simple:

CREATE USER username

It is possible to give the user a different name in the database from
the login, but there's no reason unless you like pranks.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx