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 3 1518
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
...
|
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.
...
|
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...
|
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...
|
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...
...
|
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...
|
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...
|
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...
|
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"...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
| |