SQL Server does not exist or access denied.

[hooi]

I'm new to Visual Studio.NET and Visual Basic.NET. While trying to run the
sample application, it shows an error message as shown below. I have an SQL
Server containing the sample database Northwind used in this application.
Authentication mode set in Web.config is Windows; Mixed mode in the SQL
Server. Any idea how I can resolve this problem? Thanks...

Server Error in '/HowToBuildAWebD ataEntryApp' 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.Sql Client.SqlExcep tion: SQL Server does not
exist or access denied.

Source Error: (Note: highlighted on line 201)

Line 199: Dim scnnNW As New SqlConnection(S QL_CONNECTION_S TRING)
Line 200: Dim scmd As New SqlCommand(strS QL, scnnNW)
Line 201: scnnNW.Open()
Line 202: scmd.ExecuteNon Query()
Line 203: scnnNW.Close()

Source File: C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb
Line: 201

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
HowToBuildAWebD ataEntryApp.Mai n.SetupDemo() in
C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb:2 01
HowToBuildAWebD ataEntryApp.Mai n.Page_Load(Obj ect sender, EventArgs e) in
C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb:1 63
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +731

----------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET
Version:1.1.432 2.573

[Cowboy \(Gregory A. Beamer\)]

Check the user name and password. Make sure SQL Server is running in mixed
mode. Also, make sure you have the right server name.

What version of SQL Server? With 6.5, you will want to look at this:
http://support.microsoft.com/default...;EN-US;q315159

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"hooi" <se******@hotpo p.com> wrote in message
news:eC******** ********@TK2MSF TNGP12.phx.gbl. ..

I'm new to Visual Studio.NET and Visual Basic.NET. While trying to run the sample application, it shows an error message as shown below. I have an SQL Server containing the sample database Northwind used in this application.
Authentication mode set in Web.config is Windows; Mixed mode in the SQL
Server. Any idea how I can resolve this problem? Thanks...

Server Error in '/HowToBuildAWebD ataEntryApp' 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.Sql Client.SqlExcep tion: SQL Server does not
exist or access denied.

Source Error: (Note: highlighted on line 201)

Line 199: Dim scnnNW As New SqlConnection(S QL_CONNECTION_S TRING)
Line 200: Dim scmd As New SqlCommand(strS QL, scnnNW)
Line 201: scnnNW.Open()
Line 202: scmd.ExecuteNon Query()
Line 203: scnnNW.Close()

Source File: C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb
Line: 201

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c tionString options, Boolean& isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
HowToBuildAWebD ataEntryApp.Mai n.SetupDemo() in
C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb:2 01
HowToBuildAWebD ataEntryApp.Mai n.Page_Load(Obj ect sender, EventArgs e) in C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb:1 63
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +731

-------------------------------------------------------------------------- -- Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET Version:1.1.432 2.573

[Cowboy \(Gregory A. Beamer\)]

Check the user name and password. Make sure SQL Server is running in mixed
mode. Also, make sure you have the right server name.

What version of SQL Server? With 6.5, you will want to look at this:
http://support.microsoft.com/default...;EN-US;q315159

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** *************** **********
Think Outside the Box!
*************** *************** *************** *************** **********
"hooi" <se******@hotpo p.com> wrote in message
news:eC******** ********@TK2MSF TNGP12.phx.gbl. ..

I'm new to Visual Studio.NET and Visual Basic.NET. While trying to run the sample application, it shows an error message as shown below. I have an SQL Server containing the sample database Northwind used in this application.
Authentication mode set in Web.config is Windows; Mixed mode in the SQL
Server. Any idea how I can resolve this problem? Thanks...

Server Error in '/HowToBuildAWebD ataEntryApp' 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.Sql Client.SqlExcep tion: SQL Server does not
exist or access denied.

Source Error: (Note: highlighted on line 201)

Line 199: Dim scnnNW As New SqlConnection(S QL_CONNECTION_S TRING)
Line 200: Dim scmd As New SqlCommand(strS QL, scnnNW)
Line 201: scnnNW.Open()
Line 202: scmd.ExecuteNon Query()
Line 203: scnnNW.Close()

Source File: C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb
Line: 201

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) +472

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c tionString options, Boolean& isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
HowToBuildAWebD ataEntryApp.Mai n.SetupDemo() in
C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb:2 01
HowToBuildAWebD ataEntryApp.Mai n.Page_Load(Obj ect sender, EventArgs e) in C:\Inetpub\wwwr oot\HowToBuildA WebDataEntryApp \main.aspx.vb:1 63
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +731

-------------------------------------------------------------------------- -- Version Information: Microsoft .NET Framework Version:1.1.432 2.573; ASP.NET Version:1.1.432 2.573

[Yap Seng Hooi]

Thank you Cowboy for your reply

I'm using SQL Server 2000, Visual Studio.NET 2003. The SQL Server is set to mixed mode

When you say 'must have the right Server name', my SQL server name is "NB", do I have to reference it in my main.aspx? My sqlconnection string in the main.aspx is as follows

protected const string SQL_CONNECTION_ STRING =
"Server=localho st;" +
"DataBase=north wind;" +
"Integrated Security=SSPI"
---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/

[Yap Seng Hooi]

Thank you Cowboy for your reply

I'm using SQL Server 2000, Visual Studio.NET 2003. The SQL Server is set to mixed mode

When you say 'must have the right Server name', my SQL server name is "NB", do I have to reference it in my main.aspx? My sqlconnection string in the main.aspx is as follows

protected const string SQL_CONNECTION_ STRING =
"Server=localho st;" +
"DataBase=north wind;" +
"Integrated Security=SSPI"
---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/