Post reply

Replication fix with temp db

  • October 10, 2022 at 10:03 am

    #4097396

    Hello,

     

    I changed temp db from c drive to another drive, everythink ok on server,but my replication job is failing now,how can that be fix? Only temp db was changed,error message:

    Replication-Replication Transaction-Log Reader Subsystem: agent SQL-TEMP-RMCMSLogs-3 failed. Login failed for user 'sa'.

     

  • October 10, 2022 at 11:46 am

    #4097430

    I go to properties of replication and get this:

    SQL Server is unable to connect to server 'servername'.

    ------------------------------

    For help, click: https://go.microsoft.com:80/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.0.18424.0&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantConnect&LinkId=20476

    ===================================

    SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, ''. (Replication.Utilities)

    ------------------------------

    Program Location:

    at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.CheckServerAlias(ServerConnection conn)

    at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.Open()

    at Microsoft.SqlServer.Management.UI.LaunchPubPropSheet.PrepareToShow()

     

  • October 10, 2022 at 8:19 pm

    #4097655

    Makes me think it is file level permissions on the directory you put the tempdb files in.  Just a first thing to check - off the top of my head.  The service account the sql server is running as must have full permissions to that directory in the file system.

Viewing 3 posts - 1 through 2 (of 2 total)

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