erro ao tentar conectar o banco

10/04/2008

0

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


Shmathz

Shmathz

Responder

Posts

10/04/2008

Ricardo Silva

que erro Belisssiimo...

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


Responder

10/04/2008

Shmathz

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


Responder

10/04/2008

Ricardo Silva

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
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é....


Responder

10/04/2008

Shmathz

Este erro aparece quando tento abrir a pagina default.aspx


Responder

10/04/2008

Shmathz

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


Responder

10/04/2008

Ricardo Silva

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


Responder

10/04/2008

Shmathz

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


Responder

10/04/2008

Ivan.c#

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

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


Responder

Assista grátis a nossa aula inaugural

Assitir aula

Saiba por que programar é uma questão de
sobrevivência e como aprender sem riscos

Assistir agora

Utilizamos cookies para fornecer uma melhor experiência para nossos usuários, consulte nossa política de privacidade.

Aceitar