Re: SQL Server User

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks Ekrem,

user login is already exist in database and its working with other DB.

I have found a way to fix this issue

sp_dropuser ...
sp_adduser ...
assign role to user

and after doing this its working

Thanks & Regards
Manoj Jangid

"Ekrem Önsoy" <iletisim@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EA6C890D-CDCC-4B88-B466-298C73AAC58A@xxxxxxxxxxxxxxxx
Hi Manoj,

Backup\Restore is a database level operation, but you need a valid Login to log in to your SQL Server and Logins are server level principals. So, you need a valid Login which is mapped to your User object in your database so that your user can log in to the SQL Server instance using that Login and Database User.

--
Ekrem Önsoy


"Jangid" <manojjangid@xxxxxxxxxxx>, iletisinde sunu yazdi, news:B94B15F3-BB7D-4814-BD62-D571D130E81F@xxxxxxxxxxxxxxxx
Hello everyone,

I have a user & role in sql server, role is assigned to user and I did a
backup of database. [e.g. myuser & myrole]
I restored the database in another sql server, version is same for both sql
server.

now I am not able to access database with myuser in sql server where I
restored DB, while I am able to access with sa. myuser & myrole also exist
in database

what other settings or information I need to provide in restored database
for myuser?
I am using SQL 2005 standard edition


Kind Regards
Manoj Jangid

.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)