URGENT:spsbackup.exe gives logon errors

Hot Topic

Division Problem
RS2000 - custom data extension from rpt svc launch page
SSMS-EE: Using Views T-SQL Error Messages 156 & 111
Updating report from stored procedure
MS Access & SQL Server 2005
HELP plz solve some Queries
ExecuteSQLTask
SQL Beginner
SQL Server 2005 stdevp function
Reporting Services 2005 Catalog table

SQL Server

Migration Maint Plns SQL Server 2005 ==> SQL Server 2005
Store Arabic Date into the table
Breakpoint doesn't work
where is the "render" method in 2005? Immediate help needed..!
Complex SQL query
Creating and Configuring Custom Conflict Resolver.
Problem when trying to deploy a web site built with asp.net 2.0 and using SQL EXPRESS
User return value of a SP in another SP (SQL Server 2000)
MDX calculated member - showing null values
Using Select Into

URGENT:spsbackup.exe gives logon errors

I am trying to Sharepoint Portal server with sql2005 on the normal everyday transactions everything works fine. However when we try to run SPS restore cannot we keep getting this error. This is VERY URGENT as we are trying to deploy a new site but cannot until issue is resolved. 'TWIG\Administrator' has already been given dbowner rights to all databases and can run backup but not restore.

Error Message:

Login failed for user 'TWIG\Administrator'. [CLIENT: 192.168.1.8]

Surely someone has tried this these are two very popular applications but unfortunately there is nothing in the sps site or sql2005 to help with this issue.

 

Please help and thankyou in advance




Answer this question

URGENT:spsbackup.exe gives logon errors

  • philipa

    Im sorry i do not know the connection string i am very new to sql i am an infrastructure engineer not developer in regards to  default database i believe it is the master dbase and i have already set dbowner permissions i am just trying to get spsabckup to work

     



  • Suki

    Take a look at your errorlog and post the error message as it appears there. Post the error number and state as well as the error message.

    Thanks
    Laurentiu



  • dev2005

    There are two common errors here they are:

    Date  2/05/2006 9:07:40 AM
    Log  SQL Server (Current - 2/05/2006 9:07:00 AM)

    Source  Logon

    Message
    Login failed for user 'TWIG\Administrator'. [CLIENT: 192.168.1.8]

     

    Date  2/05/2006 8:27:36 AM
    Log  SQL Server (Current - 2/05/2006 9:07:00 AM)

    Source  Logon

    Message
    Error: 18456, Severity: 14, State: 16.

     Thankyou



  • Shirajul Alam

    From the information you provided, this is the general issue: the database to be used by the connection cannot be determined.

    Have you attempted to connect to SQL Server as TWIG\Administrator using some other method, for example, sqlcmd If that succeeds, then the problem is in how the spsbackup application is connecting. For this, you should inquire on a site that covers spsbackup.

    Thanks
    Laurentiu



  • Sam Fasten

    Take a look at the following link and see if it helps:

    http://support.microsoft.com/Default.aspx id=831088

    If this doesn't help and you're seeing the same error 18456 with state 16, you should try getting help from a Sharepoint forum.

    Thanks
    Laurentiu



  • aprisoocc

    State 16 indicates that the server failed when attempting to determine the database that should be used after the connection. What is your connection string Also, what is the default database set for the TWIG\Administrator login

    Thanks
    Laurentiu



  • BBA

    hi,
    so ngocbich did u manage to solve ur problem

  • Jennifer Gamble

    Did you ever resolve this

    We are having the same issue, and the event log is consistently showing login failed errors for th euser account we run spsbackup under - all other methods of connection are fine. We also noticed that Veritas backup Exec cannot connect - and the error log throws up exactly teh same errors (login failed for user .....).

    Steve.
  • URGENT:spsbackup.exe gives logon errors
Answer this question