Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Jan 18, 2000

SQL Server Replication Overview

By Kevin Goodwyn

REPLICATION ERRORS\RESOLUTIONS

1. Error:

The following error message occurred on ServerP (Publisher) for the Distribution Task: “3700 [Microsoft][ODBC SQL Server Drvier] [SQL Server] Login Failed – User: Reason: Not associated with a trusted SQL Server connection.”

Resolution:

Define the NT Login (ex. Sqlnt) as a trusted connection on both servers. Execute the following SQL Statement; xp_grantlogin ‘Administrators’, ‘admin’.

2. Error:

The following error message occurred when starting the MSSQLServer Service with the NT Login: “Can not set the startup parameters for the MSSQLServer Service. Error 1057 occurred: The account name is invalid or does not exist.”

Resolution:

Retype the password for the NT Login and then start the service.

3. Error:

The following error message occurred when trying to go into the SQL Security Manager on both Servers: “This SQL Server does not support Windows NT SQL Server security stored procedures.”

Resolution:

Refer to Knowledge Base Article Q164167. Had to return SA privileges to the local Administrators group via editing the Registry.

4. Error:

On ServerS (Subscriber) under Manage Subscriptions, Selected the Publications Server, and Clicked on the More Info. Button and the following error message occurred: “Unable to connect to site ‘ServerP’ because ‘SA’ is not defined as a remote login at the site.”

Resolution:

Check Remote Server Logins by selecting the Server Menu Item and Remote Servers. Also, verify the connection to the Remote Server in SQL Enterprise Manager.

5. Error:

On ServerP for the Distribution Task the following error message occurred: “The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 9.

Resolution:

The Job ID in the MSSubscriber_Status table (Distribution Database) on ServerP should match the Job ID in the MSLast_Job_Info (Pubs Database) table on ServerS. There were zero rows in the MSSubscriber_Status table and in the MSLast_Job_Info table the Job ID was set to 9. So, the solution was to set the Job ID to zero on the MSLast_Job_Info table (Pubs Database) on ServerS. This was done with the following Update Statement:

Update MSLAST_JOB_INFO
    Set Job_ID = 0
    Where Publisher = ‘ServerP’
    And Publisher_db = ‘Pubs’

6. Error:

On ServerP while creating a new database device the following error occurred: “Error 5123:[SQL Server] DISK INIT encountered an error while attempting to open/create the physical file. Please consult the SQL Error Log [in the SQL boot directory] for more details.” This occurred after the devices were deleted and an attempt was made to recreate them. Check the SQL Error Log. It states that the files exist. The message in the log is “udcreate: o/s error 80 (The File Exists) encountered.”

Resolution:

Created the device with a different name.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM