Connecting to SQL Server on WIN2003 Box

[Mike Collins]

I am trying to connect to a 2003 Server from an ASP.Net page and am getting
the following error message. Can someone please help get me started on how to
track and fix this error? The code I am using is below the error I am
getting.

Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
access denied. at System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) at
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction ) at
System.Data.Sql Client.SqlConne ction.Open() at
testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in c:\documents and
settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
31

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
SqlDataReader dataReader = null;

try
{
SqlConnection connection = new
SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
password=myPass word");
SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
command.Command Type = CommandType.Sto redProcedure;
connection.Open ();
dataReader = command.Execute Reader();

while (dataReader.Rea d())
{
string headerMenu = (string)dataRea der["HeaderMenu "];
string sectionID = (string)dataRea der["SectionID"];
string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
string menuName = (string)dataRea der["MenuName"];
string pageUrl = (string)dataRea der["PageUrl"];
string ImageUrl = (string)dataRea der["ImageUrl"];
}

dataReader.Clos e();
connection.Clos e();
}

catch (System.Excepti on exception)
{
Response.Write( "Error: " + exception.ToStr ing());
return;
}

finally
{
if (dataReader != null)
{
dataReader.Clos e();
}
}
}

[Arild Bakken]

Verify that you can connect using the specified username and password in SQL
Query Analyzer.

I assume the server is setup with both SQL and Integrated login enabled and
that you have created the specified login in the SQL server and granted the
login access to the given database?

Also, to make sure you can connect, try from a command prompt on the
webserver to telnet to port 1433 (if TCP/IP is the transport you're using).
Regards,

Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

I am trying to connect to a 2003 Server from an ASP.Net page and am getting
the following error message. Can someone please help get me started on how
to
track and fix this error? The code I am using is below the error I am
getting.

Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
access denied. at
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) at
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction ) at
System.Data.Sql Client.SqlConne ction.Open() at
testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in c:\documents
and
settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
31

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
SqlDataReader dataReader = null;

try
{
SqlConnection connection = new
SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
password=myPass word");
SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
command.Command Type = CommandType.Sto redProcedure;
connection.Open ();
dataReader = command.Execute Reader();

while (dataReader.Rea d())
{
string headerMenu = (string)dataRea der["HeaderMenu "];
string sectionID = (string)dataRea der["SectionID"];
string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
string menuName = (string)dataRea der["MenuName"];
string pageUrl = (string)dataRea der["PageUrl"];
string ImageUrl = (string)dataRea der["ImageUrl"];
}

dataReader.Clos e();
connection.Clos e();
}

catch (System.Excepti on exception)
{
Response.Write( "Error: " + exception.ToStr ing());
return;
}

finally
{
if (dataReader != null)
{
dataReader.Clos e();
}
}
}

[Mike Collins]

The server is set for both SQL and integrated login. I'm not sure how to use
a command prompt to telnet to port 1433. If you can help with that, I'll give
it a try.

Here is other information that I forgot earlier.
1. I am trying to connect from a Windows XP Professional computer.
2. Currently the server is both a web and database server using Win 2003.
3. We are trying to develop on our XP boxes and test items before moving the
pages over to the test server.

Thanks

"Arild Bakken" wrote:

Verify that you can connect using the specified username and password in SQL
Query Analyzer.

I assume the server is setup with both SQL and Integrated login enabled and
that you have created the specified login in the SQL server and granted the
login access to the given database?

Also, to make sure you can connect, try from a command prompt on the
webserver to telnet to port 1433 (if TCP/IP is the transport you're using).
Regards,

Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

I am trying to connect to a 2003 Server from an ASP.Net page and am getting
the following error message. Can someone please help get me started on how
to
track and fix this error? The code I am using is below the error I am
getting.

Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
access denied. at
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) at
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction ) at
System.Data.Sql Client.SqlConne ction.Open() at
testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in c:\documents
and
settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
31

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
SqlDataReader dataReader = null;

try
{
SqlConnection connection = new
SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
password=myPass word");
SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
command.Command Type = CommandType.Sto redProcedure;
connection.Open ();
dataReader = command.Execute Reader();

while (dataReader.Rea d())
{
string headerMenu = (string)dataRea der["HeaderMenu "];
string sectionID = (string)dataRea der["SectionID"];
string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
string menuName = (string)dataRea der["MenuName"];
string pageUrl = (string)dataRea der["PageUrl"];
string ImageUrl = (string)dataRea der["ImageUrl"];
}

dataReader.Clos e();
connection.Clos e();
}

catch (System.Excepti on exception)
{
Response.Write( "Error: " + exception.ToStr ing());
return;
}

finally
{
if (dataReader != null)
{
dataReader.Clos e();
}
}
}

[Nicholas Paldino [.NET/C# MVP]]

Mike,

The issue arises from the fact that you are running with default
credentials in ASP.NET. By default, all code that runs in ASP.NET runs
under the ASPNET local user. This doesn't have access to network resources.

In order to get around this, you have to impersonate a user (through
code, or through a declaration in web.config) which has rights to the
network, and to SQL Server.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

The server is set for both SQL and integrated login. I'm not sure how to
use
a command prompt to telnet to port 1433. If you can help with that, I'll
give
it a try.

Here is other information that I forgot earlier.
1. I am trying to connect from a Windows XP Professional computer.
2. Currently the server is both a web and database server using Win 2003.
3. We are trying to develop on our XP boxes and test items before moving
the
pages over to the test server.

Thanks

"Arild Bakken" wrote:

Verify that you can connect using the specified username and password in
SQL
Query Analyzer.

I assume the server is setup with both SQL and Integrated login enabled
and
that you have created the specified login in the SQL server and granted
the
login access to the given database?

Also, to make sure you can connect, try from a command prompt on the
webserver to telnet to port 1433 (if TCP/IP is the transport you're
using).
Regards,

Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

>I am trying to connect to a 2003 Server from an ASP.Net page and am
>getting
> the following error message. Can someone please help get me started on
> how
> to
> track and fix this error? The code I am using is below the error I am
> getting.
>
> Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
> access denied. at
> System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction ) at
> System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
> options, Boolean& isInTransaction ) at
> System.Data.Sql Client.SqlConne ction.Open() at
> testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in
> c:\documents
> and
> settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
> 31
>
> private void Page_Load(objec t sender, System.EventArg s e)
> {
> // Put user code to initialize the page here
> SqlDataReader dataReader = null;
>
> try
> {
> SqlConnection connection = new
> SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
> password=myPass word");
> SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
> command.Command Type = CommandType.Sto redProcedure;
> connection.Open ();
> dataReader = command.Execute Reader();
>
> while (dataReader.Rea d())
> {
> string headerMenu = (string)dataRea der["HeaderMenu "];
> string sectionID = (string)dataRea der["SectionID"];
> string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
> string menuName = (string)dataRea der["MenuName"];
> string pageUrl = (string)dataRea der["PageUrl"];
> string ImageUrl = (string)dataRea der["ImageUrl"];
> }
>
> dataReader.Clos e();
> connection.Clos e();
> }
>
> catch (System.Excepti on exception)
> {
> Response.Write( "Error: " + exception.ToStr ing());
> return;
> }
>
> finally
> {
> if (dataReader != null)
> {
> dataReader.Clos e();
> }
> }
> }

[Arild Bakken]

To try connecting to the server using telnet:

1. Start a command prompt (Start / Run / type "cmd" and press enter).
2. Type: telnet TestWebServer 1433

This only works if the server is configured to use TCP/IP and only if the
SQL server instance is using port 1433 - you can check that on the server
using the SQL server configuration tool.

Another thing, is the SQL instance the default instance or is it a named
instance? If it is a named instance you need to include the instance name in
the server name, like servername\inst ancename.
Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

The server is set for both SQL and integrated login. I'm not sure how to
use
a command prompt to telnet to port 1433. If you can help with that, I'll
give
it a try.

Here is other information that I forgot earlier.
1. I am trying to connect from a Windows XP Professional computer.
2. Currently the server is both a web and database server using Win 2003.
3. We are trying to develop on our XP boxes and test items before moving
the
pages over to the test server.

Thanks

"Arild Bakken" wrote:

Verify that you can connect using the specified username and password in
SQL
Query Analyzer.

I assume the server is setup with both SQL and Integrated login enabled
and
that you have created the specified login in the SQL server and granted
the
login access to the given database?

Also, to make sure you can connect, try from a command prompt on the
webserver to telnet to port 1433 (if TCP/IP is the transport you're
using).
Regards,

Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

>I am trying to connect to a 2003 Server from an ASP.Net page and am
>getting
> the following error message. Can someone please help get me started on
> how
> to
> track and fix this error? The code I am using is below the error I am
> getting.
>
> Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
> access denied. at
> System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction ) at
> System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
> options, Boolean& isInTransaction ) at
> System.Data.Sql Client.SqlConne ction.Open() at
> testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in
> c:\documents
> and
> settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
> 31
>
> private void Page_Load(objec t sender, System.EventArg s e)
> {
> // Put user code to initialize the page here
> SqlDataReader dataReader = null;
>
> try
> {
> SqlConnection connection = new
> SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
> password=myPass word");
> SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
> command.Command Type = CommandType.Sto redProcedure;
> connection.Open ();
> dataReader = command.Execute Reader();
>
> while (dataReader.Rea d())
> {
> string headerMenu = (string)dataRea der["HeaderMenu "];
> string sectionID = (string)dataRea der["SectionID"];
> string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
> string menuName = (string)dataRea der["MenuName"];
> string pageUrl = (string)dataRea der["PageUrl"];
> string ImageUrl = (string)dataRea der["ImageUrl"];
> }
>
> dataReader.Clos e();
> connection.Clos e();
> }
>
> catch (System.Excepti on exception)
> {
> Response.Write( "Error: " + exception.ToStr ing());
> return;
> }
>
> finally
> {
> if (dataReader != null)
> {
> dataReader.Clos e();
> }
> }
> }

[Willy Denoyette [MVP]]

On W2K3 aspnet runs as NETWORK_SERVICE , not as aspnet.

Willy.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:uK******** ******@TK2MSFTN GP10.phx.gbl...

Mike,

The issue arises from the fact that you are running with default
credentials in ASP.NET. By default, all code that runs in ASP.NET runs
under the ASPNET local user. This doesn't have access to network
resources.

In order to get around this, you have to impersonate a user (through
code, or through a declaration in web.config) which has rights to the
network, and to SQL Server.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

The server is set for both SQL and integrated login. I'm not sure how to
use
a command prompt to telnet to port 1433. If you can help with that, I'll
give
it a try.

Here is other information that I forgot earlier.
1. I am trying to connect from a Windows XP Professional computer.
2. Currently the server is both a web and database server using Win 2003.
3. We are trying to develop on our XP boxes and test items before moving
the
pages over to the test server.

Thanks

"Arild Bakken" wrote:

Verify that you can connect using the specified username and password in
SQL
Query Analyzer.

I assume the server is setup with both SQL and Integrated login enabled
and
that you have created the specified login in the SQL server and granted
the
login access to the given database?

Also, to make sure you can connect, try from a command prompt on the
webserver to telnet to port 1433 (if TCP/IP is the transport you're
using).
Regards,

Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
>I am trying to connect to a 2003 Server from an ASP.Net page and am
>getting
> the following error message. Can someone please help get me started on
> how
> to
> track and fix this error? The code I am using is below the error I am
> getting.
>
> Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist
> or
> access denied. at
> System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction ) at
> System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
> options, Boolean& isInTransaction ) at
> System.Data.Sql Client.SqlConne ction.Open() at
> testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in
> c:\documents
> and
> settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
> 31
>
> private void Page_Load(objec t sender, System.EventArg s e)
> {
> // Put user code to initialize the page here
> SqlDataReader dataReader = null;
>
> try
> {
> SqlConnection connection = new
> SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
> password=myPass word");
> SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
> command.Command Type = CommandType.Sto redProcedure;
> connection.Open ();
> dataReader = command.Execute Reader();
>
> while (dataReader.Rea d())
> {
> string headerMenu = (string)dataRea der["HeaderMenu "];
> string sectionID = (string)dataRea der["SectionID"];
> string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
> string menuName = (string)dataRea der["MenuName"];
> string pageUrl = (string)dataRea der["PageUrl"];
> string ImageUrl = (string)dataRea der["ImageUrl"];
> }
>
> dataReader.Clos e();
> connection.Clos e();
> }
>
> catch (System.Excepti on exception)
> {
> Response.Write( "Error: " + exception.ToStr ing());
> return;
> }
>
> finally
> {
> if (dataReader != null)
> {
> dataReader.Clos e();
> }
> }
> }

[Willy Denoyette [MVP]]

Set your connection string to use integrated security, and add NETWORK
SERVICE as a user and grant appropriate rights.
NT AUTHORITY\NETWO RK USER is the the default user running aspnet.
Note that I noticed that you are running IIS and SQL on the same box (W2K3),
above is only applicable in such configuration.

Willy.

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

I am trying to connect to a 2003 Server from an ASP.Net page and am getting
the following error message. Can someone please help get me started on how
to
track and fix this error? The code I am using is below the error I am
getting.

Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
access denied. at
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) at
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction ) at
System.Data.Sql Client.SqlConne ction.Open() at
testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in c:\documents
and
settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
31

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
SqlDataReader dataReader = null;

try
{
SqlConnection connection = new
SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
password=myPass word");
SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
command.Command Type = CommandType.Sto redProcedure;
connection.Open ();
dataReader = command.Execute Reader();

while (dataReader.Rea d())
{
string headerMenu = (string)dataRea der["HeaderMenu "];
string sectionID = (string)dataRea der["SectionID"];
string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
string menuName = (string)dataRea der["MenuName"];
string pageUrl = (string)dataRea der["PageUrl"];
string ImageUrl = (string)dataRea der["ImageUrl"];
}

dataReader.Clos e();
connection.Clos e();
}

catch (System.Excepti on exception)
{
Response.Write( "Error: " + exception.ToStr ing());
return;
}

finally
{
if (dataReader != null)
{
dataReader.Clos e();
}
}
}

[Mike Collins]

Thanks to all of you for your input. I'm going to look into adding rights in
webconfig. I'll make another post, in a couple of days, if I need further
assistance. Thanks again.

"Arild Bakken" wrote:

To try connecting to the server using telnet:

1. Start a command prompt (Start / Run / type "cmd" and press enter).
2. Type: telnet TestWebServer 1433

This only works if the server is configured to use TCP/IP and only if the
SQL server instance is using port 1433 - you can check that on the server
using the SQL server configuration tool.

Another thing, is the SQL instance the default instance or is it a named
instance? If it is a named instance you need to include the instance name in
the server name, like servername\inst ancename.
Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:D0******** *************** ***********@mic rosoft.com...

The server is set for both SQL and integrated login. I'm not sure how to
use
a command prompt to telnet to port 1433. If you can help with that, I'll
give
it a try.

Here is other information that I forgot earlier.
1. I am trying to connect from a Windows XP Professional computer.
2. Currently the server is both a web and database server using Win 2003.
3. We are trying to develop on our XP boxes and test items before moving
the
pages over to the test server.

Thanks

"Arild Bakken" wrote:

Verify that you can connect using the specified username and password in
SQL
Query Analyzer.

I assume the server is setup with both SQL and Integrated login enabled
and
that you have created the specified login in the SQL server and granted
the
login access to the given database?

Also, to make sure you can connect, try from a command prompt on the
webserver to telnet to port 1433 (if TCP/IP is the transport you're
using).
Regards,

Arild

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...
>I am trying to connect to a 2003 Server from an ASP.Net page and am
>getting
> the following error message. Can someone please help get me started on
> how
> to
> track and fix this error? The code I am using is below the error I am
> getting.
>
> Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
> access denied. at
> System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction ) at
> System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
> options, Boolean& isInTransaction ) at
> System.Data.Sql Client.SqlConne ction.Open() at
> testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in
> c:\documents
> and
> settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
> 31
>
> private void Page_Load(objec t sender, System.EventArg s e)
> {
> // Put user code to initialize the page here
> SqlDataReader dataReader = null;
>
> try
> {
> SqlConnection connection = new
> SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
> password=myPass word");
> SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
> command.Command Type = CommandType.Sto redProcedure;
> connection.Open ();
> dataReader = command.Execute Reader();
>
> while (dataReader.Rea d())
> {
> string headerMenu = (string)dataRea der["HeaderMenu "];
> string sectionID = (string)dataRea der["SectionID"];
> string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
> string menuName = (string)dataRea der["MenuName"];
> string pageUrl = (string)dataRea der["PageUrl"];
> string ImageUrl = (string)dataRea der["ImageUrl"];
> }
>
> dataReader.Clos e();
> connection.Clos e();
> }
>
> catch (System.Excepti on exception)
> {
> Response.Write( "Error: " + exception.ToStr ing());
> return;
> }
>
> finally
> {
> if (dataReader != null)
> {
> dataReader.Clos e();
> }
> }
> }

[Nate]

I'm confused. If the connection string is specifying "User
Id=sa;Password= sa_password", then why in all of creation is ASP.NET sending
credentials as ASPNET and not "sa"? What's the point in having SQL
credentials if you can't use them?

"Willy Denoyette [MVP]" wrote:

Set your connection string to use integrated security, and add NETWORK
SERVICE as a user and grant appropriate rights.
NT AUTHORITY\NETWO RK USER is the the default user running aspnet.
Note that I noticed that you are running IIS and SQL on the same box (W2K3),
above is only applicable in such configuration.

Willy.

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

I am trying to connect to a 2003 Server from an ASP.Net page and am getting
the following error message. Can someone please help get me started on how
to
track and fix this error? The code I am using is below the error I am
getting.

Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
access denied. at
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) at
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction ) at
System.Data.Sql Client.SqlConne ction.Open() at
testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in c:\documents
and
settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
31

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
SqlDataReader dataReader = null;

try
{
SqlConnection connection = new
SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
password=myPass word");
SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
command.Command Type = CommandType.Sto redProcedure;
connection.Open ();
dataReader = command.Execute Reader();

while (dataReader.Rea d())
{
string headerMenu = (string)dataRea der["HeaderMenu "];
string sectionID = (string)dataRea der["SectionID"];
string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
string menuName = (string)dataRea der["MenuName"];
string pageUrl = (string)dataRea der["PageUrl"];
string ImageUrl = (string)dataRea der["ImageUrl"];
}

dataReader.Clos e();
connection.Clos e();
}

catch (System.Excepti on exception)
{
Response.Write( "Error: " + exception.ToStr ing());
return;
}

finally
{
if (dataReader != null)
{
dataReader.Clos e();
}
}
}

[Willy Denoyette [MVP]]

Did I say that you can't use them?
I only said that in a configuration that runs SQL and IIS (aspnet) on the
same box, you better use integrated security.
Note that from this code

SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;

> password=myPass word");

it's impossible for us to tell whether the specified credentials are correct
or that the Servername is correct, so to eliminate the credentials as a
possible cause, specify integrated security.
Note that, whatever the configuration is, you should always prefer
integrated security over explicit hard coded user credentials, especially
sa credentials.

Willy.
"Nate" <Na**@discussio ns.microsoft.co m> wrote in message
news:54******** *************** ***********@mic rosoft.com... I'm confused. If the connection string is specifying "User
Id=sa;Password= sa_password", then why in all of creation is ASP.NET
sending
credentials as ASPNET and not "sa"? What's the point in having SQL
credentials if you can't use them?

"Willy Denoyette [MVP]" wrote:

Set your connection string to use integrated security, and add NETWORK
SERVICE as a user and grant appropriate rights.
NT AUTHORITY\NETWO RK USER is the the default user running aspnet.
Note that I noticed that you are running IIS and SQL on the same box
(W2K3),
above is only applicable in such configuration.

Willy.

"Mike Collins" <Mi*********@di scussions.micro soft.com> wrote in message
news:9C******** *************** ***********@mic rosoft.com...

>I am trying to connect to a 2003 Server from an ASP.Net page and am
>getting
> the following error message. Can someone please help get me started on
> how
> to
> track and fix this error? The code I am using is below the error I am
> getting.
>
> Error: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or
> access denied. at
> System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
> isInTransaction ) at
> System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
> options, Boolean& isInTransaction ) at
> System.Data.Sql Client.SqlConne ction.Open() at
> testbed.Navigat ion.Page_Load(O bject sender, EventArgs e) in
> c:\documents
> and
> settings\collin ss\vswebcache\6 05webdev-2_443\testbed\n avigation.aspx. cs:line
> 31
>
> private void Page_Load(objec t sender, System.EventArg s e)
> {
> // Put user code to initialize the page here
> SqlDataReader dataReader = null;
>
> try
> {
> SqlConnection connection = new
> SqlConnection(" Server=TestWebS erver;Database= Common;user id=myUserID;
> password=myPass word");
> SqlCommand command = new SqlCommand("Get NavigationMenu" , connection);
> command.Command Type = CommandType.Sto redProcedure;
> connection.Open ();
> dataReader = command.Execute Reader();
>
> while (dataReader.Rea d())
> {
> string headerMenu = (string)dataRea der["HeaderMenu "];
> string sectionID = (string)dataRea der["SectionID"];
> string navigationMenuI D = (string)dataRea der["NavigationMenu ID"];
> string menuName = (string)dataRea der["MenuName"];
> string pageUrl = (string)dataRea der["PageUrl"];
> string ImageUrl = (string)dataRea der["ImageUrl"];
> }
>
> dataReader.Clos e();
> connection.Clos e();
> }
>
> catch (System.Excepti on exception)
> {
> Response.Write( "Error: " + exception.ToStr ing());
> return;
> }
>
> finally
> {
> if (dataReader != null)
> {
> dataReader.Clos e();
> }
> }
> }