Office eLearning Reports - Unable to access all of a sudden

[Scrappo]

Hello

Ive had a problem over the last week or so when all of a sudden (after
another sql database was installed on the server) I was unable to access the
eLearning reports 'http' page. The page error i have recieved is:

Could not connect to a MELL database
Microsoft® eLearning Library - Reports Viewer cannot query a MELL database.


--------------------------------------------------------------------------------

This is due to the following:

The DSN pointing to the SQL server is missing from the web server.
The DSN on the web server contains incorrect logon credentials.
The SQL server being referenced does not contain a MELL database.
The SQL services on the SQL server being referenced are not started.
The SQL server being referenced is not available due to network outage or
other condition.

--------------
The actual eLearning site is still working fine, its just the reports
section that isnt. Could anyone help me through working out what has changed
and how to find out what to put right again.

Thanks

Scrappo

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Darrell]

I found this solution on Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.server

Check C:\Program Files\Common Files\ODBC\Data Sources\mell25.dsn

Directly below the line beginning with "UID", there should be a line that
reads: PWD=yourpassword

If this line isn't present, add it.

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Thanks Darrell

However how do i check it? I am using windows server 2003

Thanks

Scrappo

 

[Scrappo]

Sorry Darrell - ignore the last email pls

I did not have the yourpassword line in there but have now added it -
however im still having the same error.

Is it a case or rebooting the server or the like now?

This is whats in the mell25.dsn by the way.
[ODBC]
DRIVER=SQL Server
UID=sa
PWD=yourpassword
DATABASE=MELL
WSID=WINSERVER1
APP=Microsoft Open Database Connectivity
SERVER=WINSERVER1

Thanks

Scrappo

 

[Scrappo]

Sorry Darrell - ignore the last email pls

I did not have the yourpassword line in there but have now added it -
however im still having the same error.

Is it a case or rebooting the server or the like now?

This is whats in the mell25.dsn by the way.
[ODBC]
DRIVER=SQL Server
UID=sa
PWD=yourpassword
DATABASE=MELL
WSID=WINSERVER1
APP=Microsoft Open Database Connectivity
SERVER=WINSERVER1

Thanks

Scrappo

 

[Scrappo]

Sorry Darrell - ignore the last email pls

I did not have the yourpassword line in there but have now added it -
however im still having the same error.

Is it a case or rebooting the server or the like now?

This is whats in the mell25.dsn by the way.
[ODBC]
DRIVER=SQL Server
UID=sa
PWD=yourpassword
DATABASE=MELL
WSID=WINSERVER1
APP=Microsoft Open Database Connectivity
SERVER=WINSERVER1

Thanks

Scrappo