Array
(
)

erro ao tentar conectar o banco

Shmathz
   - 10 abr 2008

Server Error in ´/ASP.NET/NewsDevmedia´ Application.
--------------------------------------------------------------------------------

Cannot open database ´NewsDevMedia´ requested by the login. The login failed.
Login failed for user ´DESIGN-9RS6SCED\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 ´NewsDevMedia´ requested by the login. The login failed.
Login failed for user ´DESIGN-9RS6SCED\ASPNET´.

Source Error:

Line 163:strLastError=ex.Message;
Line 164:else
Line 165:throw;
Line 166:}
Line 167:

Source File: d:\Aspnet\NewsDevmedia\App_Code\DAL\DBAccess.cs Line: 165

Ricardo Silva
   - 10 abr 2008

que erro Belisssiimo...

mas e ai???
qual la pergunta????

Shmathz
   - 10 abr 2008

Server Error in ´/ASP.NET/Store´ Application.
--------------------------------------------------------------------------------

The database ´ECommerce´ is not enabled for SQL cache notification.

To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications method, or the command line tool aspnet_regsql. To use the tool, please run ´aspnet_regsql.exe -?´ for more information.
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.Web.Caching.DatabaseNotEnabledForNotificationException: The database ´ECommerce´ is not enabled for SQL cache notification.

To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications method, or the command line tool aspnet_regsql. To use the tool, please run ´aspnet_regsql.exe -?´ for more information.

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:

[DatabaseNotEnabledForNotificationException: The database ´ECommerce´ is not enabled for SQL cache notification.

To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications method, or the command line tool aspnet_regsql. To use the tool, please run ´aspnet_regsql.exe -?´ for more information.]
System.Web.Caching.SqlCacheDependencyManager.EnsureTableIsRegisteredAndPolled(String database, String table) +3167471
System.Web.Caching.SqlCacheDependency.GetDependKey(String database, String tableName) +57
System.Web.Caching.SqlCacheDependency..ctor(String databaseEntryName, String tableName) +37
System.Web.Caching.SqlCacheDependency.CreateSql7SqlCacheDependencyForOutputCache(String database, String table, String depString) +39
System.Web.Caching.SqlCacheDependency.CreateOutputCacheDependency(String depString) +426
System.Web.UI.BasePartialCachingControl.Render(HtmlTextWriter output) +382
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +59
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +68
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +37
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
System.Web.UI.Page.Render(HtmlTextWriter writer) +26
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558

Ricardo Silva
   - 10 abr 2008

shmathz Vixi...

Precisamos saber em q momento acontece esta exeção (Open, select, UpDate, Delete, Close)....
esta parecendo q ta faltando um serviço do SQLServer

Citação:

To enable a database for SQL cache notification, please use the System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications method, or the command line tool aspnet_regsql. To use the tool, please run ´aspnet_regsql.exe -?´ for more information.


provavelmente vc tera q registrar o SQL na sua maquina atravez desse executavel ´aspnet_regsql.exe.

Na duvida Tira o Pé....

Shmathz
   - 10 abr 2008

Este erro aparece quando tento abrir a pagina default.aspx

Shmathz
   - 10 abr 2008

E também criei as tabelas no aspnet_regsql.exe e funcionou, criei os usuários tambem deu certo, mas quando tento rodar a pagina default no browser da este erro que enviei.
At
Vladimir

Ricardo Silva
   - 10 abr 2008

e o que tem na Pagina Default...(SqlDataSource, SqlConnection)
vc executa as consulta na mão ou usa algum componente???

Shmathz
   - 10 abr 2008

Na pagina default.aspx tem
Sitemapdatasource
Objectdatasource
Login
Se não me engano pois não conheço muito estou aprendendo tem store procedure(esta é a loja modelo do fabio galente mans) que estou estudando e tentando fazer rodar em minha maquina.
At
Vladimir

Ivan.c#
   - 10 abr 2008

Esse erro, é erro de autenticação do SQL;

Como esta sua string de coneção com BD?