Command text was not set for the command object

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Command text was not set for the command...

Command text was not set for the command object

Rate Topic

Display Mode

Topic Options

Author

Message

Bhuvnesh

Posted Wednesday, August 05, 2009 3:56 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #765318

Noman Tariq

Posted Wednesday, August 05, 2009 4:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 4:01 AM
Points: 140, Visits: 292

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

kinsey1275

Posted Wednesday, August 05, 2009 8:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 02, 2009 5:14 AM
Points: 1, Visits: 3

I've seen you've been having a few problems. What OS is this running on?

Post #765515

« Prev Topic | Next Topic »

Permissions