WSS Forum

Ask Question   UnAnswered
Home » Forum » WSS       RSS Feeds

FrontPage 2003 to connect to a database server

  Asked By: Thomas    Date: May 16    Category: WSS    Views: 1325

I have struggled with an issue in WSS for the last 3 months with no luck and need the expertise of this group. I would like to use FrontPage 2003 to connect to a database server. As I attempt to configure a Database Connection by entering the server name and "Use Windows Authentication" I get the following error:

"Server Error: An error occurred while retrieving the list of Databases from <servername>: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information"

I am including a screen print and a prize out of our "trash and trinkets" marketing vault for correct assistance in resolving this pain of mine. I will send you a "APS Energy Services" branded mini remote control car for helping me slay this beast of a pain.



3 Answers Found

Answer #1    Answered By: Marlon Colon     Answered On: May 16

Don´t know how much you have done so far but can tell you how I did.
Firstly I created the database  on the SQL server  and then opened a
new page in Front Page. (I have got a Swedish version so I hope my
translations are correct) Under "Data" I choose "Include Data view"
and then under "Database connections" "Add to cataloge". Found the
database of my choice and I had a new database connection. After
this I pointed to this new database connection and from the drop
down menu I choose the first one probably called "Include data view".
Choosing "Properties for data source..." I could sort and filter the

Answer #2    Answered By: Pierre Copeland     Answered On: May 16

Forgot to tell you how I did to get it on the portal site.
I navigated, in IE, to a suitable Portal site and inserted the web
part "DataViewWebPart".
In Front Page I right clicked on the new data view
choosed "Properties for web part.." copied the three different codes
i.e. XSL-editor, data question editor and parameter editor and
pasted theese in the corresponding properties of the DataViewWebPart.
There might be an easier way to do this but nevertheless it worked
for me.

Answer #3    Answered By: Lewis Mann     Answered On: May 16

Integrated authentication will work if the database  is on the same sql
server where your WSS database is (not exactly true but close). Use SQL std
authentication and you will be able to connect.
On the SQL server  you are trying to connect, make sure std auth is enabled.

See if this solves your problem. Let me know.

Didn't find what you were looking for? Find more on FrontPage 2003 to connect to a database server Or get search suggestion and latest updates.