Tuesday, February 14, 2012

Can't view merge agent properties (trying again)

In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents ->
Merge Agents] you'll see a list of Merge Agents to the right.
I'd like to be able to select one of the items, right-click, and select
"Agent Properties".
When I do this, I get a dialog box that appears. The title of the dialog is
"Connect to SQL Server". It's looking for "Connection Information" and it
wants a Login name and Password.
Well, my SQL Server uses the sa user. So, I tried the sa user and it's
password. Nope!
The SQL Server Agent runs under a windows account. I tried that ID and it's
password. Nope!
The other strange thing about this is that my friend doesn't have this
problem on his laptop/SQL Server. He can view the agent properties no
problem. One difference we can detect is that his SQL Server uses a Windows
Account and mine uses sa. Not sure if that makes a difference.
I also went to [Security -> Logins] and added a new login and gave him every
available permission I could find (using the SQL Server Login Properties
Tabbed Dialg). I tried logging on with this guy. Nope!
So, sa doesn't work. The SQL Server Agent windows ID doesn't work. The new
Login guy didn't work. Ummm. What exactly is it looking for? But for some
reason, if I enter the ID and password I get the same MsgBox:
SQL Server Enterprise Manager
A connection could not be established to XXXX [3023].
Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())..
Please verify SQL Server is running and check your SQL Server registration
properties (by right-clicking on the XXXX [3023] node) and try again.
Thanks in advance,
William Campbell
Hi.
Maybe I mis-read the msdn web page, but I am reading this (about managed
newsgroups):
a.. Unlimited on-line technical support - keep your PSS incidents
a.. A commitment to respond to your post within two business days
The thing is, this hasn't happened. Did I incorrectly enter my post
somehow? It's been more than 2 business days.
Thanks,
William Campbell
"MSDN-Managed" <NO_SPAM> wrote in message
news:9DB1BD5B-54AA-4CA9-BD40-48084F121F8A@.microsoft.com...
> In Enterprise Manager (EM), if you go to: [Replication Monitor ->
Agents ->
> Merge Agents] you'll see a list of Merge Agents to the right.
> I'd like to be able to select one of the items, right-click, and select
> "Agent Properties".
> When I do this, I get a dialog box that appears. The title of the dialog
is
> "Connect to SQL Server". It's looking for "Connection Information" and it
> wants a Login name and Password.
> Well, my SQL Server uses the sa user. So, I tried the sa user and it's
> password. Nope!
> The SQL Server Agent runs under a windows account. I tried that ID and
it's
> password. Nope!
> The other strange thing about this is that my friend doesn't have this
> problem on his laptop/SQL Server. He can view the agent properties no
> problem. One difference we can detect is that his SQL Server uses a
Windows
> Account and mine uses sa. Not sure if that makes a difference.
> I also went to [Security -> Logins] and added a new login and gave him
every
> available permission I could find (using the SQL Server Login Properties
> Tabbed Dialg). I tried logging on with this guy. Nope!
> So, sa doesn't work. The SQL Server Agent windows ID doesn't work. The
new
> Login guy didn't work. Ummm. What exactly is it looking for? But for
some
> reason, if I enter the ID and password I get the same MsgBox:
> --
> SQL Server Enterprise Manager
> --
> A connection could not be established to XXXX [3023].
> Reason: SQL Server does not exist or access denied.
> ConnectionOpen (Connect())..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right-clicking on the XXXX [3023] node) and try again.
> Thanks in advance,
> William Campbell
>
|||The problem appears to be that you're not using a posting alias that you've
registered with MSDN. You can start that process using the Register link on
this page: http://msdn.microsoft.com/newsgroups/managed/. The MSDN team that
monitors this newsgroup looking for those posts is using a tool that points
out the posts from Managed Customers and your posting address isn't
appearing as one.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
news:OWjeHj%232EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Hi.
> Maybe I mis-read the msdn web page, but I am reading this (about managed
> newsgroups):
> a.. Unlimited on-line technical support - keep your PSS incidents
> a.. A commitment to respond to your post within two business days
> The thing is, this hasn't happened. Did I incorrectly enter my post
> somehow? It's been more than 2 business days.
> Thanks,
> William Campbell
> "MSDN-Managed" <NO_SPAM> wrote in message
> news:9DB1BD5B-54AA-4CA9-BD40-48084F121F8A@.microsoft.com...
> Agents ->
> is
> it's
> Windows
> every
> new
> some
>
|||Hmm. But I did. The "MSDN-Managed" newgroup post (the original, not the
one with my name) is using the ID that is registered with our Universal
subscription.
I went to the link you mentioned (a few days ago), made sure that I gave our
ID an alias so that our email address didn't appear (thus, the alias
MSDN-Managed and the "NO_SPAM" email address). And submitted the post
through the web interface from the same link you displayed (you sign-in
through that passport account to the web interface).
That's why I'm confused. I went through all the steps. The one from
"MSDN-Managed" (not "William Campbell") is using our subscription id.
William Campbell
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uRWmYw%232EHA.2788@.TK2MSFTNGP15.phx.gbl...
> The problem appears to be that you're not using a posting alias that
you've
> registered with MSDN. You can start that process using the Register link
on
> this page: http://msdn.microsoft.com/newsgroups/managed/. The MSDN team
that
> monitors this newsgroup looking for those posts is using a tool that
points
> out the posts from Managed Customers and your posting address isn't
> appearing as one.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> Please reply to the newsgroups only, thanks.
> "William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
> news:OWjeHj%232EHA.2540@.TK2MSFTNGP09.phx.gbl...
dialog[vbcol=seagreen]
Properties[vbcol=seagreen]
The
>
|||Hmm, I'll have a chat with the manager of that team then, as our internal
tool clearly isn't picking it up, and get somebody to look at your post.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
news:ud31bc$2EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hmm. But I did. The "MSDN-Managed" newgroup post (the original, not the
> one with my name) is using the ID that is registered with our Universal
> subscription.
> I went to the link you mentioned (a few days ago), made sure that I gave
> our
> ID an alias so that our email address didn't appear (thus, the alias
> MSDN-Managed and the "NO_SPAM" email address). And submitted the post
> through the web interface from the same link you displayed (you sign-in
> through that passport account to the web interface).
> That's why I'm confused. I went through all the steps. The one from
> "MSDN-Managed" (not "William Campbell") is using our subscription id.
> William Campbell
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:uRWmYw%232EHA.2788@.TK2MSFTNGP15.phx.gbl...
> you've
> on
> that
> points
> rights.
> dialog
> Properties
> The
>
|||Is there a timeframe for this? It's been a few days (and 8 days since my
initial post under this "Msdn-Managed" ID).
Are you saying that this ID that I'm posting under right now ... doesn't
show up as someone with a Universal account? Currently I'm at the web
interface. I'm signed in. Next to the Sign In/Sign Out button is another
smaller button that you can edit a profile. I looked there and didn't see
anything that I could "check" or fill in that I didn't already.
This is the ID that we have associated with our Univeral account. So, I'm
confused. If it's not showing up as valid - can we take care of the issue so
that it does show up as valid? Because I'm not sure what else I can do here
- and It's been weeks since my initial post.
Thanks,
William Campbell
"Stephen Dybing [MSFT]" wrote:

> Hmm, I'll have a chat with the manager of that team then, as our internal
> tool clearly isn't picking it up, and get somebody to look at your post.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Please reply to the newsgroups only, thanks.
> "William Campbell" <NO_SPAM_AT_WILLIAM_CAMPBELL> wrote in message
> news:ud31bc$2EHA.3616@.TK2MSFTNGP11.phx.gbl...
>
>
|||Have you sent email to ngmsdnfb@.microsoft.com about this yet? The managers
of that team are on that alias and will get back to you fairly quickly. I'm
going to forward this along to them, but you might as well send them mail
yourself as well.
It doesn't look to me like you've followed the directions to set up a valid
posting address that can be recognized by our system and until you do so, I
believe that you're going to have this problem. Here are instructions for
registering:
1. Use the passport associated with your MSDN subscription to login at
http://msdn.microsoft.com/subscriptions/.
2. On the What's Hot tab, click the <here> link at the end of the first
paragraph of the "Unlimited Support" section, which takes you to the
registration page.
3. Pick a nickname and domain. For example, you could use johndoe for the
Nickname and @.nospam.nospam as the domain. Click the [Submit] button and it
should register johndoe@.nospam.nospam as your no-spam alias. That alias may
or may not be available. We are experiencing an intermittent problem with
this page where a link goes down and rejects all submissions. If the alias
you select gets rejected, please try waiting 10-15 minutes before trying
again.
When you successfully register we attempt to popup a page with more
information. It explains how to configure your profile, among other things.
If you have popups blocked, the link is:
http://msdn.microsoft.com/subscripti...gednewsgroups/
Once you've successfully registered your account, you'll need to start
posting using is, not the <NO_SPAM> address you used for this post.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"MSDN-Managed" <NO_SPAM> wrote in message
news:33FC6C3D-AF7D-4DAA-8E04-1C2E7944EC39@.microsoft.com...
> Is there a timeframe for this? It's been a few days (and 8 days since my
> initial post under this "Msdn-Managed" ID).
> Are you saying that this ID that I'm posting under right now ... doesn't
> show up as someone with a Universal account? Currently I'm at the web
> interface. I'm signed in. Next to the Sign In/Sign Out button is another
> smaller button that you can edit a profile. I looked there and didn't see
> anything that I could "check" or fill in that I didn't already.
> This is the ID that we have associated with our Univeral account. So, I'm
> confused. If it's not showing up as valid - can we take care of the issue
so
> that it does show up as valid? Because I'm not sure what else I can do
here[vbcol=seagreen]
> - and It's been weeks since my initial post.
> Thanks,
> William Campbell
> "Stephen Dybing [MSFT]" wrote:
internal[vbcol=seagreen]
rights.[vbcol=seagreen]
the[vbcol=seagreen]
Universal[vbcol=seagreen]
gave[vbcol=seagreen]
sign-in[vbcol=seagreen]
link[vbcol=seagreen]
team[vbcol=seagreen]
post[vbcol=seagreen]
Information"[vbcol=seagreen]
ID[vbcol=seagreen]
this[vbcol=seagreen]
properties no[vbcol=seagreen]
a[vbcol=seagreen]
him[vbcol=seagreen]
work.[vbcol=seagreen]
But[vbcol=seagreen]
again.[vbcol=seagreen]
|||William, would you please send me your email address at
stephd@.microsoft.com? I've been chatting with one of the managers of the
Managed Newsgroup support team and he'd like to talk to you directly. If
you'll send me your email address, I'll have him contact you.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:uhBxoGT4EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Have you sent email to ngmsdnfb@.microsoft.com about this yet? The managers
> of that team are on that alias and will get back to you fairly quickly.
I'm
> going to forward this along to them, but you might as well send them mail
> yourself as well.
> It doesn't look to me like you've followed the directions to set up a
valid
> posting address that can be recognized by our system and until you do so,
I
> believe that you're going to have this problem. Here are instructions for
> registering:
> 1. Use the passport associated with your MSDN subscription to login at
> http://msdn.microsoft.com/subscriptions/.
> 2. On the What's Hot tab, click the <here> link at the end of the first
> paragraph of the "Unlimited Support" section, which takes you to the
> registration page.
> 3. Pick a nickname and domain. For example, you could use johndoe for the
> Nickname and @.nospam.nospam as the domain. Click the [Submit] button and
it
> should register johndoe@.nospam.nospam as your no-spam alias. That alias
may
> or may not be available. We are experiencing an intermittent problem with
> this page where a link goes down and rejects all submissions. If the alias
> you select gets rejected, please try waiting 10-15 minutes before trying
> again.
> When you successfully register we attempt to popup a page with more
> information. It explains how to configure your profile, among other
things.
> If you have popups blocked, the link is:
> http://msdn.microsoft.com/subscripti...gednewsgroups/
> Once you've successfully registered your account, you'll need to start
> posting using is, not the <NO_SPAM> address you used for this post.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> Please reply to the newsgroups only, thanks.
> "MSDN-Managed" <NO_SPAM> wrote in message
> news:33FC6C3D-AF7D-4DAA-8E04-1C2E7944EC39@.microsoft.com...
my[vbcol=seagreen]
another[vbcol=seagreen]
see[vbcol=seagreen]
I'm[vbcol=seagreen]
issue[vbcol=seagreen]
> so
> here
> internal
post.[vbcol=seagreen]
> rights.
not[vbcol=seagreen]
> the
> Universal
> gave
post[vbcol=seagreen]
> sign-in
from[vbcol=seagreen]
id.[vbcol=seagreen]
message[vbcol=seagreen]
that[vbcol=seagreen]
> link
> team
that[vbcol=seagreen]
> post
Monitor ->[vbcol=seagreen]
the[vbcol=seagreen]
> Information"
and[vbcol=seagreen]
> ID
have[vbcol=seagreen]
> this
> properties no
uses[vbcol=seagreen]
> a
gave
> him
> work.
> But
> again.
>
|||Test - did this work? Hopefully it picks up my post now.
|||I still don't think you're following the directions. Your posting address
appears to be set to "NO_SPAM" and that is not one of the valid choices from
the registration page that I have pointed out a couple of times, there's no
domain listed. I'm including the directions again below. Please choose a
nickname and enter it in the nickname box (and it would be a very good idea
to make it more unique than "NO_SPAM" and then pick one of the domains from
the choose a domain drop-down list box. Then after as it's registered,
you'll need to use that full email address as your posting address. This
isn't a free service so we need to make it unique enough to ensure that
you're the only one using that alias.
1. Use the passport associated with your MSDN subscription to login at
http://msdn.microsoft.com/subscriptions/.
2. On the What's Hot tab, click the <here> link at the end of the first
paragraph of the "Unlimited Support" section, which takes you to the
registration page.
3. Pick a nickname and domain. For example, you could use johndoe for the
Nickname and @.nospam.nospam as the domain. Click the [Submit] button and it
should register johndoe@.nospam.nospam as your no-spam alias. That alias may
or may not be available. We are experiencing an intermittent problem with
this page where a link goes down and rejects all submissions. If the alias
you select gets rejected, please try waiting 10-15 minutes before trying
again.
When you successfully register we attempt to popup a page with more
information. It explains how to configure your profile, among other things.
If you have popups blocked, the link is:
http://msdn.microsoft.com/subscripti...gednewsgroups/
Once you've successfully registered your account, you'll need to start
posting using it, not the <NO_SPAM> address you used again for this post.
Mitch should be following up with you today via email.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"MSDN-Managed" <NO_SPAM> wrote in message
news:E42F00CD-59D8-493F-B94A-05737B1F8082@.microsoft.com...
> Test - did this work? Hopefully it picks up my post now.

No comments:

Post a Comment