Login problem

From: Ragnar Midtskogen (ragnar_ng_at_newsgroups.com)
Date: 04/28/05 

Date: Wed, 27 Apr 2005 18:26:55 -0400

Hello,

I have two servers where the SQL Server DB provides the data for a Web site.
One server is the live Web server, the other one will serve as a backup.

I use an ODBC connection to conect to SQL Server, and there are a number of
asp pages that connect the SQL Server using SQL Server authentication.

Recently I restored the website DB on the backup server with a full backup
file from the live server and now the asp pages can not connect any more.
When I try to configure the ODBC connection I also get a message that
connection failed.
If I switch to Windows authentication in the ODBC manager I can connect and
the DB tests out successfully.

I tried editing the password but when I try to save it I get the message
that the userid already exists.
I also tried deleting the userid and adding it back in, but I get the same
message, that userid already exists.

I have just transferred another backup from the live server and it includes
a backup of the master, model and msdb DB's. I am hoping that restoring all
from this backup will correct the problem, but I am not an experienced DBA,
so I am not sure

Any suggestions as to how I could fix this problem would be appreciated, our
live server is acting up so we may need to switch.

Ragnar

Relevant Pages

  • Re: Clustered SQL servers in DR Hotsite
    ... the initial synch involves taking a full backup. ... SQL Server MVP ... I have to bring up a second set of clustered SQL servers at a DR Hotsite. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Access Database to SQL
    ... Migrating the Application to Client / Server, ... MSDE will do -nothing- to alleviate any Backup problems you have. ... magically shrink because you port it to SQL Server. ... If you're having problems backing up SBS 2000 then post the exact ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: backup/restore ?
    ... 0F2485C5 CRI ... 00001B90 Connected to SQL Server ... 0F248884 CRI 80040C81 00001B90 Leaving SQL Backup ... See the SQL Server error log for more details. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Backing up Databases using SQLServer
    ... Backup to UNC name using Database Maintenance Wizard ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)