msmdpump.dll IIS hard crash

We have OLAP set up with a HTTP pump and throughout the day IIS has a hard crash 10-15 times. We can't get much out of the error log and running iisstate reveals:

(1414.127c): Unknown exception - code 800706ba (first chance)

We're running it as a priviledged user on the domain, and are impersonating a locale and set of roles on the connection string.

Not sure if this crash related to msmdpump.dll or to IIS.

You should contact Customer support for this problem and see if there is similar issue has been reported already.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||We are also facing similar problem. What fix was applied?|||

Please make sure you install SP1 of SQL Server and copy SP1 version of msmdpump.dll into your vitual folder.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

sql

msmdpump.dll IIS hard crash

We have OLAP set up with a HTTP pump and throughout the day IIS has a hard crash 10-15 times. We can't get much out of the error log and running iisstate reveals:

(1414.127c): Unknown exception - code 800706ba (first chance)

We're running it as a priviledged user on the domain, and are impersonating a locale and set of roles on the connection string.

Not sure if this crash related to msmdpump.dll or to IIS.

You should contact Customer support for this problem and see if there is similar issue has been reported already.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||We are also facing similar problem. What fix was applied?|||

Please make sure you install SP1 of SQL Server and copy SP1 version of msmdpump.dll into your vitual folder.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDN version of SQL Server 2005 Connections

If I put an MSDN version of SQL Server 2005 on a server that has IIS
for testing does the IIS users get limited to 10 connections to SQL at
once or is it considered 1 connection?
I need to know so we can use it as a test platform of load testing of
several hundered 100 or so users before moving to the production
version of SQL...which is not here yet...I dont want to think any
problems of connections or timeouts are due to using the MSDN version
for testing and development.
Thanks, Ed,
No. Whether it's from MSDN or not has no bearing on the feature set, that
simply depends on what edition you use
(Dev/Standard/Enterprise/Workgroup/Express). What it does have a bearing on
is licensing.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131130353.177316.126630@.g14g2000cwa.googlegr oups.com...
> If I put an MSDN version of SQL Server 2005 on a server that has IIS
> for testing does the IIS users get limited to 10 connections to SQL at
> once or is it considered 1 connection?
> I need to know so we can use it as a test platform of load testing of
> several hundered 100 or so users before moving to the production
> version of SQL...which is not here yet...I dont want to think any
> problems of connections or timeouts are due to using the MSDN version
> for testing and development.
> Thanks, Ed,
>
|||Sorry, forgot to say
SQL 2005 "Enterprise Edition"
I know some MSDN things like OS limit to 10, worried that it will limit
me
Ed,
|||What I am wondering is if I use the MSDN Enterprise Edition of SQL for
the backend of my development web server will it only allow 10 people
to connect to my web pages that have codebehind accessing the database,
or get some type of connection error in my code after 10 users or will
it not limit me for my testing of over 100 web users?
All users connect via IIS, none have direct connections to SQL
Thansk again Jasper
|||No, there's no feature limitation (that I'm aware of) - it's purely a
licensing thing
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131146290.037020.56980@.g14g2000cwa.googlegro ups.com...
> What I am wondering is if I use the MSDN Enterprise Edition of SQL for
> the backend of my development web server will it only allow 10 people
> to connect to my web pages that have codebehind accessing the database,
> or get some type of connection error in my code after 10 users or will
> it not limit me for my testing of over 100 web users?
> All users connect via IIS, none have direct connections to SQL
> Thansk again Jasper
>
|||Thanks
|||Thanks

MSDN version of SQL Server 2005 Connections

If I put an MSDN version of SQL Server 2005 on a server that has IIS
for testing does the IIS users get limited to 10 connections to SQL at
once or is it considered 1 connection?
I need to know so we can use it as a test platform of load testing of
several hundered 100 or so users before moving to the production
version of SQL...which is not here yet...I dont want to think any
problems of connections or timeouts are due to using the MSDN version
for testing and development.
Thanks, Ed,No. Whether it's from MSDN or not has no bearing on the feature set, that
simply depends on what edition you use
(Dev/Standard/Enterprise/Workgroup/Express). What it does have a bearing on
is licensing.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131130353.177316.126630@.g14g2000cwa.googlegroups.com...
> If I put an MSDN version of SQL Server 2005 on a server that has IIS
> for testing does the IIS users get limited to 10 connections to SQL at
> once or is it considered 1 connection?
> I need to know so we can use it as a test platform of load testing of
> several hundered 100 or so users before moving to the production
> version of SQL...which is not here yet...I dont want to think any
> problems of connections or timeouts are due to using the MSDN version
> for testing and development.
> Thanks, Ed,
>|||Sorry, forgot to say
SQL 2005 "Enterprise Edition"
I know some MSDN things like OS limit to 10, worried that it will limit
me
Ed,|||What I am wondering is if I use the MSDN Enterprise Edition of SQL for
the backend of my development web server will it only allow 10 people
to connect to my web pages that have codebehind accessing the database,
or get some type of connection error in my code after 10 users or will
it not limit me for my testing of over 100 web users?
All users connect via IIS, none have direct connections to SQL
Thansk again Jasper|||No, there's no feature limitation (that I'm aware of) - it's purely a
licensing thing
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131146290.037020.56980@.g14g2000cwa.googlegroups.com...
> What I am wondering is if I use the MSDN Enterprise Edition of SQL for
> the backend of my development web server will it only allow 10 people
> to connect to my web pages that have codebehind accessing the database,
> or get some type of connection error in my code after 10 users or will
> it not limit me for my testing of over 100 web users?
> All users connect via IIS, none have direct connections to SQL
> Thansk again Jasper
>|||Thanks|||Thanks

MSDN version of SQL Server 2005 Connections

If I put an MSDN version of SQL Server 2005 on a server that has IIS
for testing does the IIS users get limited to 10 connections to SQL at
once or is it considered 1 connection?
I need to know so we can use it as a test platform of load testing of
several hundered 100 or so users before moving to the production
version of SQL...which is not here yet...I dont want to think any
problems of connections or timeouts are due to using the MSDN version
for testing and development.
Thanks, Ed,No. Whether it's from MSDN or not has no bearing on the feature set, that
simply depends on what edition you use
(Dev/Standard/Enterprise/Workgroup/Express). What it does have a bearing on
is licensing.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131130353.177316.126630@.g14g2000cwa.googlegroups.com...
> If I put an MSDN version of SQL Server 2005 on a server that has IIS
> for testing does the IIS users get limited to 10 connections to SQL at
> once or is it considered 1 connection?
> I need to know so we can use it as a test platform of load testing of
> several hundered 100 or so users before moving to the production
> version of SQL...which is not here yet...I dont want to think any
> problems of connections or timeouts are due to using the MSDN version
> for testing and development.
> Thanks, Ed,
>|||Sorry, forgot to say
SQL 2005 "Enterprise Edition"
I know some MSDN things like OS limit to 10, worried that it will limit
me
Ed,|||What I am wondering is if I use the MSDN Enterprise Edition of SQL for
the backend of my development web server will it only allow 10 people
to connect to my web pages that have codebehind accessing the database,
or get some type of connection error in my code after 10 users or will
it not limit me for my testing of over 100 web users?
All users connect via IIS, none have direct connections to SQL
Thansk again Jasper|||No, there's no feature limitation (that I'm aware of) - it's purely a
licensing thing
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"gencode" <google@.gencode.com> wrote in message
news:1131146290.037020.56980@.g14g2000cwa.googlegroups.com...
> What I am wondering is if I use the MSDN Enterprise Edition of SQL for
> the backend of my development web server will it only allow 10 people
> to connect to my web pages that have codebehind accessing the database,
> or get some type of connection error in my code after 10 users or will
> it not limit me for my testing of over 100 web users?
> All users connect via IIS, none have direct connections to SQL
> Thansk again Jasper
>|||Thanks|||Thanks