Post reply

Install SP fails

  • May 19, 2006 at 10:14 am

    #172572

    I have a sp that SELECTs from other SQL server

    select * from SERVERNAME.DBNAME.dbo.TABLENAME

    I login in QA (other server) and try to install the SP

    I get the error:

    Server: Msg 18456, Level 14, State 1, Line 1

    Login failed for user 'sa'.

    I get the same if I only try to run the select .

    sa login is the same in all SQL servers

    What should I check ?

    Thanks

  • May 19, 2006 at 11:54 am

    #639066

    Is the server using Mixed Mode authentication or Windows Only? If it's set for Windows Only, then the SA login is disabled.

    -SQLBill

  • May 20, 2006 at 2:15 am

    #639115

    Windows and SQL

    Service is started under Windows account which also 'owns' all SQL servers

    I get the same error while connected with that windows account

    Server: Msg 18456, Level 14, State 1, Procedure TrxSp, Line 120

    Login failed for user 'sa'.

    I found it strange

  • May 22, 2006 at 7:54 am

    #639230

    Which version do you have?

    Run this:

    SELECT ServerProperty('Edition'),

    ServerProperty('ProductLevel'),

    ServerProperty('ProductVersion')

    -SQLBill

  • May 23, 2006 at 12:19 pm

    #639572

    Enterprise Edition

    SP4

    8.00.2039

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply