Re: Help I've been an idiot

You need to make sure that you readd any logins that were mapped to database
users in the attached databases. For the ASPNET login you can simply add it
back and it will automatically remap to the database user account (as they
will have the same SID). However for some logins you may need to do some
extra work, see the links below.

INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

<carriolan@> wrote in message
news:dd83k1hnfn38l1ebhfeov5gtde0svob3qb@xxxxxxxxxx
> Hi
> I am answering myself here. I have discovered that I have to attach
> them, but...................
> .................. SQL Server can see the databases with no problems.
> I launch the program in my browser using localhost and get the error
> message below. It was working perfectly under MSDE what do I do to
> correct it please?
> Regards Carriolan
> Mono Portal Engine
>
> An error has occured while processing your request. Please contact
> system administrator with the following information:
>
> Error description: System.Data.SqlClient.SqlException: Login failed
> for user 'ASTRALIS\ASPNET'. at
> System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction) at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> options, Boolean& isInTransaction) at
> System.Data.SqlClient.SqlConnection.Open() at
> Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String
> connectionString, CommandType commandType, String commandText,
> SqlParameter[] commandParameters) at
> Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String
> connectionString, CommandType commandType, String commandText) at
> MonoSoftware.MonoX.Portal.Global.Global_Error(Object sender, EventArgs
> e)
> On Mon, 03 Oct 2005 19:29:26 GMT, "carriolan@xxxxxxxxxxx" <carriolan@>
> wrote:
>
>>Need some help urgently. I was using MSDE and decided to upgrade to
>>SQL Server Developer Edition, so I de-installed MSDE and then
>>Installed SQL Sever Dev. I then copied my existing databases into the
>>data folder, but enterprise manager can't see them. How do I sort this
>>out please - Regards Carriolan


.

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: 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: Managing SQL database rights using AD
    ... logins to SQL Server. ... You would add these two logins you ... just added as users in the database. ... the Windows group that you just added as logins (and then ...
    (microsoft.public.sqlserver.security)
  • Re: How to move schedule jobs from one box to another during upgrade
    ... User information is stored in each database, so when you restore the databse ... possibility (for SQL logins which are NOT NT logins) is that the new SQL ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: Resynching DB Users after Restore
    ... accidental security breach due to a cross-server restore. ... this semi-automagically, especially if you have a small, known set of logins ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.security)