Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Cannot Configure Distribution

Author  Topic 

ray.ragan
Starting Member

13 Posts

Posted - 2008-01-28 : 16:10:23
Forum,

I cannot create a Distribution Server on SQL Server 2005 SP1. When I right click on Replication and click "Configure Distribution" and hour glass appears for a minute, and then nothing happens.

I get the same result if I try to create a publication.

Any suggestions on what to do?

Thank you!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-28 : 20:42:21
Apply sp2 and fixes then try again. By the way, did you logon as sysadmin?
Go to Top of Page

ray.ragan
Starting Member

13 Posts

Posted - 2008-01-29 : 12:06:32
Done, but I'm still encountering the problem.

I right click on Replication, click on Configure Distribution. I get an hour glass for about two minutes. And then nothing happens.

quote:
Originally posted by rmiao

Apply sp2 and fixes then try again. By the way, did you logon as sysadmin?

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-29 : 23:08:50
Do you have proper permission? What's sql edition?
Go to Top of Page

ray.ragan
Starting Member

13 Posts

Posted - 2008-01-30 : 11:03:46
quote:
Originally posted by rmiao

Do you have proper permission? What's sql edition?



I logged in as sa, and the Configuring distribution dialog still fails to load.

Here's the full version string:
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Go to Top of Page
   

- Advertisement -