I am building tables using the database diagram with enterprise manager. One of the options available is to "Cascade Update and Delete Related Fields". I think this means that if I change a PK Identifier in a table all related FK's will be updated to the new value and if I delete the PK all related FK records will be deleted. Is this correct? Is this a good idea to do something like this?
I have always handled what needs to be changed using SP's following business rules. A friend has been preaching the use of the "Cascade Update and Delete Related Fields" functionality provided with the database.
Please let me know what you think.
ThanksAs you already mention, I think this is a matter of opinion. The advantage for cascading is that you don't have to do any checking and programming to avoid data inconstency. Disadvantage is that you don't have any control about the updates/deletes of the related records. For the manual programming through sp's it's offcourse the other way around.
In other words: you have to see in every situation what's the best solution.
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Thursday, March 8, 2012
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.
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.
cant use replication
ive installed sql 2005 enterprise and wanted to make a replication between 2 servers but when i rightclick the replication folder in the server management studio express - i can only create a subscriber. ive also tried going through tools but theres nothing in that menu.
in this case i need a different version of management studio?
where can i get it from? i havent got a cd - i downloaded it from the microsoft homepage
and when i click that, it tells me that it needs a publisher
|||
nothing else (ive read through the rest of the theory)
ive wondered, is it maybe possible the i cant create a publisher because of the management studio express - do i also need a enterprise edition of the management studio?
ive also checked in add and remove programs - went to mssql 2005 and checked in change components and in there it ses that the replication components are installed =/
wud b gr8 if u cud help me, need this for an egsam i got on the 18th
thank you very very much in beforehand =P
sql server 2005 express edition only supports as subscriber...
May either you have connected to express edition sql server or ssms express may not support...
You may need to install regular client components from EE/SE/DE edtions cd...
Check the following link for SQL Server 2005 Features Comparison...
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
|||ive got the enterprise odition of mssql its just the management studio that is express.in this case i need a different version of management studio?
where can i get it from? i havent got a cd - i downloaded it from the microsoft homepage
can someone PLEASE help me out here? even if its a "i doubt that it will work" =/
|||
Hi eniGMa,
You have to configure the Distributor firstly and then the Publisher.
Go to the Instance that you want to set Replication up. Right click on the Replication folder and click "Configure Distribution...".
After configuring the Distribution, configure the Publisher. Go to the Replication folder and click the + sign near it and expand the folder. Right click on the Local Publications folder and then click "New Publication" after setting it up you may configure the necessary Publications to Subscribers.
For more information visit the MSDN:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx
Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE
|||hi, ive checked the msdn page - the only thing i can create is a subscriber, nothing elseand when i click that, it tells me that it needs a publisher
|||
Hi eniGMa,
Replication system consists of Publisher, Distributor and Subscriber.
Publisher is the one what hosts the publications.
Distributor is the one which publishes the publications (from Publisher) to Subscribers.
Subscriber is the one what pulls (or pushed by the Publisher) data from Distributor.
Distributor and Publisher may be host on the same server if there is not huge workload on that SQL Server.
So according to this frame, you need to set Publisher and Distributor first.
You may configure these by help of the MSDN page which i posted before.
And then read my prior first answer again.
Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE
nothing else (ive read through the rest of the theory)
ive got the enterprise edition of mssql server installed, only thing where it sais express is the management studio (which i cant install from the sql server installation file, so i downloaded it from download.microsoft.com)
when i rightclick the replication folder - subscriber (no publisher and no distributor)
and when i click on tools (same thing)
|||
I see that you misconfigured setup of SQL Server.
Because you can install SSMS (SQL Server Management Studio) from the Components to Install menu which appears when you were setting up SQL Server.
When you see Components to Install dialog box, click Advanced and dig into the items to be installed.
After opening Advanced dialog box, you will see: "Workstation Components, Books Online, and Development Tools" There is SSMS in it. Expand the item and you'll see it.
My concern about your Replication problem is, you may be deselecting or forgetting selecting something when you were setting up the SQL Server. Replication choice is in the "SQL Server Database Services" item in the same Advanced dialog box.
Please check these items carefully while setting up SQL Server.
Try to set SQL Server up again by taking care of these things.
Ekrem ?nsoy
MCP, MCDST, MCDBA, MCAD.Net, MCSD.Net, MCSA, MCSE|||that worked - maybe it didnt work on the 1st time because ssms express was installed, when i installed it the 1st time and then i couldnt install it as an additional installation, even if removed afterwardsthnx a LOT!
Subscribe to:
Posts (Atom)