sqlexpress + plesk != ok - Installing DNN Platform

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

Home

Getting Started

Installing DNN ...

sqlexpress + plesk != ok

10/28/2007 7:12 AM

ulrik isaksson

Joined: 1/5/2006

Posts: 70

sqlexpress + plesk != ok Modified By ulrik isaksson on 10/28/2007 1:23:22 PM

HI.

When i try to use sql express within a plesk configuration i always recive error

CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file D:\inetpub\vhosts\arcticforum.se\httpdocs\App_Data\De.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

it doesnt matter if the database exists or not.

Or ...

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

What user, how shall i do this i have access to the server but dont know how to fix this??

11/26/2007 6:39 AM

ulrik isaksson

Joined: 1/5/2006

Posts: 70

Re: sqlexpress + plesk != ok

I found a solution to this a changed the application pool from Plesk(default)(2.0) Pool to MSSharePointAppPool and sql express works again.

But plesk cant handle mail when i use MSSharePointAppPool, how can i make sqlexpress work in Plesk(default)(2.0) Pool?

Where can i find the settings for this??

11/26/2007 1:56 PM

Mitchel Sellers

www.mitchelsellers.com
Joined: 1/24/2007

Posts: 7846

Re: sqlexpress + plesk != ok

If you are using plesk or another managed system configuration, you must update the web.config file of your DNN installation to include the proper server, database, database user, and database password to connect to the database you created in Plesk rather than using the dynamically attached database.

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services

11/26/2007 2:19 PM

ulrik isaksson

Joined: 1/5/2006

Posts: 70

Re: sqlexpress + plesk != ok

What can the user/pass be for Database.mdf ... or is your point that i cant use sqlexpress here

Page 1 of 1

Home

Getting Started

Installing DNN ...

sqlexpress + plesk != ok

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file D:\inetpub\vhosts\arcticforum.se\httpdocs\App_Data\De.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

DNN Corp. (DotNetNuke)

New Community Website

CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file D:\inetpub\vhosts\arcticforum.se\httpdocs\App_Data\De.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

DNN Corp. (DotNetNuke)

CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file D:\inetpub\vhosts\arcticforum.se\httpdocs\App_Data\De.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.