SQL Server User

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

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

  • SQL Server User
    ... I restored the database in another sql server, version is same for both sql ... now I am not able to access database with myuser in sql server where I ... myuser & myrole also exist ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server User
    ... 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. ... now I am not able to access database with myuser in sql server where I ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server User
    ... 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. ... 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. ... now I am not able to access database with myuser in sql server where I ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Session State
    ... It's solved after I made 'myuser' db_owner for the ASPState database ... Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. ... You need to create a user account "MyUser" in SQL server. ... "Cannot open database "ASPState" requested by the login. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)