Although the MELL content seems to be working properly, I'm receiving the
following error when attempting to load MELL reports at
http://<servername>/mell/eng/reports/
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.
Please contact your network or training administrator.
My environment consists of these two servers:
[MellServer]
Windows 2003 Server, SP1
IIS 6.0
[MellDatabaseServer]
Windows 2000 Server
SQL Server 2000
My reasons for believing the listed causes are incorrect are:
The DSN pointing to the SQL server is missing from the web server.
-- I have a DSN on the web server that's pointing to the correct SQL server
The DSN on the web server contains incorrect logon credentials.
-- The DSN tests successfully
The SQL server being referenced does not contain a MELL database.
-- A database named MELL does exist and has populated tables
The SQL services on the SQL server being referenced are not started.
-- SQL services are started... DSN tests okay
The SQL server being referenced is not available due to network outage or
other condition.
-- Again, DSN tests okay. Plus, I can see a connection coming from the web
server in my netstat -a output.
Any help is greatly appreciated.
--SK--
Evidently my DSN file was not saving my password. If this is happening with
your MELL installation, 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.
Hope this helps someone else.
SK
--SK--
"ShaneK" wrote:
> Although the MELL content seems to be working properly, I'm receiving the
> following error when attempting to load MELL reports at
> http://<servername>/mell/eng/reports/
> 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.
> ----
> Please contact your network or training administrator.
> My environment consists of these two servers:
> [MellServer]
> Windows 2003 Server, SP1
> IIS 6.0
> [MellDatabaseServer]
> Windows 2000 Server
> SQL Server 2000
> My reasons for believing the listed causes are incorrect are:
> The DSN pointing to the SQL server is missing from the web server.
> -- I have a DSN on the web server that's pointing to the correct SQL server
> The DSN on the web server contains incorrect logon credentials.
> -- The DSN tests successfully
> The SQL server being referenced does not contain a MELL database.
> -- A database named MELL does exist and has populated tables
> The SQL services on the SQL server being referenced are not started.
> -- SQL services are started... DSN tests okay
> The SQL server being referenced is not available due to network outage or
> other condition.
> -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> server in my netstat -a output.
> Any help is greatly appreciated.
> --
> --SK--
|||Did you ever get a response to the IP address showing in the report ? I went
through some similar SQL problems and was able to resolve them, but havent
found a thing on the reports showing IP address' (granted finding anything on
MELL has been tough)
"ShaneK" wrote:
[vbcol=seagreen]
> Glad to know this helped you!! Now, I'm only seeing IP addresses in the
> reports where I'd prefer to see the names of my Active Directory users. I've
> got a support case in progress with Microsoft and expect an answer this week.
> If you'd like to know how that one turns out let me know and I'll post a
> followup here.
> --
> --SK--
>
> "Erpara" wrote:
Showing posts with label properly. Show all posts
Showing posts with label properly. Show all posts
Friday, March 23, 2012
MELL 2.5 Reports - Cannot Connect to a MELL database
Although the MELL content seems to be working properly, I'm receiving the
following error when attempting to load MELL reports at
http://<servername>/mell/eng/reports/
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.
----
Please contact your network or training administrator.
My environment consists of these two servers:
[MellServer]
Windows 2003 Server, SP1
IIS 6.0
[MellDatabaseServer]
Windows 2000 Server
SQL Server 2000
My reasons for believing the listed causes are incorrect are:
The DSN pointing to the SQL server is missing from the web server.
-- I have a DSN on the web server that's pointing to the correct SQL server
The DSN on the web server contains incorrect logon credentials.
-- The DSN tests successfully
The SQL server being referenced does not contain a MELL database.
-- A database named MELL does exist and has populated tables
The SQL services on the SQL server being referenced are not started.
-- SQL services are started... DSN tests okay
The SQL server being referenced is not available due to network outage or
other condition.
-- Again, DSN tests okay. Plus, I can see a connection coming from the web
server in my netstat -a output.
Any help is greatly appreciated.
--
--SK--Evidently my DSN file was not saving my password. If this is happening with
your MELL installation, 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.
Hope this helps someone else.
SK
--
--SK--
"ShaneK" wrote:
> Although the MELL content seems to be working properly, I'm receiving the
> following error when attempting to load MELL reports at
> http://<servername>/mell/eng/reports/
> 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.
> ----
> Please contact your network or training administrator.
> My environment consists of these two servers:
> [MellServer]
> Windows 2003 Server, SP1
> IIS 6.0
> [MellDatabaseServer]
> Windows 2000 Server
> SQL Server 2000
> My reasons for believing the listed causes are incorrect are:
> The DSN pointing to the SQL server is missing from the web server.
> -- I have a DSN on the web server that's pointing to the correct SQL server
> The DSN on the web server contains incorrect logon credentials.
> -- The DSN tests successfully
> The SQL server being referenced does not contain a MELL database.
> -- A database named MELL does exist and has populated tables
> The SQL services on the SQL server being referenced are not started.
> -- SQL services are started... DSN tests okay
> The SQL server being referenced is not available due to network outage or
> other condition.
> -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> server in my netstat -a output.
> Any help is greatly appreciated.
> --
> --SK--|||Thank you so much for posting this! You've saved me a lot of heartache...
erpara
"ShaneK" wrote:
> Evidently my DSN file was not saving my password. If this is happening with
> your MELL installation, 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.
> Hope this helps someone else.
> SK
> --
> --SK--
>
> "ShaneK" wrote:
> > Although the MELL content seems to be working properly, I'm receiving the
> > following error when attempting to load MELL reports at
> > http://<servername>/mell/eng/reports/
> >
> > 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.
> > ----
> > Please contact your network or training administrator.
> >
> > My environment consists of these two servers:
> > [MellServer]
> > Windows 2003 Server, SP1
> > IIS 6.0
> >
> > [MellDatabaseServer]
> > Windows 2000 Server
> > SQL Server 2000
> >
> > My reasons for believing the listed causes are incorrect are:
> >
> > The DSN pointing to the SQL server is missing from the web server.
> > -- I have a DSN on the web server that's pointing to the correct SQL server
> >
> > The DSN on the web server contains incorrect logon credentials.
> > -- The DSN tests successfully
> >
> > The SQL server being referenced does not contain a MELL database.
> > -- A database named MELL does exist and has populated tables
> >
> > The SQL services on the SQL server being referenced are not started.
> > -- SQL services are started... DSN tests okay
> >
> > The SQL server being referenced is not available due to network outage or
> > other condition.
> > -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> > server in my netstat -a output.
> >
> > Any help is greatly appreciated.
> > --
> > --SK--|||Glad to know this helped you!! Now, I'm only seeing IP addresses in the
reports where I'd prefer to see the names of my Active Directory users. I've
got a support case in progress with Microsoft and expect an answer this week.
If you'd like to know how that one turns out let me know and I'll post a
followup here.
--
--SK--
"Erpara" wrote:
> Thank you so much for posting this! You've saved me a lot of heartache...
> erpara
> "ShaneK" wrote:
> > Evidently my DSN file was not saving my password. If this is happening with
> > your MELL installation, 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.
> >
> > Hope this helps someone else.
> >
> > SK
> >
> > --
> > --SK--
> >
> >
> > "ShaneK" wrote:
> >
> > > Although the MELL content seems to be working properly, I'm receiving the
> > > following error when attempting to load MELL reports at
> > > http://<servername>/mell/eng/reports/
> > >
> > > 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.
> > > ----
> > > Please contact your network or training administrator.
> > >
> > > My environment consists of these two servers:
> > > [MellServer]
> > > Windows 2003 Server, SP1
> > > IIS 6.0
> > >
> > > [MellDatabaseServer]
> > > Windows 2000 Server
> > > SQL Server 2000
> > >
> > > My reasons for believing the listed causes are incorrect are:
> > >
> > > The DSN pointing to the SQL server is missing from the web server.
> > > -- I have a DSN on the web server that's pointing to the correct SQL server
> > >
> > > The DSN on the web server contains incorrect logon credentials.
> > > -- The DSN tests successfully
> > >
> > > The SQL server being referenced does not contain a MELL database.
> > > -- A database named MELL does exist and has populated tables
> > >
> > > The SQL services on the SQL server being referenced are not started.
> > > -- SQL services are started... DSN tests okay
> > >
> > > The SQL server being referenced is not available due to network outage or
> > > other condition.
> > > -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> > > server in my netstat -a output.
> > >
> > > Any help is greatly appreciated.
> > > --
> > > --SK--|||Did you ever get a response to the IP address showing in the report ' I went
through some similar SQL problems and was able to resolve them, but havent
found a thing on the reports showing IP address' (granted finding anything on
MELL has been tough)
"ShaneK" wrote:
> Glad to know this helped you!! Now, I'm only seeing IP addresses in the
> reports where I'd prefer to see the names of my Active Directory users. I've
> got a support case in progress with Microsoft and expect an answer this week.
> If you'd like to know how that one turns out let me know and I'll post a
> followup here.
> --
> --SK--
>
> "Erpara" wrote:
> > Thank you so much for posting this! You've saved me a lot of heartache...
> >
> > erpara
> >
> > "ShaneK" wrote:
> >
> > > Evidently my DSN file was not saving my password. If this is happening with
> > > your MELL installation, 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.
> > >
> > > Hope this helps someone else.
> > >
> > > SK
> > >
> > > --
> > > --SK--
> > >
> > >
> > > "ShaneK" wrote:
> > >
> > > > Although the MELL content seems to be working properly, I'm receiving the
> > > > following error when attempting to load MELL reports at
> > > > http://<servername>/mell/eng/reports/
> > > >
> > > > 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.
> > > > ----
> > > > Please contact your network or training administrator.
> > > >
> > > > My environment consists of these two servers:
> > > > [MellServer]
> > > > Windows 2003 Server, SP1
> > > > IIS 6.0
> > > >
> > > > [MellDatabaseServer]
> > > > Windows 2000 Server
> > > > SQL Server 2000
> > > >
> > > > My reasons for believing the listed causes are incorrect are:
> > > >
> > > > The DSN pointing to the SQL server is missing from the web server.
> > > > -- I have a DSN on the web server that's pointing to the correct SQL server
> > > >
> > > > The DSN on the web server contains incorrect logon credentials.
> > > > -- The DSN tests successfully
> > > >
> > > > The SQL server being referenced does not contain a MELL database.
> > > > -- A database named MELL does exist and has populated tables
> > > >
> > > > The SQL services on the SQL server being referenced are not started.
> > > > -- SQL services are started... DSN tests okay
> > > >
> > > > The SQL server being referenced is not available due to network outage or
> > > > other condition.
> > > > -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> > > > server in my netstat -a output.
> > > >
> > > > Any help is greatly appreciated.
> > > > --
> > > > --SK--
following error when attempting to load MELL reports at
http://<servername>/mell/eng/reports/
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.
----
Please contact your network or training administrator.
My environment consists of these two servers:
[MellServer]
Windows 2003 Server, SP1
IIS 6.0
[MellDatabaseServer]
Windows 2000 Server
SQL Server 2000
My reasons for believing the listed causes are incorrect are:
The DSN pointing to the SQL server is missing from the web server.
-- I have a DSN on the web server that's pointing to the correct SQL server
The DSN on the web server contains incorrect logon credentials.
-- The DSN tests successfully
The SQL server being referenced does not contain a MELL database.
-- A database named MELL does exist and has populated tables
The SQL services on the SQL server being referenced are not started.
-- SQL services are started... DSN tests okay
The SQL server being referenced is not available due to network outage or
other condition.
-- Again, DSN tests okay. Plus, I can see a connection coming from the web
server in my netstat -a output.
Any help is greatly appreciated.
--
--SK--Evidently my DSN file was not saving my password. If this is happening with
your MELL installation, 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.
Hope this helps someone else.
SK
--
--SK--
"ShaneK" wrote:
> Although the MELL content seems to be working properly, I'm receiving the
> following error when attempting to load MELL reports at
> http://<servername>/mell/eng/reports/
> 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.
> ----
> Please contact your network or training administrator.
> My environment consists of these two servers:
> [MellServer]
> Windows 2003 Server, SP1
> IIS 6.0
> [MellDatabaseServer]
> Windows 2000 Server
> SQL Server 2000
> My reasons for believing the listed causes are incorrect are:
> The DSN pointing to the SQL server is missing from the web server.
> -- I have a DSN on the web server that's pointing to the correct SQL server
> The DSN on the web server contains incorrect logon credentials.
> -- The DSN tests successfully
> The SQL server being referenced does not contain a MELL database.
> -- A database named MELL does exist and has populated tables
> The SQL services on the SQL server being referenced are not started.
> -- SQL services are started... DSN tests okay
> The SQL server being referenced is not available due to network outage or
> other condition.
> -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> server in my netstat -a output.
> Any help is greatly appreciated.
> --
> --SK--|||Thank you so much for posting this! You've saved me a lot of heartache...
erpara
"ShaneK" wrote:
> Evidently my DSN file was not saving my password. If this is happening with
> your MELL installation, 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.
> Hope this helps someone else.
> SK
> --
> --SK--
>
> "ShaneK" wrote:
> > Although the MELL content seems to be working properly, I'm receiving the
> > following error when attempting to load MELL reports at
> > http://<servername>/mell/eng/reports/
> >
> > 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.
> > ----
> > Please contact your network or training administrator.
> >
> > My environment consists of these two servers:
> > [MellServer]
> > Windows 2003 Server, SP1
> > IIS 6.0
> >
> > [MellDatabaseServer]
> > Windows 2000 Server
> > SQL Server 2000
> >
> > My reasons for believing the listed causes are incorrect are:
> >
> > The DSN pointing to the SQL server is missing from the web server.
> > -- I have a DSN on the web server that's pointing to the correct SQL server
> >
> > The DSN on the web server contains incorrect logon credentials.
> > -- The DSN tests successfully
> >
> > The SQL server being referenced does not contain a MELL database.
> > -- A database named MELL does exist and has populated tables
> >
> > The SQL services on the SQL server being referenced are not started.
> > -- SQL services are started... DSN tests okay
> >
> > The SQL server being referenced is not available due to network outage or
> > other condition.
> > -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> > server in my netstat -a output.
> >
> > Any help is greatly appreciated.
> > --
> > --SK--|||Glad to know this helped you!! Now, I'm only seeing IP addresses in the
reports where I'd prefer to see the names of my Active Directory users. I've
got a support case in progress with Microsoft and expect an answer this week.
If you'd like to know how that one turns out let me know and I'll post a
followup here.
--
--SK--
"Erpara" wrote:
> Thank you so much for posting this! You've saved me a lot of heartache...
> erpara
> "ShaneK" wrote:
> > Evidently my DSN file was not saving my password. If this is happening with
> > your MELL installation, 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.
> >
> > Hope this helps someone else.
> >
> > SK
> >
> > --
> > --SK--
> >
> >
> > "ShaneK" wrote:
> >
> > > Although the MELL content seems to be working properly, I'm receiving the
> > > following error when attempting to load MELL reports at
> > > http://<servername>/mell/eng/reports/
> > >
> > > 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.
> > > ----
> > > Please contact your network or training administrator.
> > >
> > > My environment consists of these two servers:
> > > [MellServer]
> > > Windows 2003 Server, SP1
> > > IIS 6.0
> > >
> > > [MellDatabaseServer]
> > > Windows 2000 Server
> > > SQL Server 2000
> > >
> > > My reasons for believing the listed causes are incorrect are:
> > >
> > > The DSN pointing to the SQL server is missing from the web server.
> > > -- I have a DSN on the web server that's pointing to the correct SQL server
> > >
> > > The DSN on the web server contains incorrect logon credentials.
> > > -- The DSN tests successfully
> > >
> > > The SQL server being referenced does not contain a MELL database.
> > > -- A database named MELL does exist and has populated tables
> > >
> > > The SQL services on the SQL server being referenced are not started.
> > > -- SQL services are started... DSN tests okay
> > >
> > > The SQL server being referenced is not available due to network outage or
> > > other condition.
> > > -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> > > server in my netstat -a output.
> > >
> > > Any help is greatly appreciated.
> > > --
> > > --SK--|||Did you ever get a response to the IP address showing in the report ' I went
through some similar SQL problems and was able to resolve them, but havent
found a thing on the reports showing IP address' (granted finding anything on
MELL has been tough)
"ShaneK" wrote:
> Glad to know this helped you!! Now, I'm only seeing IP addresses in the
> reports where I'd prefer to see the names of my Active Directory users. I've
> got a support case in progress with Microsoft and expect an answer this week.
> If you'd like to know how that one turns out let me know and I'll post a
> followup here.
> --
> --SK--
>
> "Erpara" wrote:
> > Thank you so much for posting this! You've saved me a lot of heartache...
> >
> > erpara
> >
> > "ShaneK" wrote:
> >
> > > Evidently my DSN file was not saving my password. If this is happening with
> > > your MELL installation, 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.
> > >
> > > Hope this helps someone else.
> > >
> > > SK
> > >
> > > --
> > > --SK--
> > >
> > >
> > > "ShaneK" wrote:
> > >
> > > > Although the MELL content seems to be working properly, I'm receiving the
> > > > following error when attempting to load MELL reports at
> > > > http://<servername>/mell/eng/reports/
> > > >
> > > > 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.
> > > > ----
> > > > Please contact your network or training administrator.
> > > >
> > > > My environment consists of these two servers:
> > > > [MellServer]
> > > > Windows 2003 Server, SP1
> > > > IIS 6.0
> > > >
> > > > [MellDatabaseServer]
> > > > Windows 2000 Server
> > > > SQL Server 2000
> > > >
> > > > My reasons for believing the listed causes are incorrect are:
> > > >
> > > > The DSN pointing to the SQL server is missing from the web server.
> > > > -- I have a DSN on the web server that's pointing to the correct SQL server
> > > >
> > > > The DSN on the web server contains incorrect logon credentials.
> > > > -- The DSN tests successfully
> > > >
> > > > The SQL server being referenced does not contain a MELL database.
> > > > -- A database named MELL does exist and has populated tables
> > > >
> > > > The SQL services on the SQL server being referenced are not started.
> > > > -- SQL services are started... DSN tests okay
> > > >
> > > > The SQL server being referenced is not available due to network outage or
> > > > other condition.
> > > > -- Again, DSN tests okay. Plus, I can see a connection coming from the web
> > > > server in my netstat -a output.
> > > >
> > > > Any help is greatly appreciated.
> > > > --
> > > > --SK--
MELL 2.5 Reports - Cannot Connect to a MELL database
Although the MELL content seems to be working properly, I'm receiving the
following error when attempting to load MELL reports at
http://<servername>/mell/eng/reports/
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.
----
--
Please contact your network or training administrator.
My environment consists of these two servers:
[MellServer]
Windows 2003 Server, SP1
IIS 6.0
[MellDatabaseServer]
Windows 2000 Server
SQL Server 2000
My reasons for believing the listed causes are incorrect are:
The DSN pointing to the SQL server is missing from the web server.
-- I have a DSN on the web server that's pointing to the correct SQL server
The DSN on the web server contains incorrect logon credentials.
-- The DSN tests successfully
The SQL server being referenced does not contain a MELL database.
-- A database named MELL does exist and has populated tables
The SQL services on the SQL server being referenced are not started.
-- SQL services are started... DSN tests okay
The SQL server being referenced is not available due to network outage or
other condition.
-- Again, DSN tests okay. Plus, I can see a connection coming from the web
server in my netstat -a output.
Any help is greatly appreciated.
--
--SK--Evidently my DSN file was not saving my password. If this is happening with
your MELL installation, 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.
Hope this helps someone else.
SK
--SK--
"ShaneK" wrote:
> Although the MELL content seems to be working properly, I'm receiving the
> following error when attempting to load MELL reports at
> http://<servername>/mell/eng/reports/
> Could not connect to a MELL database
> Microsoft? eLearning Library - Reports Viewer cannot query a MELL databas
e.
> ----
--
> 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.
> ----
--
> Please contact your network or training administrator.
> My environment consists of these two servers:
> [MellServer]
> Windows 2003 Server, SP1
> IIS 6.0
> [MellDatabaseServer]
> Windows 2000 Server
> SQL Server 2000
> My reasons for believing the listed causes are incorrect are:
> The DSN pointing to the SQL server is missing from the web server.
> -- I have a DSN on the web server that's pointing to the correct SQL serve
r
> The DSN on the web server contains incorrect logon credentials.
> -- The DSN tests successfully
> The SQL server being referenced does not contain a MELL database.
> -- A database named MELL does exist and has populated tables
> The SQL services on the SQL server being referenced are not started.
> -- SQL services are started... DSN tests okay
> The SQL server being referenced is not available due to network outage or
> other condition.
> -- Again, DSN tests okay. Plus, I can see a connection coming from the we
b
> server in my netstat -a output.
> Any help is greatly appreciated.
> --
> --SK--|||Did you ever get a response to the IP address showing in the report ' I wen
t
through some similar SQL problems and was able to resolve them, but havent
found a thing on the reports showing IP address' (granted finding anything o
n
MELL has been tough)
"ShaneK" wrote:
[vbcol=seagreen]
> Glad to know this helped you!! Now, I'm only seeing IP addresses in the
> reports where I'd prefer to see the names of my Active Directory users. I
've
> got a support case in progress with Microsoft and expect an answer this we
ek.
> If you'd like to know how that one turns out let me know and I'll post a
> followup here.
> --
> --SK--
>
> "Erpara" wrote:
>
following error when attempting to load MELL reports at
http://<servername>/mell/eng/reports/
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.
----
--
Please contact your network or training administrator.
My environment consists of these two servers:
[MellServer]
Windows 2003 Server, SP1
IIS 6.0
[MellDatabaseServer]
Windows 2000 Server
SQL Server 2000
My reasons for believing the listed causes are incorrect are:
The DSN pointing to the SQL server is missing from the web server.
-- I have a DSN on the web server that's pointing to the correct SQL server
The DSN on the web server contains incorrect logon credentials.
-- The DSN tests successfully
The SQL server being referenced does not contain a MELL database.
-- A database named MELL does exist and has populated tables
The SQL services on the SQL server being referenced are not started.
-- SQL services are started... DSN tests okay
The SQL server being referenced is not available due to network outage or
other condition.
-- Again, DSN tests okay. Plus, I can see a connection coming from the web
server in my netstat -a output.
Any help is greatly appreciated.
--
--SK--Evidently my DSN file was not saving my password. If this is happening with
your MELL installation, 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.
Hope this helps someone else.
SK
--SK--
"ShaneK" wrote:
> Although the MELL content seems to be working properly, I'm receiving the
> following error when attempting to load MELL reports at
> http://<servername>/mell/eng/reports/
> Could not connect to a MELL database
> Microsoft? eLearning Library - Reports Viewer cannot query a MELL databas
e.
> ----
--
> 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.
> ----
--
> Please contact your network or training administrator.
> My environment consists of these two servers:
> [MellServer]
> Windows 2003 Server, SP1
> IIS 6.0
> [MellDatabaseServer]
> Windows 2000 Server
> SQL Server 2000
> My reasons for believing the listed causes are incorrect are:
> The DSN pointing to the SQL server is missing from the web server.
> -- I have a DSN on the web server that's pointing to the correct SQL serve
r
> The DSN on the web server contains incorrect logon credentials.
> -- The DSN tests successfully
> The SQL server being referenced does not contain a MELL database.
> -- A database named MELL does exist and has populated tables
> The SQL services on the SQL server being referenced are not started.
> -- SQL services are started... DSN tests okay
> The SQL server being referenced is not available due to network outage or
> other condition.
> -- Again, DSN tests okay. Plus, I can see a connection coming from the we
b
> server in my netstat -a output.
> Any help is greatly appreciated.
> --
> --SK--|||Did you ever get a response to the IP address showing in the report ' I wen
t
through some similar SQL problems and was able to resolve them, but havent
found a thing on the reports showing IP address' (granted finding anything o
n
MELL has been tough)
"ShaneK" wrote:
[vbcol=seagreen]
> Glad to know this helped you!! Now, I'm only seeing IP addresses in the
> reports where I'd prefer to see the names of my Active Directory users. I
've
> got a support case in progress with Microsoft and expect an answer this we
ek.
> If you'd like to know how that one turns out let me know and I'll post a
> followup here.
> --
> --SK--
>
> "Erpara" wrote:
>
Monday, March 19, 2012
MDX's ORDER Function
Hi
I'm trying to order rows returned by a MDX query using ORDER function. It seems that I don't use it properly. Here is the query from the sample AS Database, AdventureWork.
WITH MEMBER [Measures].DIFF AS
'([Customer].[Country].CURRENTMEMBER, [Measures].[Internet Sales Amount])
-
([Customer].[Country].&[Australia], [Measures].[Internet Sales Amount])'
SELECT [Measures].DIFF ON COLUMNS,
ORDER([Customer].[Country].MEMBERS, [Measures].DIFF, BDESC) ON ROWS
FROM [Adventure Works]
what it returns is:
All Customers $20,297,676.64
United States $328,788.93
Australia $0.00
United Kingdom ($5,669,288.37)
Germany ($6,166,688.25)
France ($6,416,982.87)
Canada ($7,083,155.72)
I expected to see "Australia" at the end of the list and "All Customers" on top of it.
Any Idea?
Thanks in advance,
AmirThe results look correct to me. Why do you expect Australia at the end ? It's DIFF is 0 which is bigger then negative diffs of other countries.|||Sorry about that.
I didn't realize there is a bracket arround negative numbers.
Thanks
Subscribe to:
Posts (Atom)