473,323 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Connectionstring User and Password Not Being Used

DJ
Hi,

Got a real problem here and I can't figure it out. I set up the connection
string to my database in my web config file, do it right by the book, and
retreive it using the
ConfigurationManager.ConnectionStrings("string").C onnectionString property. I
assign the string to the sqlConnection.ConnectionString, I even print it back
to make sure this is the one its using.

But then when I try to open the connection, I get a SqlClient error "Login
Failed for user Machine\ASPNET."

I'm at my wit's end, what is it I am not doing that will get ASPNET out of
my connection and make the SqlClient start using the Uid and Pwd (even tried
User ID and Password) instead?

HELLPPPP!!!!

Jim
Jun 21 '06 #1
3 1518
DJ
BTW, setting up the ASPNET account in the database is not an option. On my
development machines it works fine because after the ASPNET is rejected it
rolls over to user my own Windows log on. Unfortunately, I am posting a web
application to a service provider, and they won't put the ASPNET account into
the database users for me.

Jim

"DJ" wrote:
Hi,

Got a real problem here and I can't figure it out. I set up the connection
string to my database in my web config file, do it right by the book, and
retreive it using the
ConfigurationManager.ConnectionStrings("string").C onnectionString property. I
assign the string to the sqlConnection.ConnectionString, I even print it back
to make sure this is the one its using.

But then when I try to open the connection, I get a SqlClient error "Login
Failed for user Machine\ASPNET."

I'm at my wit's end, what is it I am not doing that will get ASPNET out of
my connection and make the SqlClient start using the Uid and Pwd (even tried
User ID and Password) instead?

HELLPPPP!!!!

Jim

Jun 21 '06 #2
the userid and pawwrod is only used with sqlserver standard security. to
use, enable standard security on sqlsever, add a user and password. give
them rithgts. then in the connect string do not specify trusted or
intergrated security.
"DJ" <DJ@discussions.microsoft.com> wrote in message
news:47**********************************@microsof t.com...
BTW, setting up the ASPNET account in the database is not an option. On my
development machines it works fine because after the ASPNET is rejected it
rolls over to user my own Windows log on. Unfortunately, I am posting a
web
application to a service provider, and they won't put the ASPNET account
into
the database users for me.

Jim

"DJ" wrote:
Hi,

Got a real problem here and I can't figure it out. I set up the
connection
string to my database in my web config file, do it right by the book, and
retreive it using the
ConfigurationManager.ConnectionStrings("string").C onnectionString
property. I
assign the string to the sqlConnection.ConnectionString, I even print it
back
to make sure this is the one its using.

But then when I try to open the connection, I get a SqlClient error
"Login
Failed for user Machine\ASPNET."

I'm at my wit's end, what is it I am not doing that will get ASPNET out
of
my connection and make the SqlClient start using the Uid and Pwd (even
tried
User ID and Password) instead?

HELLPPPP!!!!

Jim

Jun 21 '06 #3
DJ
You are the man! To think one little phrase created all those problems.
Appreciate the help!

Jim

"bruce barker (sqlwork.com)" wrote:
the userid and pawwrod is only used with sqlserver standard security. to
use, enable standard security on sqlsever, add a user and password. give
them rithgts. then in the connect string do not specify trusted or
intergrated security.
"DJ" <DJ@discussions.microsoft.com> wrote in message
news:47**********************************@microsof t.com...
BTW, setting up the ASPNET account in the database is not an option. On my
development machines it works fine because after the ASPNET is rejected it
rolls over to user my own Windows log on. Unfortunately, I am posting a
web
application to a service provider, and they won't put the ASPNET account
into
the database users for me.

Jim

"DJ" wrote:
Hi,

Got a real problem here and I can't figure it out. I set up the
connection
string to my database in my web config file, do it right by the book, and
retreive it using the
ConfigurationManager.ConnectionStrings("string").C onnectionString
property. I
assign the string to the sqlConnection.ConnectionString, I even print it
back
to make sure this is the one its using.

But then when I try to open the connection, I get a SqlClient error
"Login
Failed for user Machine\ASPNET."

I'm at my wit's end, what is it I am not doing that will get ASPNET out
of
my connection and make the SqlClient start using the Uid and Pwd (even
tried
User ID and Password) instead?

HELLPPPP!!!!

Jim


Jun 22 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Tony | last post by:
Dear All, When I run an example program on the http://www.dotnetjunkies.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/data/datagrid1.src&file=VB\datagrid1.aspx&font=3 ...
10
by: Laura K | last post by:
Tried all kinds of things. I get the error. The ConnectionString property has not been initialized. Any help appreciated. ...
17
by: Adam | last post by:
I have a small application that uses oledb to connect to a database, set up through the GUI wizards in vis studio. I am wanting to have the database location kept in an .ini file along with the...
4
by: Didymus | last post by:
Hi everyone, How would I adjust the following ConnectionString to point to the applications installed path? === Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=SOME...
1
by: Job Lot | last post by:
Creating a new typed dataset using the Data Source Configuration Wizard (and opting NOT to save the password with user settings) generates a ConnectionString setting like... ...
1
by: TeeCo | last post by:
Hi folks. I'm trying to change the location of the Access mdb file I connect to using OleDb and am having trouble. I'm using Visual C# 2005 and the default values I use for the ConnectionString...
1
by: Brian Henry | last post by:
I keep gettings this error message in my application event log Exception information: Exception type: InvalidOperationException Exception message: Not allowed to change the...
3
by: Andre Rode | last post by:
Hi, a question I use a mdb database for my application. The application should be able to handle more than one mdb, so I think I have to change my.settings.ConString (this is my...
5
by: Radu | last post by:
Hi. In a repeater I have as ItemTemplate the following, among others, and everything works great: <asp:SqlDataSource ID="LocationSqlDataSource" SelectCommand="SELECT blah-blah-blah"...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.