Server Error: An error occurred while retrieving the list of Datab

[Morgade1000]

I have been struggling with this error in Frontpage when connecting to both a
Portal and a WSS site. I am able to connect to a SQL server DB as long as it
is not a complex query on a WSS server(with a complex query it shows that it
is not valid xml) however, when I try the same connection on a Portal server
I get "Server Error: An error occurred while retrieving the list of
Databases".

Both servers are on the same subnet and I am a domain admin so I have full
access to both. In addition, I have created a web part that utilized a data
grid connecting to the Northwind DB on a SQL DB and it worked very well on
the Portal server. It has this issue wheter the authentication used to set up
the connection is windows or SQL. So the issue appears to be specific to
Frontpage and setting up a database connection.

I have seen the KB article 831092 which indicates that I should add a Proxy
entry in the web.config but we do not run a Proxy server on our network.

To try to troubleshoot the issue I have set up another wss site in a new
virtual server on the portal server and it gives me the exact same message.
Another Domain admin is able to exactly recreate the problem from his
workstation. I have also tried to connect to other SQL server DB on other
servers and get the same error.

 

[Stefan B Rusynko]

You may want to try a WSS newsgroups
news://msnews.microsoft.com/microsoft.public.sharepoint.windowsservices





|I have been struggling with this error in Frontpage when connecting to both a
| Portal and a WSS site. I am able to connect to a SQL server DB as long as it
| is not a complex query on a WSS server(with a complex query it shows that it
| is not valid xml) however, when I try the same connection on a Portal server
| I get "Server Error: An error occurred while retrieving the list of
| Databases".
|
| Both servers are on the same subnet and I am a domain admin so I have full
| access to both. In addition, I have created a web part that utilized a data
| grid connecting to the Northwind DB on a SQL DB and it worked very well on
| the Portal server. It has this issue wheter the authentication used to set up
| the connection is windows or SQL. So the issue appears to be specific to
| Frontpage and setting up a database connection.
|
| I have seen the KB article 831092 which indicates that I should add a Proxy
| entry in the web.config but we do not run a Proxy server on our network.
|
| To try to troubleshoot the issue I have set up another wss site in a new
| virtual server on the portal server and it gives me the exact same message.
| Another Domain admin is able to exactly recreate the problem from his
| workstation. I have also tried to connect to other SQL server DB on other
| servers and get the same error.

 

[morgade1]

I did, in fact was just slapped down by Mike Welsh for posting it in the WSS
group.