sqlexpress + plesk != ok - Install It!

Forum General DotNetN... Install It! sqlexpress + plesk != ok

10/28/2007 4:12 AM

	ulrik isaksson
49 posts

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 2:39 AM

	ulrik isaksson
49 posts

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 9:56 AM

	Mitch Sellers
5372 posts
www.mitchelsellers.com

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
MCITP, MCPD, MCTS
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 Consulting Quotes, and DNN Technical Support Services

I reccomend 3Essentials for shared hosting and BaseCamp for project management

11/26/2007 10:19 AM

	ulrik isaksson
49 posts

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

Forum

General DotNetN...

Install It!

sqlexpress + plesk != ok

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.

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.