Cannot open database "couch_db" requested by the login. The login failed... [error]

Question

Cannot open database "couch_db" requested by the login. The login failed... [error]

Jon80

SSCrazy

Points: 2598
More actions
August 26, 2010 at 1:41 am

#225200

I have this ASP.NET website running on my laptop (IIS 5.1/Win XP SP3/VS 2008 - .NET 3.5 SP1), and, I have added a datasource within Articles.aspx, that should connect to the local SQL Server (2005). However, when I build the page I get a a logon denied error, whilst, I can successfully connect and query information from within Visual Studio 2005 Debugger, using Windows Authentication.
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
EntryText:
<asp:Label ID="EntryTextLabel" runat="server" Text='<%# Eval("EntryText") %>' />
 
Timestamp:
<asp:Label ID="TimestampLabel" runat="server" Text='<%# Eval("Timestamp") %>' />
 
Attachment1:
<asp:Label ID="Attachment1Label" runat="server"
Text='<%# Eval("Attachment1") %>' />
 
Attachment2:
<asp:Label ID="Attachment2Label" runat="server"
Text='<%# Eval("Attachment2") %>' />
 
Attachment3:
<asp:Label ID="Attachment3Label" runat="server"
Text='<%# Eval("Attachment3") %>' />
 
 
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:couch_dbConnectionString2 %>"
SelectCommand="SELECT [EntryText], [Timestamp], [Attachment1], [Attachment2], [Attachment3] FROM [Articles]">
</asp:SqlDataSource>
Error
Server Error in '/Jon's Couch' Application.
Cannot open database "couch_db" requested by the login. The login failed.
Login failed for user 'ARMANI\ASPNET'.
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: Cannot open database "couch_db" requested by the login. The login failed.
Login failed for user 'ARMANI\ASPNET'.
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): Cannot open database "couch_db" requested by the login. The login failed.
Login failed for user 'ARMANI\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1297
System.Web.UI.WebControls.BaseDataList.GetData() +38
System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +153
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +54
System.Web.UI.WebControls.BaseDataList.DataBind() +55
System.Web.UI.WebControls.BaseDataList.EnsureDataBound() +60
System.Web.UI.WebControls.BaseDataList.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +44
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842
Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3614

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Does the database couch_db exist on the server you're trying to connect to? Does the login ARMANI\ASPNET have rights to that database?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jon80 SSCrazy Points: 2598 More actions · Answer 2

GilaMonster (8/26/2010)
Does the database couch_db exist on the server you're trying to connect to?
Yes
Does the login ARMANI\ASPNET have rights to that database?

I still have to check this somehow... 🙂

I never changed the ASPNET logon; any idea what the default password is? How do I check?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Jon-538504 (8/26/2010)
I never changed the ASPNET logon; any idea what the default password is? How do I check?

No idea, but why would you need it?

I assume you have some login (windows or SQL) that lets you connect to SQL Server? If so, log in with that then check the ASPNET login's permissions and mapping.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jon80 SSCrazy Points: 2598 More actions · Answer 4

I also tried running aspnet_regiis, however I get the following error:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql

Setup failed.

Exception:

Unable to connect to SQL Server database.

----------------------------------------

Details of failure

----------------------------------------

System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

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.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)

--- End of inner exception stack trace ---

at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)

at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)

at System.Web.Management.SqlServices.Install(String database, SqlFeatures features, String connectionString)

at System.Web.Management.ConfirmPanel.Execute()

Sean Lange SSC Guru Points: 286573 More actions · Answer 5

Is the sql server service running?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jon80 SSCrazy Points: 2598 More actions · Answer 6

SeanLange (8/26/2010)
Is the sql server service running?

Yes

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Dunno if you maybe missed my post

GilaMonster (8/26/2010)
I assume you have some login (windows or SQL) that lets you connect to SQL Server? If so, log in with that then check the ASPNET login's permissions and mapping.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jon80 SSCrazy Points: 2598 More actions · Answer 8

GilaMonster (8/26/2010)
Dunno if you maybe missed my post
GilaMonster (8/26/2010)
I assume you have some login (windows or SQL) that lets you connect to SQL Server? If so, log in with that then check the ASPNET login's permissions and mapping.

Well, it's not that I don't want to, but, I have no clue what to check for, since as far as I know, aspnet scripts out all the necessary settings within a command named aspnet_regiis.exe (Microsoft .NET Framework sub-folder).

Command log

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>prompt $g

>aspnet_regiis

Administration utility (2.0.50727) to install and uninstall ASP.NET on the

local machine.

-- ASP.NET REGISTRATION OPTIONS --

-i Install this version of ASP.NET and update scriptmaps at

the IIS metabase root and for all scriptmaps below the

root. Existing scriptmaps of lower version are upgraded to

this version.

-ir Install this version of ASP.NET, register only. Do not

update scriptmaps in IIS.

-iru Install this version of ASP.NET. If there are any existing

applications that uses ASP.NET, it will not update

scriptmaps in IIS.

-enable When -enable is specified with -i, -ir or -r, ASP.NET will

be enabled in the IIS security console (IIS 6.0 or later).

-disable When -disable is specified with -i, -ir or -r, ASP.NET will

be disabled in the IIS security console (IIS 6.0 or later).

-s <path> Install scriptmaps for this version at the specified path,

recursively.

E.g. aspnet_regiis.exe -s W3SVC/1/ROOT/SampleApp1

-sn <path> Install scriptmaps for this version at the specified path,

non-recursively.

-r Install this version of ASP.NET and update scriptmaps at

the IIS metabase root and for all scriptmaps below the

root. Existing scriptmaps are upgraded to this version

regardless of the original versions.

-u Uninstall this version of ASP.NET. Existing scriptmaps to

this version are remapped to highest remaining version of

ASP.NET installed on the machine.

-ua Uninstall all versions of ASP.NET on the machine.

-k <path> Remove all scriptmaps to any version of ASP.NET from the

specified path, recursively.

E.g. aspnet_regiis.exe -k W3SVC/1/ROOT/SampleApp1

-kn <path> Remove all scriptmaps to any version ASP.NET from the

specified path, non-recursively.

-lv List all versions of ASP.NET that are installed on the

machine, with status and installation path.

-lk List all the path of all IIS metabase keys where ASP.NET is

scriptmapped, together with the version. Keys that inherit

ASP.NET scriptmaps from a parent key will not be displayed.

-c Install the client side scripts for this version to the

aspnet_client subdirectory of each IIS site directory.

-e Remove the client side scripts for this version from the

aspnet_client subdirectory of each IIS site directory.

-ea Remove the client side scripts for all versions from the

aspnet_client subdirectory of each IIS site directory.

-ga <user> Grant the specified user or group access to the IIS

metabase and other directories used by ASP.NET.

-- CONFIGURATION ENCRYPTION OPTIONS --

-pe section Encrypt the configuration section. Optional arguments:

[-prov provider] Use this provider to encrypt.

[-app virtual-path] Encrypt at this virtual path. Virtual

path must begin with a forward slash. If it is '/', then it

refers to the root of the site. If -app is not specified,

the root web.config will be encrypted.

[-site site-name-or-ID] The site of the virtual path

specified in -app. If not specified, the default web site

will be used.

[-location sub-path] Location sub path.

[-pkm] Encrypt/decrypt the machine.config instead of

web.config.

-pd section Decrypt the configuration section. Optional arguments:

[-app virtual-path] Decrypt at this virtual path. Virtual

path must begin with a forward slash. If it is '/', then it

refers to the root of the site. If -app is not specified,

the root web.config will be decrypted.

[-site site-name-or-ID] The site of the virtual path

specified in -app. If not specified, the default web site

will be used.

[-location sub-path] Location sub path.

[-pkm] Encrypt/decrypt the machine.config instead of

web.config.

-pef section web-app-physical-dir

Encrypt the configuration section. Optional arguments:

[-prov provider] Use this provider to encrypt.

-pdf section web-app-physical-dir

Decrypt the configuration section.

-pc container Create an RSA keypair in ContainerName. Optional arguments:

[-size key-size] Key-size. Default is 1024.