Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Command text was not set for the command object Expand / Collapse
Author
Message
Posted Wednesday, August 5, 2009 3:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
hi

can any body tell me
why i am getting below error ??

OLE DB provider "SQLNCLI" for linked server "MyMirror" returned message "Command text was not set for the command object.".
Msg 7215, Level 17, State 1, Line 207
Could not execute statement on remote server 'MyMirror'.



this error , i m getting while establishing mirroring between two SQL instances .






-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #765318
Posted Wednesday, August 5, 2009 4:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 5, 2014 12:03 AM
Points: 140, Visits: 310
I didnt experience such, but just make it sure that your network is going well, linked server is accessible of that user that is mentioned in linked server. you can test your linked server by writing a query. and your remote connections are enabled on your server.

Best of luck.
Post #765329
Posted Wednesday, August 5, 2009 8:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 9:15 AM
Points: 21, Visits: 9
I've seen you've been having a few problems. What OS is this running on?
Post #765515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse