February 6, 2009 at 11:40 am
I read the book called "Pro SQL Server 2005 Replication" to learn how to configure web synchronization. I followed the steps in Chapter 12, but when the book (on page 514) asks you to access the "SQL Websync diagnostic information" website, the website doesn't show anything. The error is "The page cannot be displayed. There is a problem with the page you are trying to reach and it cannot be displayed . . .HTTP 500 - Internal server error ." Does anyone know why that is?
February 7, 2009 at 9:00 am
start here http://msdn.microsoft.com/en-us/library/ms152511(SQL.90).aspx
and check the application event logs to see what the generic 500 error related to.
February 9, 2009 at 8:38 am
I'm also using IIS 5.1. Do you think that would be one of the reasons why the page does not load? If so, then where do I download IIS 7.0?
February 9, 2009 at 9:02 am
What's the URL you're linking to internally? Or is this external?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 9, 2009 at 9:04 am
No.
If you have a box with 5.1, I doubt it would be suitable for 7, but the link above references 6.
IIS is native to the server version, IIS6 requires (or is part of) windows 2003.
IIS is part of the windows components in add remove programs. Not downloadable as such.
http://www.iisanswers.com/IISFAQ.htm
Have you been through each and every, note, comment and step highlighted in the above link.
I'm sure all the info you will need is contained in the above link
e.g.
Web synchronization uses a computer that is running Microsoft Internet Information Services (IIS) to synchronize pull subscriptions to merge publications. IIS version 5.0 and II version 6.0 are supported.
Also, do you have the correct version of .Net. Have you checked the windows/application logs.
February 9, 2009 at 9:09 am
Sorry, No was in response to:
I'm also using IIS 5.1. Do you think that would be one of the reasons why the page does not load? If so, then where do I download IIS 7.0?
February 9, 2009 at 9:49 am
What's the URL you're linking to internally? Or is this external?
What do you mean by internal or external?
Have you been through each and every, note, comment and step highlighted in the above link.
Which link do you mean? Do you mean http://msdn.microsoft.com/en-us/library/ms152511(SQL.90).aspx ?
Also, do you have the correct version of .Net
Yes.
Have you checked the windows/application logs
What am I looking for in these logs?
February 9, 2009 at 10:06 am
Yes: http://msdn.microsoft.com/en-us/library/ms152511(SQL.90).aspx
And your looking for errors or warnings corresponding to when you receive the generic 500 error.
In the windows application event viewer (on the server running the application in IIS).
Until you can get to an actual event error with info relating to the problem it will be difficult to provide much help.
February 9, 2009 at 10:17 am
NotManyPoints (2/9/2009)
Yes: http://msdn.microsoft.com/en-us/library/ms152511(SQL.90).aspx
Do I need IIS 6.0 in order to do those steps?
I did every step in that website except these steps.
4. Create an application pool in Internet Information Services (IIS) Manager:
1. Click Start, and then click Run.
2. In the Open box, type inetmgr, and then click OK.
3. In Internet Information Services (IIS) Manager, expand the local computer node.
4. Right-click Application Pools, point to New and then click Application Pool.
5. Enter a name for the pool in the Application pool ID field, and then click OK.
5. Associate the account with the application pool:
1. In Internet Information Services (IIS) Manager, expand the local computer node, and then expand Application Pools.
2. Right-click the application pool that you created, and then click Properties.
3. In the Properties dialog box, on the Identity tab, click Configurable.
4. In the User name and password fields, enter the account and password that were created in step 1.
5. Click OK.
6. Associate the application pool with the virtual directory that is used for Web synchronization:
1. In Internet Information Services (IIS) Manager, expand the local computer node, and then expand Web Sites.
2. Expand the Web site that you are using for Web synchronization, right-click the virtual directory that you created for Web synchronization, and then click Properties.
3. On the Virtual Directory tab of the Properties dialog box, from the Application pool drop-down list, select the application pool that was created in step 5.
4. Click OK.
Do I really need to do those steps to get it working?
I tried to do this step "Right-click Application Pools, point to New and then click Application Pool" but I don't see "Application Pools" anywhere in the Internet Information Services (IIS) Manager.
And of course I can't pass this step
At the Subscriber, in Internet Explorer, connect to the server in diagnostic mode by appending ?diag to the address for the replisapi.dll. For example: https://server.domain.com/directory/replisapi.dll?diag.%5B/quote%5D
because that's my main problem. But I did something different in that step. I used https://computer name/directory/replisapi.dll?diag. Would that be a reason why it's not working?
I also don't see any errors corresponding to the generic 500 error in the windows application event viewer logs.
February 9, 2009 at 1:11 pm
I think I know why it's not working. According to this website
http://www.codefixer.com/tutorials/installation.asp
it tests whether IIS is working or not. But when I try to type in this site in IE
it doesn't give me any website (what should happen is that I "should see some Microsoft information on IIS if it's working correctly", but I don't see it). Since IIS is not working for me, would that be a reason that I can't access the "SQL Websync diagnostic information" website?
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply