asked on

Metadata query failed

I am running SQL 2005 on 2 seperate servers. I am attempting to do a Snapshot replication from Server A which is setup as a publisher and distributor. Server A is suppose to pushe the subscription to server B. When attempting to create the intial snapshot I recive and error that reads metadata query failed. Any help would be appreciated.

imran_fast

Try creating two snapshots with different set of tables. and apply service pact 1 on both server if not there. also check that the user by which your sql agent is running and mssql service is running is same.

Steve_Rogers

ASKER

I have tried creating a snapshot of individual tables including a few of the tables that the snapshot hsa blown up on before and it creates fine. The server is currently running MS SQL 2005 sp2 so I am already past service pack 1. The agent and service are both running using an SQL service account set up in AD.

Steve_Rogers

ASKER

Below is an export from the error log, i am hoping that the additional detail will help.

04/03/2007 10:49:11,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,2,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Run agent.,,2007-04-03 14:49:21.41 Source: Replication<nl/>2007-04-03 14:49:21.41 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.41 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.41 Message Code: 0<nl/>2007-04-03 14:49:21.41 <nl/>2007-04-03 14:49:21.41 [88%] The replication agent had encountered an exception.<nl/>2007-04-03 14:49:21.41 Source: Replication<nl/>2007-04-03 14:49:21.41 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.41 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.41 Message Code: 0<nl/>2007-04-03 14:49:21.41 <nl/>2007-04-03 14:49:21.47 [88%] The replication agent had encountered an exception.<nl/>2007-04-03 14:49:21.47 Source: Replication<nl/>2007-04-03 14:49:21.47 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.47 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.47 Message Code: 0<nl/>2007-04-03 14:49:21.47,00:00:15,0,0,,,,0
04/03/2007 10:49:11,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,2,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Run agent.,,The replication agent has been successfully started. See the Replication Monitor for more information.,00:00:00,0,0,,,,0
04/03/2007 10:49:10,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,1,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Snapshot Agent startup message.,,Executed as user: BEACHSYS\rtw. The step succeeded.,00:00:01,0,0,,,,0

imran_fast

Ok the user by which the services are running should be Administrator on the Machine and should have sysadmin access on sql server.

Steve_Rogers

ASKER

Issue has been resolved had nothing to do with users. Found problem to be binary data fields within fields.

ASKER CERTIFIED SOLUTION

Computer101

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial