Showing posts with label failed. Show all posts

Tuesday, March 27, 2012

Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

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

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.sql

Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

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

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.

Sunday, March 11, 2012

An error occurred while starting mirroring?

How can I troubleshoot this?
Olav
An error occurred while starting mirroring.
ADDITIONAL INFORMATION:
Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The server network address "TCP://lion.safari.webinnovation.no:5022" can not
be reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)
Hi
"Olav" wrote:

> How can I troubleshoot this?
> Olav
> An error occurred while starting mirroring.
> --
> ADDITIONAL INFORMATION:
> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The server network address "TCP://lion.safari.webinnovation.no:5022" can not
> be reached or does not exist. Check the network address name and that the
> ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
>
There are many posts on this error! Did you check out
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
John
|||The problem was that the Mirror database was not restored with the
NORECOVERY option.
Olav
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:20CFB426-D745-4F01-A71F-E629A3F70055@.microsoft.com...
> Hi
> "Olav" wrote:
> There are many posts on this error! Did you check out
> http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
> http://msdn2.microsoft.com/en-us/library/ms189127.aspx
> John

An error occurred while starting mirroring?

How can I troubleshoot this?
Olav
An error occurred while starting mirroring.
ADDITIONAL INFORMATION:
Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The server network address "TCP://lion.safari.webinnovation.no:5022" can not
be reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)Hi
"Olav" wrote:

> How can I troubleshoot this?
> Olav
> An error occurred while starting mirroring.
> --
> ADDITIONAL INFORMATION:
> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The server network address "TCP://lion.safari.webinnovation.no:5022" can n
ot
> be reached or does not exist. Check the network address name and that the
> ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
>
There are many posts on this error! Did you check out
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
John|||The problem was that the Mirror database was not restored with the
NORECOVERY option.
Olav
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:20CFB426-D745-4F01-A71F-E629A3F70055@.microsoft.com...
> Hi
> "Olav" wrote:
>
> There are many posts on this error! Did you check out
> http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
> http://msdn2.microsoft.com/en-us/library/ms189127.aspx
> John

An error occurred while starting mirroring?

How can I troubleshoot this?
Olav
An error occurred while starting mirroring.
--
ADDITIONAL INFORMATION:
Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The server network address "TCP://lion.safari.webinnovation.no:5022" can not
be reached or does not exist. Check the network address name and that the
ports for the local and remote endpoints are operational. (Microsoft SQL
Server, Error: 1418)Hi
"Olav" wrote:
> How can I troubleshoot this?
> Olav
> An error occurred while starting mirroring.
> --
> ADDITIONAL INFORMATION:
> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The server network address "TCP://lion.safari.webinnovation.no:5022" can not
> be reached or does not exist. Check the network address name and that the
> ports for the local and remote endpoints are operational. (Microsoft SQL
> Server, Error: 1418)
>
There are many posts on this error! Did you check out
http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
http://msdn2.microsoft.com/en-us/library/ms189127.aspx
John|||The problem was that the Mirror database was not restored with the
NORECOVERY option.
Olav
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:20CFB426-D745-4F01-A71F-E629A3F70055@.microsoft.com...
> Hi
> "Olav" wrote:
>> How can I troubleshoot this?
>> Olav
>> An error occurred while starting mirroring.
>> --
>> ADDITIONAL INFORMATION:
>> Alter failed for Database 'Commerce'. (Microsoft.SqlServer.Smo)
>> --
>> An exception occurred while executing a Transact-SQL statement or batch.
>> (Microsoft.SqlServer.ConnectionInfo)
>> --
>> The server network address "TCP://lion.safari.webinnovation.no:5022" can
>> not
>> be reached or does not exist. Check the network address name and that the
>> ports for the local and remote endpoints are operational. (Microsoft SQL
>> Server, Error: 1418)
>>
> There are many posts on this error! Did you check out
> http://msdn2.microsoft.com/en-us/library/aa337361.aspx and
> http://msdn2.microsoft.com/en-us/library/ms189127.aspx
> John

Wednesday, March 7, 2012

An attempt to attach an auto-named database for file failed.

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

http://pastecode.com/6196

When I am setting up the data source for the gridview tool, everything works fine and the test query works fine, but then when I try to actually test the output in the browser with Cntrl+F5 I get this error.

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Make sure the file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test.mdf failedis not being used by other process. If it is the data file of some database in the SQL instance, you can't attach it by using AttachDBFileName property in the connection string.|||How do I do make sure it's not being used by an other process?|||

In other words, make sure it has not been attached in any SQL instance, and no other application is using it to create a connection.

|||

Thanks for your help so far.

But, how do I do that? How can I tell if another application is using 'it' to create a connection? I am using Visual Web Developer and SQL Server Management Studio Express and SQL Server Configuration Manager. Also when I hit 'Cntrl+F5' while in Visual Web Developer the page opens up in Firefox (my default browser).

I am not using the database for anything else. I have no idea how to monitor SQL instances. I am just beginning to learn these things and am working with tutorials that aren't working for me.

|||

First of all, you aren't crazy or a no brained soul. This is not you. This is quirkiness in how Microsoft (and I am their biggest fan), in trying to make things easier, has somehow made CHANGES to your SQL environment difficult. I am working on sorting this out and creating some kind of a flow chart to troubleshoot all of this, but here are some insights in the meantime (Gurus - please correct me where I am wrong on any of this):

* ASPNETDB.MDF seems to occur for every ASP.NET application and should appear in the |DataDirectory| - which is normally(?/automatically?) APP_DATA

* I think it gets automatically created the first time you run your app (because it seems to me to not be there, then suddenly appear) but it may be under program control - I don't know

* if you have an instance that has been named ASPNETDB or ASPNETDB.MDF in your Sql database, connecting a new one will fail as a duplicate, so use Sql Management Studio to rename any such instances to something unique, like "c:\Webs\PartnerPortal\Northwind Traders\App_Data\ASPNETDB.MDF" instead of just "ASPNETDB.MDF"

* In my environment I have several named instances of Sql Server, including: "STARTEAM" (a Borland created named instance), "OFFICESERVER" "SQLEXPRESS" "MSSQLSERVER" and "MICROSOFT##SSEE" (Mobile edition). However, none of these are useful to me. I have uninstalled SQLSERVER (SQL 2000) and SQLEXPRESS. The one I NEED does not appear - which is the unnamed instance - SQL Enterprise 2005. To access that all I do is enter the server name, ip or .\

* I was using Microsoft Expression Web to edit the default connection string (and this is identical in Server Explorer in VS 2005 also). It asks you the provider. I was using the defaul and could not enter .\ as my Sql Server. I only had the other useless named instances and could not successfully connect. SOOOO I changed the provider. I had two choices:

"Microsoft Sql Server" and "Microsoft Sql Server Database File" (along with "Sql Server Mobile Editiion", etc).

* I changed my selection FROM "Microsoft Sql Server" TO "Microsoft Sql Server Database File". This allowed me to edit the server to be .\ when I went back to my connection string

* Then I changed the provider BACK and now I had the choice I needed! I think that the choice are coming from the registry and it got out of sync

Anyway, now I can connect. I think that connectionString updates the registry, where the problems lie.

*************************************************
Here is the skinny on troubleshooting connections:
*************************************************

(1) have you run aspnet_regsql from a command prompt at the c:\windows\Microsoft.net Framework v2xxx directory?

(2) did you create a virtual directory for your app and enable Asp?
(I have a separate memory pool for each version of Asp - another matter)

(3) did you change the Asp settings to the right connection string? The important things are: .\SQLEXPRESS or .\ or your named instance. If you do not use SQLEXPRESS then User Instance must be False

(4) are all of your instances of ASPNETDB.mdf named uniquely? (Ie: include a path)

(5) does IIS_WPG have sufficient rights to your web directory (this may not be true if you put your webs in your "My Documents")

(6) In VS2005, did you go to Websited-Asp config?

(7) Do you have the right settings in your Web.config?

(8) You must not have extraneous copies of Web.config on your path - they will be automatically referenced in the project. Ie, creating a backup in a subdir, is trouble.

(9) did you set your Default.aspx as the Startup page? (and the right project as the startup project if you have multiple projects?)

(10) did you use Server Explorer to try a different provider, update the registry choices of servers and to include your unnamed instance, per above?

Does Machine.config figure into this?

What have I missed or misstated?

To be honest, having done all of this, I still seem to have a web that I am still troubleshooting the connection for!

****
If anyone can correct, add or improve on the above, please do. What i would love to see is a Visio flowchart in a .pdf that could be emblazoned here. I can be reached at my gmail account of norisksoftware at gmail . com
AND I am looking for contract work doing almost anything technical (web, C#, consulting, Cobol, EDI..) that pays well. I was out of the country for 2 1/2 years and my business kind of dried up. Go figure.

Bill Ross

|||Hi Bill, by default .NET 2.0 security providers(membership, profile, ect.) use a connection string named LocalSqlServer, to learn more details you can take a look at this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

An attempt to attach an auto-named database for file failed

I have a problem when I want to open a page with the database record. This page is created in Visual Web Developer 2005 Express. When I try to open a page I get the following error message even though the connection between the database is ok:

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I have a computer with Windows XP Professional running IIS 5.1 and ASP.NET 2.0.
Also I have SQL Express on my machine.
Does any one know how to resolve it.
Thanks Smile [:)]

Here is the entire error message that I am getting:

Server Error in '/membership' Application.

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

|||

This is what I found in the event viewer:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 1/24/2006
Time: 5:17:15 PM
User: N/A
Computer: DEVELOMPMENT-CO
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/24/2006 5:17:15 PM
Event time (UTC): 1/24/2006 10:17:15 PM
Event ID: 29652843fd234fc6a5a00bd4f9652894
Event sequence: 4
Event occurrence: 3
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT/membership-7-127826143653860928
Trust level: Full
Application Virtual Path: /membership
Application Path: C:\Inetpub\wwwroot\membership\
Machine name: DEVELOMPMENT-CO

Process information:
Process ID: 2724
Process name: aspnet_wp.exe
Account name: DEVELOMPMENT-CO\ASPNET

Exception information:
Exception type: SqlException
Exception message: An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Request information:
Request URL:http://localhost/membership/Login.aspx
Request path: /membership/Login.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: DEVELOMPMENT-CO\ASPNET

Thread information:
Thread ID: 1
Thread account name: DEVELOMPMENT-CO\ASPNET
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate)
at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
at System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate)
at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved)
at System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password)
at System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e)
at System.Web.UI.WebControls.Login.AttemptLogin()
at System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

This is the connection string:

<addname="Membership"connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True;AttachDbFilename=|DataDirectory|aspnetdb.mdf;"

providerName="System.Data.SqlClient" />

</connectionStrings>

Thanks for any responses.

|||

More information about this error. My web site works fine when I run it on this built in Asp.net Developer Server that comes with Visual Web Developer. I don't know why it doesn't work on my IIS 5.1 Server.

Any suggestions?

|||

Hi,

The following URL has some explainations and things to try with this error

http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

Hope that helps,

Lan

An attempt to attach an auto-named database for file C:\... failed

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

Source Error:

http://pastecode.com/6196

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Hi,

I guess you want to attach a user instance to SQL Server. But the path specified for the user instance is a server attached instance, which makes you able to view the data through the server explorer but won′t make you able to use the run the code, because at startup VS will try to create a user instance at the location specified (which is already occupied by the server instance database) and which will fail. The solution is to specify another folder to create the suer attached instance during the build of the code, thats all. That should make you able to run the build process as well as the code.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Try this in the config file ...

Data Source=.\SQLEXPRESS;AttachDBFilename=C:\...\db.mdf;User Instance=true

An attempt to attach an auto-named database for file C:\... failed

Hi,

I recently installed VS Web Developer Express Ediition and SQL Server Express and I'm doing the How To tutorials and I can't finish the basic data access walkthrough:

http://msdn2.microsoft.com/en-US/library/tw738475.aspx

Because I get an error like this (link for complete error below):

Source Error:

http://pastecode.com/6196

I have been trying for 48 hours to find a solution on my own. I have googled, I have searched everything and I just am at a point where I think I need to ask someone for help.

Please help.

Hi,

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Try this in the config file ...

Data Source=.\SQLEXPRESS;AttachDBFilename=C:\...\db.mdf;User Instance=true

An attempt to attach an auto-named database failed

I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
same name exists, or specified file cannot be opened, or it is located on UNC
share.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
"Uri Dimant" wrote:
> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> > same name exists, or specified file cannot be opened, or it is located on
> > UNC
> > share.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me two
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:
> Assuming you are using the default settings, the .mdf and .ldf files must be
> located in the same directory as your application on the server. The other
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> > same name exists, or specified file cannot be opened, or it is located on
> > UNC
> > share.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
>> Assuming you are using the default settings, the .mdf and .ldf files must
>> be
>> located in the same directory as your application on the server. The
>> other
>> common cause for this is having the database open in the IDE or having
>> the
>> database files with no write permissions for the ASPNET account. There
>> is
>> more info here:
>> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Noah" <Noah@.discussions.microsoft.com> wrote in message
>> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>> >I have a problem with Microsoft SQL Server 2005 Express,
>> > My web application runs fine on my development PC, but when I copy it
>> > to
>> > my
>> > server (My server is running Windows 2000 Server) and try to access it
>> > from
>> > the web I get following error:
>> >
>> > An attempt to attach an auto-named database for file
>> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with
>> > the
>> > same name exists, or specified file cannot be opened, or it is located
>> > on
>> > UNC
>> > share.
>> >
>> > The ASPNET account has full control of the database.
>> > Is this a known bug in Microsoft SQL Server?
>> > What should I do?
>> >
>> > Thanks for your help in advance,
>> >
>> > Noah.
>> >
>>|||Yes.
"Roger Wolter[MSFT]" wrote:
> So, you eliminated one of the three things I suggested. How about the other
> two? Di reading the article give you any things to try?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> > As I said... The ASPNET account has full control of the database and of
> > the
> > application root folder.
> > Read, Write, Modify, etc.
> > I thought that was the problem, but it isn't. I had already given the
> > ASPNET
> > account full control when I had problems with a hit counter. That took me
> > two
> > days to figure out...
> > Anyway,
> > With the info you have now what do you suggest I do?
> >
> > Thanks,
> > Noah.
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> Assuming you are using the default settings, the .mdf and .ldf files must
> >> be
> >> located in the same directory as your application on the server. The
> >> other
> >> common cause for this is having the database open in the IDE or having
> >> the
> >> database files with no write permissions for the ASPNET account. There
> >> is
> >> more info here:
> >>
> >> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
> >>
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> >> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >> >I have a problem with Microsoft SQL Server 2005 Express,
> >> > My web application runs fine on my development PC, but when I copy it
> >> > to
> >> > my
> >> > server (My server is running Windows 2000 Server) and try to access it
> >> > from
> >> > the web I get following error:
> >> >
> >> > An attempt to attach an auto-named database for file
> >> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with
> >> > the
> >> > same name exists, or specified file cannot be opened, or it is located
> >> > on
> >> > UNC
> >> > share.
> >> >
> >> > The ASPNET account has full control of the database.
> >> > Is this a known bug in Microsoft SQL Server?
> >> > What should I do?
> >> >
> >> > Thanks for your help in advance,
> >> >
> >> > Noah.
> >> >
> >>
> >>
> >>
>
>

Tuesday, March 27, 2012

Analysis Services - Step by Step: Errors related to feature availability and configuration

Analysis Services - Step by Step: Errors related to feature availability and configuration

Sunday, March 11, 2012

An error occurred while starting mirroring?

An error occurred while starting mirroring?

An error occurred while starting mirroring?

Wednesday, March 7, 2012

An attempt to attach an auto-named database for file failed.

An attempt to attach an auto-named database for file failed

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Server Error in '/membership' Application.

An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\membership\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

An attempt to attach an auto-named database for file C:\... failed

An attempt to attach an auto-named database for file C:\... failed

An attempt to attach an auto-named database failed

An attempt to attach an auto-named database failed

An attempt to attach an auto-named database failed

SQL Alternative to cursor

Blog Archive

About Me