connection problem

[dap]

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in
c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv
entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

[Ricky Chan]

may be incorrect SQL server name,
so you can not log in to it..
"dap" wrote:

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in
c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv
entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

[dap]

conMyData = new SqlConnection( "Server=localhost;
Database=Proton; trusted_connection=true;" )

is this correct? i used this code to connect.

-----Original Message-----
may be incorrect SQL server name,
so you can not log in to it..
"dap" wrote:

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

.

[AMALORPAVANATHAN YAGULASAMY(AMAL)]

Verify the connection string.

Regards,
Amal

"dap" wrote:

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in
c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv
entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

[William F. Robertson, Jr.]

You webserver is probably running under the aspnet user account. Have you
set up the aspnet user account to access your localhost SQL instance?

bill

"dap" <da****@yahoo.com> wrote in message
news:35****************************@phx.gbl...

conMyData = new SqlConnection( "Server=localhost;
Database=Proton; trusted_connection=true;" )

is this correct? i used this code to connect.

-----Original Message-----
may be incorrect SQL server name,
so you can not log in to it..
"dap" wrote:

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

.

[dap]

i don't i have set it. can u tell me how to set it?

-----Original Message-----
You webserver is probably running under the aspnet user account. Have youset up the aspnet user account to access your localhost SQL instance?
bill

"dap" <da****@yahoo.com> wrote in message
news:35****************************@phx.gbl...

conMyData = new SqlConnection( "Server=localhost;
Database=Proton; trusted_connection=true;" )

is this correct? i used this code to connect.

>-----Original Message-----
>may be incorrect SQL server name,
>so you can not log in to it..
>
>
>"dap" wrote:
>
>> can you tell me what is the problem with this error
>> statements??
>>
>> 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 27: cmdSelect.Parameters.Add( "@username",
>> strUsername )
>> Line 28: cmdSelect.Parameters.Add( "@password",
>> strPassword )
>> Line 29: conMyData.Open()
>> Line 30: cmdSelect.ExecuteNonQuery()
>> Line 31: intResult = cmdSelect.Parameters
>> ( "RETURN_VALUE" ).Value
>>
>>
>> Source File: c:\inetpub\wwwroot\proton-
>> commerce\login.aspx Line: 29
>>
>> Stack Trace:
>>
>>
>> [SqlException: SQL Server does not exist or access
>> denied.]
>> System.Data.SqlClient.ConnectionPool.GetConnection >> (Boolean& isInTransaction) +484
>>
>>

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo

>> nnection(SqlConnectionString options, Boolean&
>> isInTransaction) +372
>> System.Data.SqlClient.SqlConnection.Open() +384
>> ASP.Login_aspx.dbAuthenticate(String strUsername,
>> String strPassword) in c:\inetpub\wwwroot\proton-
>> commerce\login.aspx:29
>> ASP.Login_aspx.Button_Click(Object s, EventArgs e)

in

>> c:\inetpub\wwwroot\proton-commerce\login.aspx:10
>> System.Web.UI.WebControls.Button.OnClick

(EventArgs e)

>> +108
>>
>>

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv >> entHandler.RaisePostBackEvent(String eventArgument) +57 >> System.Web.UI.Page.RaisePostBackEvent
>> (IPostBackEventHandler sourceControl, String
>> eventArgument) +18
>> System.Web.UI.Page.RaisePostBackEvent
>> (NameValueCollection postData) +33
>> System.Web.UI.Page.ProcessRequestMain() +1292
>>
>>
>>
>>
>.
>

.

[Vaibhav]

Is the Sql Server running?

"dap" <da****@yahoo.com> wrote in message
news:20****************************@phx.gbl...

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in
c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv
entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

[William F. Robertson, Jr.]

There are several different ways to accomplish this. It also depends on
whether you have MSDE, or Sql 2000 installed on your machine.

For my setup. I would open Enterprise manager, select the database you want
access to. Right click the database and select new -> Database user.

Create a new user, using NT authentication, and map that account to you
machinename\aspnet.

Login = <machine name>\aspnet

You will have to set up permissions and stuff through there. You might look
for more information in the
microsoft.public.sqlserver.programming newsgroup.

Or check out Sql books on line.

bill

"dap" <da****@yahoo.com> wrote in message
news:35****************************@phx.gbl...

i don't i have set it. can u tell me how to set it?

-----Original Message-----
You webserver is probably running under the aspnet user

account. Have you

set up the aspnet user account to access your localhost

SQL instance?

bill

"dap" <da****@yahoo.com> wrote in message
news:35****************************@phx.gbl...

conMyData = new SqlConnection( "Server=localhost;
Database=Proton; trusted_connection=true;" )

is this correct? i used this code to connect.

>-----Original Message-----
>may be incorrect SQL server name,
>so you can not log in to it..
>
>
>"dap" wrote:
>
>> can you tell me what is the problem with this error
>> statements??
>>
>> 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 27: cmdSelect.Parameters.Add( "@username",
>> strUsername )
>> Line 28: cmdSelect.Parameters.Add( "@password",
>> strPassword )
>> Line 29: conMyData.Open()
>> Line 30: cmdSelect.ExecuteNonQuery()
>> Line 31: intResult = cmdSelect.Parameters
>> ( "RETURN_VALUE" ).Value
>>
>>
>> Source File: c:\inetpub\wwwroot\proton-
>> commerce\login.aspx Line: 29
>>
>> Stack Trace:
>>
>>
>> [SqlException: SQL Server does not exist or access
>> denied.]
>> System.Data.SqlClient.ConnectionPool.GetConnection >> (Boolean& isInTransaction) +484
>>
>>
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo >> nnection(SqlConnectionString options, Boolean&
>> isInTransaction) +372
>> System.Data.SqlClient.SqlConnection.Open() +384
>> ASP.Login_aspx.dbAuthenticate(String strUsername,
>> String strPassword) in c:\inetpub\wwwroot\proton-
>> commerce\login.aspx:29
>> ASP.Login_aspx.Button_Click(Object s, EventArgs e) in
>> c:\inetpub\wwwroot\proton-commerce\login.aspx:10
>> System.Web.UI.WebControls.Button.OnClick (EventArgs e)
>> +108
>>
>>
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv >> entHandler.RaisePostBackEvent(String eventArgument) +57 >> System.Web.UI.Page.RaisePostBackEvent
>> (IPostBackEventHandler sourceControl, String
>> eventArgument) +18
>> System.Web.UI.Page.RaisePostBackEvent
>> (NameValueCollection postData) +33
>> System.Web.UI.Page.ProcessRequestMain() +1292
>>
>>
>>
>>
>.
>

.

[dap]

ok. i have done it.
But i still have the same problem.
do i have to change in the UID and the PWD? or i can
still use the TRUSTED_CONNECTION?

-----Original Message-----
There are several different ways to accomplish this. It also depends onwhether you have MSDE, or Sql 2000 installed on your machine.
For my setup. I would open Enterprise manager, select the database you wantaccess to. Right click the database and select new -> Database user.
Create a new user, using NT authentication, and map that account to youmachinename\aspnet.

Login = <machine name>\aspnet

You will have to set up permissions and stuff through there. You might lookfor more information in the
microsoft.public.sqlserver.programming newsgroup.

Or check out Sql books on line.

bill

"dap" <da****@yahoo.com> wrote in message
news:35****************************@phx.gbl...

i don't i have set it. can u tell me how to set it?

>-----Original Message-----
>You webserver is probably running under the aspnet user

account. Have you

>set up the aspnet user account to access your

localhost

SQL instance?

>
>bill
>
>"dap" <da****@yahoo.com> wrote in message
>news:35****************************@phx.gbl...
>> conMyData = new SqlConnection( "Server=localhost;
>> Database=Proton; trusted_connection=true;" )
>>
>> is this correct? i used this code to connect.
>>
>> >-----Original Message-----
>> >may be incorrect SQL server name,
>> >so you can not log in to it..
>> >
>> >
>> >"dap" wrote:
>> >
>> >> can you tell me what is the problem with this

error >> >> statements??
>> >>
>> >> 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 27: cmdSelect.Parameters.Add( "@username",
>> >> strUsername )
>> >> Line 28: cmdSelect.Parameters.Add( "@password",
>> >> strPassword )
>> >> Line 29: conMyData.Open()
>> >> Line 30: cmdSelect.ExecuteNonQuery()
>> >> Line 31: intResult = cmdSelect.Parameters
>> >> ( "RETURN_VALUE" ).Value
>> >>
>> >>
>> >> Source File: c:\inetpub\wwwroot\proton-
>> >> commerce\login.aspx Line: 29
>> >>
>> >> Stack Trace:
>> >>
>> >>
>> >> [SqlException: SQL Server does not exist or access >> >> denied.]
>> >>

System.Data.SqlClient.ConnectionPool.GetConnection

>> >> (Boolean& isInTransaction) +484
>> >>
>> >>
>>

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo

>> >> nnection(SqlConnectionString options, Boolean&
>> >> isInTransaction) +372
>> >> System.Data.SqlClient.SqlConnection.Open() +384 >> >> ASP.Login_aspx.dbAuthenticate(String strUsername, >> >> String strPassword) in c:\inetpub\wwwroot\proton-
>> >> commerce\login.aspx:29
>> >> ASP.Login_aspx.Button_Click(Object s, EventArgs e)

>> in
>> >> c:\inetpub\wwwroot\proton-commerce\login.aspx:10
>> >> System.Web.UI.WebControls.Button.OnClick

(EventArgs

>> e)
>> >> +108
>> >>
>> >>
>>

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv >> >> entHandler.RaisePostBackEvent(String

eventArgument) +57

>> >> System.Web.UI.Page.RaisePostBackEvent
>> >> (IPostBackEventHandler sourceControl, String
>> >> eventArgument) +18
>> >> System.Web.UI.Page.RaisePostBackEvent
>> >> (NameValueCollection postData) +33
>> >> System.Web.UI.Page.ProcessRequestMain() +1292
>> >>
>> >>
>> >>
>> >>
>> >.
>> >
>
>
>.
>

.

[dap]

yes it is running.

-----Original Message-----
Is the Sql Server running?

"dap" <da****@yahoo.com> wrote in message
news:20****************************@phx.gbl...

can you tell me what is the problem with this error
statements??

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 27: cmdSelect.Parameters.Add( "@username",
strUsername )
Line 28: cmdSelect.Parameters.Add( "@password",
strPassword )
Line 29: conMyData.Open()
Line 30: cmdSelect.ExecuteNonQuery()
Line 31: intResult = cmdSelect.Parameters
( "RETURN_VALUE" ).Value
Source File: c:\inetpub\wwwroot\proton-
commerce\login.aspx Line: 29

Stack Trace:
[SqlException: SQL Server does not exist or access
denied.]
System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo nnection(SqlConnectionString options, Boolean&
isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.Login_aspx.dbAuthenticate(String strUsername,
String strPassword) in c:\inetpub\wwwroot\proton-
commerce\login.aspx:29
ASP.Login_aspx.Button_Click(Object s, EventArgs e) in
c:\inetpub\wwwroot\proton-commerce\login.aspx:10
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
+108

System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv entHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

.

[William F. Robertson, Jr.]

What is the instance name of your server? You might not be able to use
"localhost".

You haven't changed any of your machine.config processModel section have
you?

bill

"dap" <da****@yahoo.com> wrote in message
news:37****************************@phx.gbl...

ok. i have done it.
But i still have the same problem.
do i have to change in the UID and the PWD? or i can
still use the TRUSTED_CONNECTION?

-----Original Message-----
There are several different ways to accomplish this. It

also depends on

whether you have MSDE, or Sql 2000 installed on your

machine.

For my setup. I would open Enterprise manager, select

the database you want

access to. Right click the database and select new ->

Database user.

Create a new user, using NT authentication, and map that

account to you

machinename\aspnet.

Login = <machine name>\aspnet

You will have to set up permissions and stuff through

there. You might look

for more information in the
microsoft.public.sqlserver.programming newsgroup.

Or check out Sql books on line.

bill

"dap" <da****@yahoo.com> wrote in message
news:35****************************@phx.gbl...

i don't i have set it. can u tell me how to set it?

>-----Original Message-----
>You webserver is probably running under the aspnet user account. Have you
>set up the aspnet user account to access your localhost SQL instance?
>
>bill
>
>"dap" <da****@yahoo.com> wrote in message
>news:35****************************@phx.gbl...
>> conMyData = new SqlConnection( "Server=localhost;
>> Database=Proton; trusted_connection=true;" )
>>
>> is this correct? i used this code to connect.
>>
>> >-----Original Message-----
>> >may be incorrect SQL server name,
>> >so you can not log in to it..
>> >
>> >
>> >"dap" wrote:
>> >
>> >> can you tell me what is the problem with this error >> >> statements??
>> >>
>> >> 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 27: cmdSelect.Parameters.Add( "@username",
>> >> strUsername )
>> >> Line 28: cmdSelect.Parameters.Add( "@password",
>> >> strPassword )
>> >> Line 29: conMyData.Open()
>> >> Line 30: cmdSelect.ExecuteNonQuery()
>> >> Line 31: intResult = cmdSelect.Parameters
>> >> ( "RETURN_VALUE" ).Value
>> >>
>> >>
>> >> Source File: c:\inetpub\wwwroot\proton-
>> >> commerce\login.aspx Line: 29
>> >>
>> >> Stack Trace:
>> >>
>> >>
>> >> [SqlException: SQL Server does not exist or access >> >> denied.]
>> >>
System.Data.SqlClient.ConnectionPool.GetConnection
>> >> (Boolean& isInTransaction) +484
>> >>
>> >>
>>
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCo >> >> nnection(SqlConnectionString options, Boolean&
>> >> isInTransaction) +372
>> >> System.Data.SqlClient.SqlConnection.Open() +384 >> >> ASP.Login_aspx.dbAuthenticate(String strUsername, >> >> String strPassword) in c:\inetpub\wwwroot\proton-
>> >> commerce\login.aspx:29
>> >> ASP.Login_aspx.Button_Click(Object s, EventArgs e)
>> in
>> >> c:\inetpub\wwwroot\proton-commerce\login.aspx:10
>> >> System.Web.UI.WebControls.Button.OnClick
(EventArgs
>> e)
>> >> +108
>> >>
>> >>
>>
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEv >> >> entHandler.RaisePostBackEvent(String eventArgument) +57
>> >> System.Web.UI.Page.RaisePostBackEvent
>> >> (IPostBackEventHandler sourceControl, String
>> >> eventArgument) +18
>> >> System.Web.UI.Page.RaisePostBackEvent
>> >> (NameValueCollection postData) +33
>> >> System.Web.UI.Page.ProcessRequestMain() +1292
>> >>
>> >>
>> >>
>> >>
>> >.
>> >
>
>
>.
>

.