最佳解答者
"User does not have permission to perform this action" when add new mdf in VS2008

問題
-
I am running VS2008 with SQL Express 2008.
I created an ASP.NET Folder, App_Data. And then I add new item, in the "add New Item" windows, I selected SQL Server Database and click Add button. Then the message ""User does not have permission to perform this action"" pop up.
I am sure that my current acct has sa right. And the SQL Express 2008 is configured in Mixed mode.
I tried to open SQL Management Studio and I can create a testing DB.
Anything that I need to do in VS?
大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP2009年8月17日 上午 07:34
解答
-
still cannot solve it.
大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP- 已標示為解答 Ken Lin, MSMVP for .NET (2003-2017), rMVP 2010年3月30日 上午 04:23
2010年3月26日 上午 09:06
所有回覆
-
1,pls install Visual Studio 2008 SP1
2,check ConnectionStrings is right
3.check SQLExpress Service is running
4,try install
Microsoft SQL Server 2008 Management Objects from
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1
【孟子E章】- 已標示為解答 Ken Lin, MSMVP for .NET (2003-2017), rMVP 2010年3月26日 上午 09:06
- 已取消標示為解答 Ken Lin, MSMVP for .NET (2003-2017), rMVP 2010年3月26日 上午 09:06
2009年9月2日 下午 01:27 -
1,pls install Visual Studio 2008 SP1
2,check ConnectionStrings is right
3.check SQLExpress Service is running
4,try install
Microsoft SQL Server 2008 Management Objects from
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1
【孟子E章】
1) Already is VS2008 SP1, version 9.0.30729.1
2) ConnectionString is correct, cause now I tried to be connecting to SQL Express by SQLDataSource
3) It is runing
4) Installed.
But still cannot make it.
大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP2009年9月4日 上午 09:35 -
still cannot solve it.
大家一齊探討、學習和研究,謝謝! Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA, MCTS, MCITP- 已標示為解答 Ken Lin, MSMVP for .NET (2003-2017), rMVP 2010年3月30日 上午 04:23
2010年3月26日 上午 09:06