Re: Can't login to SQL Server

Klerman Gutierrez (mcs@xxxxxxxxxxxxxxxxxxxxxxxx) writes:
I'm trying to migrate one SQL Server 2000 database to SQL Server Express,
and I'm having the following issue.
In the SQL Server 2000 database I have two users A and B. User A belongs
to the sysadmin server fixed role, and user B belongs to the
db_datareader and db_datawriter database roles.
In SQL Server 2000, all works as expected, but in SQL Express I can't
login with the user B to the SQL Server.
The SQL Server Express database is in a Windows Vista machine, and the
security mode is SQL authentication.
Can you point me to the solution of this problem ?

Are A and B SQL logins or Windows logins?

Do you connect locally, or from a remote machine?

How you connect? From the application? From a query tool?

What error message do you get?

How did you perform the migration? Did you upgrade the entire instance,
or did just move the database with backup/restore, dettach/attach or
used the Copy Database Wizard? If you only copied the database, did
you also add the logins to the SQL 2005 instance, and remapped the
users after the move?

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Problem with SQL Server 2005 Express Edition
    ... Use of included script samples are subject to the terms specified at ... One cause for that error is trying to use a SQL Server login on a database server that is configured to only accept Windows logins. ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Re: Master database must never be the default database for any login
    ... let's say that I want TEMPDB as my default database for all logins ... Is it possible I configure SQL Server to set a default database other ... MASTER to any logins created automatically? ...
    (microsoft.public.sqlserver.security)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help Ive been an idiot
    ... You need to make sure that you readd any logins that were mapped to database ... Jasper Smith (SQL Server MVP) ... > connectionString, CommandType commandType, String commandText, ...
    (microsoft.public.sqlserver.setup)