• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1128
  • Last Modified:

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.
0
Steve_Rogers
Asked:
Steve_Rogers
  • 3
  • 2
1 Solution
 
imran_fastCommented:
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.
0
 
Steve_RogersAuthor Commented:
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.
0
 
Steve_RogersAuthor Commented:
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
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
imran_fastCommented:
Ok the user by which the services are running should be Administrator on the Machine and should have sysadmin access on sql server.
0
 
Steve_RogersAuthor Commented:
Issue has been resolved had nothing to do with users.  Found problem to be binary data fields within fields.
0
 
Computer101Commented:
PAQed with points refunded (125)

Computer101
EE Admin
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now