Membership Configuration

I am attempting to follow the instructions:

Walkthrough: Creating a Web Site with Membership and User Login (Visual Studio)

When I attempt to create a membership user with the ASP.NET Configuration wizard nothing happens - it attempts to launch my browser and if I am not connected to the intenet it insists on connecting. If I am connected then nothing happens - it is as if I clicked on air. A wizard is supposed to launch so that I can set up users.

Any help would be appreciated - I am really trying to get to creating an application that authenticates users for admitance to a restricted area in a website.

Thanks!

I would try posting you question in the http://forums.asp.net membership and security groups as the question you are asking relates to Web development and the membership providers.

But To start with I would check to make sure you have the correct provider set up and configured, you could also check to see if the membership tables and such have been created, this could be inside your database or inside another database called aspnetdb from memory. Did you try following the wizard inside the asp configuration pages to set up the security.. if not try that..

sql

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--
|||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:

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--

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:
>

MDX Parameter Query

I am attempting to add a date parameter to a RS MDX query. Below I have included my query. I have been following a olapasandrs.asp white paper on microsoft.com, but I keep receiving an error message - "The expression for the query 'query name' contains an error: [BC30648] String constants must end with a doube quote"
If someone would please be kind enough to take a look at my query and point out any problems I would appreciate it!!
="SELECT{[Measures].[Gm] ,[Measures].[Sales],[Measures].[COS],[Measures].[Rebate],[Measures].[Adjustment]} ON AXIS(0) , {nonemptycrossJoin([products].[Glcls].Members,[segdiv].[divname].Members)} ON AXIS(1) ,{[Time].Members} ON AXIS(2) FROM vc_rebates Where (" & Parameters!pTime.Value & ")"
--
Message posted via http://www.sqlmonster.comI have an update:
I have changed my query to read-
="SELECT{[Measures].[Gm] ,[Measures].[Sales],[Measures].[COS],[Measures].[Rebate],[Measures].[Adjustment]} ON AXIS(0),
{nonemptycrossJoin([products].[Glcls].Members,[segdiv].[divname].Members)} ON AXIS(1),
{Descendants([Time].[All Time],[Time].[Month])} ON AXIS(2)
FROM vc_rebates Where(" & Parameters!pTime.Value & ")"
I still receive the error: "[BC30648] String constants must end with a doube quote" though...
Any help would be appreciated!!!!
--
Message posted via http://www.sqlmonster.com|||Jason via SQLMonster.com wrote:
> I still receive the error: "[BC30648] String constants must end with
> a doube quote" though...
you have to write a double quote at the beginning and end of each line.
="SELECT{[Measures].[Gm]
,[Measures].[Sales],[Measures].[COS],[Measures].[Rebate],[Measures].[Adjustm
ent]} ON AXIS(0), " +
"{nonemptycrossJoin([products].[Glcls].Members,[segdiv].[divname].Members)}
ON AXIS(1), " +
"{Descendants([Time].[All Time],[Time].[Month])} ON AXIS(2) " +
"FROM vc_rebates Where(" & Parameters!pTime.Value & ")"
regards
Frank
www.xax.de|||Thank you Frank!
I have changed the query statement to read:
="SELECT{[Measures].[Gm] ,[Measures].[Sales],[Measures].[COS],[Measures].[Rebate],[Measures].[Adjustment]} ON Columns, " +
"Non Empty { [products].[Glcls].Members } ON Rows, " +
"Non Empty { Descendants([segdiv].[All segDiv],[segDiv].[Divname],LEAVES) } ON Pages, " +
"Non Empty { Descendants([Time].[All Time],[Time].[Month],LEAVES) } ON Sections " +
"FROM vc_rebates " +
"Where (" & Parameters!pDate.Value & ")"
Now I am receving a new error message, "The expression for the query 'Query Name' contains an error: [BC30451] Name 'Non' is not declared".
Do you have any additional suggestions?
Thanks
--
Message posted via http://www.sqlmonster.com|||Jason via SQLMonster.com wrote:
> I have changed the query statement to read:
> Now I am receving a new error message, "The expression for the query
> 'Query Name' contains an error: [BC30451] Name 'Non' is not
> declared".
> Do you have any additional suggestions?
OK...now your MDX-Statement seems to be wrong.
The "Name 'Non' is not declared seems to result of the "Non Empty"
Did you test your MDX-Query in mdx-query-application
(Start-Progs-SQLServer-Analysis Services -MDX-Application)? Usually without
the "-Quotes!! and filled up with the parameter-value.
For Test:
Erase the Non Empty-Clause
regards
Frank
www.xax.de|||Thank you for your response Frank,
I have one last post for you...
I have been able to deploy the report and have not encoutnered any errors. Upon selecting the parameter though I am reeiving an error message from reporting services:
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
Operation is not valid due to the current state of the object.
If I remove the parameter the report runs fine. Do you have any suggestions? I have posted the parameter query statement below.
with Member [Measures].[TimeMemberUniqueName] as '[Time].currentmember.UniqueName' member [Measures].[TimeDisplayName] as 'space([Time].Currentmember.Level.Ordinal *4) + Time.Currentmember.Name'
Select {[Measures].[TimeMemberUniqueName],[Measures].[TimeDisplayName]} on Columns,
{[Time].members} on rows
from vc_rebates
Thank you in advance!!
--
Message posted via http://www.sqlmonster.com|||Frank,
Problem solved!!
There were some simple formatting issues that I fixed.
Your help is greatly appreciated!!
--
Message posted via http://www.sqlmonster.com