mii Marko Markovic podgorica
Član broj: 54936 Poruke: 102 195.66.163.*
|
PRI PODIZANJU SVOJE PRVE BAZE KOJA JE DOSLA UZ KNJIGU RAZVOJ WEB APLIKACIJA MICROSOFT VISUAL BASIC.NET I VISULA C#.NET ,NA MOM BROWSERU SE JAVLJA:
Server Error in '/WebApplication11' Application.
--------------------------------------------------------------------------------
Login failed for user 'LJUBOMIR_IVAN\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: Login failed for user 'LJUBOMIR_IVAN\ASPNET'.
Source Error:
Line 29: {
Line 30: // Put user code to initialize the page here
Line 31: sqlDataAdapter1.Fill(dataSet11);
Line 32: DataGrid1.DataBind();
Line 33: }
Source File: c:\inetpub\wwwroot\webapplication11\webform1.aspx.cs Line: 31
Stack Trace:
[SqlException: Login failed for user 'LJUBOMIR_IVAN\ASPNET'.]
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
WebApplication11.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapplication11\webform1.aspx.cs:31
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
AKO MI NEKO MOZE RECI KAKO DA RIJESIM OVAJ PROBLEM???
|
|
| |
|
dusans Stojanov Dušan Pančevo
Član broj: 9551 Poruke: 1343 212.200.27.*
|
Problem je u connection stringu koji koristiš za pristup bazi. Pošto ti je trenutno postavljena Windows autentifikacija korisničkom nalogu LJUBOMIR_IVAN\ASPNET pod kojim se izvršava tvoja web aplikacija nije dozvoljen pristup na SQL Serveru. Dakle, ili dodaj ovaj nalog na SQL Serveru i daj mu pravo pristupa na bazu ili jednostavnije, promeni u connection stringu autentifikaciju sa korisničkim imenom i lozinkom (sa, lozinka koju si postavio).
|
|
| |
|
mii Marko Markovic podgorica
Član broj: 54936 Poruke: 102 *.crnagora.net.
|
Ne sumnjam u ispravnost tvoga odgovora ,ali posto sma pocetnik moras mi jos nesto reci:connesction string
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "data source=IVAN;initial catalog=Contacts;integrated security=SSPI;persist securi" +
"ty info=False;workstation id=IVAN;packet size=4096";
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Contacts", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ContactID", "ContactID"),
,kazes da ovdje treba da se promeni tj da se doda autentifikacija,kako???,ja sma na mom racunaru podigao MSDE server i kada sma ga instalirao samo saM u folder MSDERela ukucai SAPWD="123456" I RESTAROVAO RACUNAR i podiao ga sada SA ja mislim se koristi samo za sql server,znam da je msde osiromasen sql, umom odgovoru vidis code connection strinG pa ako mozes dodaj to (u prvom pitanju racunar se zvao LJUBOMIR_IVAN a sada samo IVAN,drugi racunar),ili ako imas neko drugo resenje neki drugi sql server sa nekim drugim savjetom RECI,koristim VISUAL STUDIO.NET
HVALA
|
|
| |
|