January 4, 2012 at 11:54 pm
Hi
I'm trying to get an example working where a database talks to another database in another network. We were able to get it working in the same server but we are struggling from one server to the other.
Please can somebody point me towards a working tutorial or some key words that I can search for that will get this working.
PS : We haven't yet integrated anything into a live system yet, we just trying to get the message to the que on the other server. The databases are each completely empty
Thanks in advanced 😀
The Fastest Methods aren't always the Quickest Methods
January 5, 2012 at 12:47 am
Have you tried the Linked Server approach?
http://msdn.microsoft.com/en-us/library/ms190479.aspx
"Often speak with code not with word,
A simple solution for a simple question"
January 5, 2012 at 1:03 am
We haven't. Will try that now. Thanks
The Fastest Methods aren't always the Quickest Methods
January 5, 2012 at 2:40 pm
As Lutz has mentioned, if you are going down the service broker road, I believe you'll need to look at setting up routes to facilitate messaging between servers:
Check this as well as the blog suggested by Lutz
January 5, 2012 at 2:43 pm
I am not sure if it works or not, but one of the big reasons to use service broker is in fact to get away from linked server hell. I would have to disagree with that recommendation.
There's a step by step tutorial on setting up every generic use case of a SSB process in Books online. The thrid one is the one you want to look at ( conversation between two instances)
Link to the online version of BOL's page for SSB tutorials is here:
msdn.microsoft.com/en-us/library/bb839489.aspx
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 5, 2012 at 4:41 pm
Thank you 😀
The Fastest Methods aren't always the Quickest Methods
January 6, 2012 at 3:44 am
Hi All
I think I'm getting closer. I'm getting the error below now on the target machine. When I google the error it's bringing up a lot of links on database miroring. I am a SQL Admin and a network Admin.
Date 1/6/2012 12:41:13 PM
Log SQL Server (Current - 1/6/2012 12:41:00 PM)
Source Logon
Message
Service Broker login attempt by user 'NOLOGO\GORDONPC$.' failed with error: 'Connection handshake failed. The login 'NOLOGO\GORDONPC$' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 10.100.1.61]
I tried to execute
GRANT CONNECT ON ENDPOINT::InstInitiatorEndPoint TO [NOLOGO\Gordon];
as it was one of the links I came accross but received the following message
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
One again thank you for your help
The Fastest Methods aren't always the Quickest Methods
January 8, 2012 at 4:32 am
BinaryDigit (1/6/2012)
...I tried to execute
GRANT CONNECT ON ENDPOINT::InstInitiatorEndPoint TO [NOLOGO\Gordon];as it was one of the links I came accross but received the following message
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
One again thank you for your help
It might be a silly question but did you login as ‘NOLOGO\Gordon’ when issuing grants?
January 8, 2012 at 10:17 pm
yes I did. I found out later and I think I might be right with this. My user was already associated with the objects as the owner so the error was maybe a bit miss leading. 🙂
The Fastest Methods aren't always the Quickest Methods
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply