![]()
Why am i getting "SQL Server does not exist or access denied" error
Reply
![]() |
|
From:
![]() ![]() SaiCharan4u
|
remove @ symbol at server= and do once i feel it will work
SaiCharan.M
>From: "naarumanchi" <[EMAIL PROTECTED]>
>Reply-To: "dotNET User Group Hyd" <[email protected]>
>To: [email protected]
>Subject: Why am i getting "SQL Server does not exist or access denied"
>error
>Date: Tue, 20 Dec 2005 00:46:14 -0800
>
>
>
>
>
>
>
>
>
>
>
>
> New Message on dotNET User Group Hyd
>
>
>
>
>
>
>
> Why am i getting "SQL Server does not exist or access denied" error
>
>
>
>
> Reply
>
>
>
>
>
> Reply to Sender
> Recommend
>
> Message 1 in Discussion
>
>
>
>
>
>
>
> From:
> naarumanchi
>
>
>
>
> Hi i am vidyakumar
>
>I am working on C# and ASP.NET.
>
>While binding the data to a grid i am getting a strange runtime error
>
>ie; SQL Server does not exist or access denied
>
>eventhough my server is running and the connection string is correct the
>problem still persists i tried all the possable ways but i failed.
>
>I Am sending the coad as well as the error message please help me in this
>matter.
>
>Here the CODE:-
>----------------------------------------------------------------------------------------------------------------------------------------
>
>using System;
>using System.Collections;
>using System.ComponentModel;
>using System.Data;
>using System.Drawing;
>using System.Web;
>using System.Web.SessionState;
>using System.Web.UI;
>using System.Web.UI.WebControls;
>using System.Web.UI.HtmlControls;
>using System.Data.SqlClient;
>using System.Data.OleDb;
>namespace Employee
>{
> /// <summary>
> /// Summary description for Worksetup1.
> /// </summary>
> public class Worksetup1 : System.Web.UI.Page
> {
> protected System.Web.UI.WebControls.DataGrid gridworksetup;
> protected System.Web.UI.HtmlControls.HtmlInputButton btnAdd;
> protected System.Web.UI.HtmlControls.HtmlInputButton btnEdit;
> protected System.Web.UI.HtmlControls.HtmlInputButton btnDelete;
> protected System.Web.UI.HtmlControls.HtmlInputHidden txtFullHid;
> SqlConnection con;
>
> private void Page_Load(object sender, System.EventArgs e)
> {
> // Put user code to initialize the page here
>
> // Put user code to initialize the page here
> /*DataView dvResult = (DataView)CreateDataSource();
> gridworksetup.DataSource = dvResult;
> gridworksetup.DataBind();
> */
> Worksetup();
>
> }
>
> public void Worksetup()
> {
>
> gridworksetup.DataSource =
>CreateDataSource(gridworksetup.CurrentPageIndex);
> gridworksetup.DataBind();
>
> }
>
> private SqlDataReader CreateDataSource(int nPageIndex)
> {
> SqlDataReader dr;
> // Page index is assumed to be 0-based
> int nPageSize = gridworksetup.PageSize;
> int nBaseProductID = nPageSize * nPageIndex;
>
> // Set up the connection
> string connectionString =
>"[EMAIL PROTECTED];database=employeedetails;integrated
>security=true;uid=sa;pwd=";
> con = new SqlConnection(connectionString);
>
>
> // Set up the command
> string SQLSelect;
> SQLSelect = "SELECT * FROM Worksetup_details ";
> SqlCommand cmd =new SqlCommand(SQLSelect,con);
>
>
> // Execute the command
> con.Open();
> dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
> return dr;
> }
>
> #region Web Form Designer generated code
> override protected void OnInit(EventArgs e)
> {
> //
> // CODEGEN: This call is required by the ASP.NET Web Form Designer.
> //
> InitializeComponent();
> base.OnInit(e);
> }
>
> /// <summary>
> /// Required method for Designer support - do not modify
> /// the contents of this method with the code editor.
> /// </summary>
> private void InitializeComponent()
> {
> this.Load += new System.EventHandler(this.Page_Load);
>
> }
> #endregion
>
> private void gridworksetup_SelectedIndexChanged(object sender,
>System.EventArgs e)
> {
> /*con.Open();
> string SQLSelect;
> SQLSelect = "SELECT * FROM Worksetup_details ";
> SqlCommand cmd =new SqlCommand(SQLSelect,con);
>
> SqlDataReader dr = cmd.ExecuteReader();
> dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
> return dr;
> gridworksetup.DataSource = CreateDataSource();
> gridworksetup.DataBind();
> dr.Close();
> */
>
> }
>
> }
>}
>
>
>Here the error message:-
>-------------------------------------------------------------------------------------------------------------------------------------------
>
>Server Error in '/Employee' Application.
>--------------------------------------------------------------------------------
>
>SQL Server does not exist or access denied.
>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: SQL Server does not
>exist or access denied.
>
>Source Error:
>
>
>Line 65:
>Line 66: // Execute the command
>Line 67: con.Open();
>Line 68: dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
>Line 69: return dr;
>
>
>Source File: d:\inetpub\wwwroot\employee\worksetup.aspx.cs Line: 67
>
>Stack Trace:
>
>
>[SqlException: SQL Server does not exist or access denied.]
> System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
>isInTransaction)
>
>System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
>options, Boolean& isInTransaction)
> System.Data.SqlClient.SqlConnection.Open()
> Employee.Worksetup1.CreateDataSource(Int32 nPageIndex) in
>d:\inetpub\wwwroot\employee\worksetup.aspx.cs:67
> Employee.Worksetup1.Worksetup() in
>d:\inetpub\wwwroot\employee\worksetup.aspx.cs:43
> Employee.Worksetup1.Page_Load(Object sender, EventArgs e) in
>d:\inetpub\wwwroot\employee\worksetup.aspx.cs:36
> System.Web.UI.Control.OnLoad(EventArgs e)
> System.Web.UI.Control.LoadRecursive()
> System.Web.UI.Page.ProcessRequestMain()
>
>
>
>
>--------------------------------------------------------------------------------
>Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
>Version:1.1.4322.573
>-------------------------------------------------------------------------------------------------------------------------------------------
>
>My server name is "HAPPYHOM-576F99" and i used the Mixed mode for SqlServer
>Authentication.
>
>
>Please help me
>
>Its very urgent
>
>please help me by providing a solution
>
>Thanks in Advance
>
>Regards
>Vidyakumar
>
>_________________________________________________________________
>A Camera Sells every 2 Minutes on eBay. Get Your's at a Great Price Now!
>http://adfarm.mediaplex.com/ad/ck/4686-26272-10936-699?ck=Cameras
>
>
>
>
>
>
>
>
> View other groups in this category.
>
>
>
>
>
>
>
>
>
>
>
>
>
>Also on MSN:
>Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily
>Horoscopes
>
>
>
>
>
>
>
>
>
>
> To stop getting this e-mail, or change how often it
>arrives, go to your E-mail Settings.
>
>
> Need help? If you've forgotten your password, please go
>to Passport Member Services.
>
> For other questions or feedback, go to our Contact Us
>page.
>
>
> If you do not want to receive future e-mail from this
>MSN group, or if you received this message by mistake, please click the
>"Remove" link below. On the pre-addressed e-mail message that opens, simply
>click "Send". Your e-mail address will be deleted from this group's mailing
>list.
>
>
> Remove my e-mail address from dotNET User Group Hyd.
>
>
>
>
>
>
>
_________________________________________________________________
Sexy, sultry, sensuous. - see why Bipasha Basu is all that and more. Try MSN
Search http://server1.msn.co.in/Profile/bipashabasu.asp
|
|
View other groups in this category.
![]() |
To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings.
Need help? If you've forgotten your password, please go to Passport Member Services.
For other questions or feedback, go to our Contact Us page.
If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list.
Remove my e-mail address from dotNET User Group Hyd.
|
|
