Hello,
I have read a bunch of topics on this issue but none seems to have
resolved my problem. I have set up a user account in my SQL server
database. e.g. User: TheUser Password: Password and assigned it as a
datareader with the ability to issue SELECT statements on one table.
On a separate IIS server I am running a page that makes a connection to
this database. I have tried a bunch of connection strings and though I
can connect using the SQLDataConnection wizard in .net 2003 Interdev,
Windows ODBC, etc. When I actually browse to test the page using the
same connection string I get the message that:
SQL Server does not exist or access denied.
I do not want to Impersonate and existing account. I have enabled
Anonymous access in IIS. I do not want Windows Integrated Security.
An example of a connection string I that works within .net studio
(development) but now actuall when the ASP page is accessed via
localhost is:
"workstation id=myworkstation;packet size=4096;user id=TheUser;data
source=myserver;persist security info=True;initial
catalog=MyDB;password=password"
What am I doing wrong?
Thanks,
Ryan 13 1124
<ry************@kp.org> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com... (development) but now actuall when the ASP page is accessed via
What am I doing wrong?
For a start, you're posting in the wrong newsgroup...
For ASP issues specifically related to database connectivity, you need:
microsoft.public.inetserver.asp.db
you need to turn on mixed security on the sqlserver box, you you can
actually use a standard login.
-- bruce (sqlwork.com)
<ry************@kp.org> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com... Hello,
I have read a bunch of topics on this issue but none seems to have resolved my problem. I have set up a user account in my SQL server database. e.g. User: TheUser Password: Password and assigned it as a datareader with the ability to issue SELECT statements on one table.
On a separate IIS server I am running a page that makes a connection to this database. I have tried a bunch of connection strings and though I can connect using the SQLDataConnection wizard in .net 2003 Interdev, Windows ODBC, etc. When I actually browse to test the page using the same connection string I get the message that:
SQL Server does not exist or access denied.
I do not want to Impersonate and existing account. I have enabled Anonymous access in IIS. I do not want Windows Integrated Security. An example of a connection string I that works within .net studio (development) but now actuall when the ASP page is accessed via localhost is:
"workstation id=myworkstation;packet size=4096;user id=TheUser;data source=myserver;persist security info=True;initial catalog=MyDB;password=password"
What am I doing wrong?
Thanks, Ryan
Mixed security is turned on. I am going to repost this in the news
group Mark suggested. If you can think of some other causes for this
can you please respond to me there! Thanks Bruce!
OK, just got notified by a Microsoft MVP that this is indeed the
correct newgroup to be posting to since this is an ASP .NET issue.
Please, I don't really care too much where people post a response, if
you know the answer this problem has been driving me crazy for days! :)
OK, just got notified by a Microsoft MVP that this is indeed the
correct newgroup to be posting to since this is an ASP .NET issue.
Please, I don't really care too much where people post a response, if
you know the answer this problem has been driving me crazy for days! :)
If you have setup a specific user in the SQL Server DB, and you have
setup SQL Server to use "mixed authentication", i.e., both Windows and
SQL Server authentication, use this for your connection string :
"SERVER=yourSqlServer;UID=TheUser;DataBase=YourDB; PWD=Password"
Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
<ry************@kp.org> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com... Hello,
I have read a bunch of topics on this issue but none seems to have resolved my problem. I have set up a user account in my SQL server database. e.g. User: TheUser Password: Password and assigned it as a datareader with the ability to issue SELECT statements on one table.
On a separate IIS server I am running a page that makes a connection to this database. I have tried a bunch of connection strings and though I can connect using the SQLDataConnection wizard in .net 2003 Interdev, Windows ODBC, etc. When I actually browse to test the page using the same connection string I get the message that:
SQL Server does not exist or access denied.
I do not want to Impersonate and existing account. I have enabled Anonymous access in IIS. I do not want Windows Integrated Security. An example of a connection string I that works within .net studio (development) but now actuall when the ASP page is accessed via localhost is:
"workstation id=myworkstation;packet size=4096;user id=TheUser;data source=myserver;persist security info=True;initial catalog=MyDB;password=password"
What am I doing wrong?
Thanks, Ryan
PS. This is my fault, I mistakenly wrote ASP page above...should have
read aspX page ;)
Still did not work:
Source File: C:\Inetpub\wwwroot\MFAP\login.aspx.vb Line: 80
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
MFAP.login.DBAuthenticate(String strUID, String strpswd) in
C:\Inetpub\wwwroot\MFAP\login.aspx.vb:80
MFAP.login.BtnLogin_Click(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\MFAP\login.aspx.vb:63
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1277
Let me ask this, does Windows still try to authenticate under the
service account to the SQL Server box even if you are trying to use SQL
Authentication to make the connection. In other words, if were to
impersonate say, myself, with administrative rights (which I don't want
to do), and still try to use SQL Authentication, would the system let
me on? I guess what I am asking is whether I have to setup some WinNT
server permission in order to even attempt to use SQL Authentication?
Let me ask this, does Windows still try to authenticate under the
service account to the SQL Server box even if you are trying to use SQL
Authentication to make the connection. In other words, if were to
impersonate say, myself, with administrative rights (which I don't want
to do), and still try to use SQL Authentication, would the system let
me on? I guess what I am asking is whether I have to setup some
Win2000 server permission in order to even attempt to use SQL
Authentication?
If you are impersonating, the credentials sent to SQL Server
will be those of the account you're impersonating, unless you
specify a particular account in the connection string.
For that to be sucessful (specifying a particular account in the connstring),
you need to allow SQL Server authentication, not Windows authentication.
If you are using Windows authentication, the account credentials sent to
SQL Server will be those of the Windows account which ASP.NET is running as.
Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
<ry************@kp.org> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com... Let me ask this, does Windows still try to authenticate under the service account to the SQL Server box even if you are trying to use SQL Authentication to make the connection. In other words, if were to impersonate say, myself, with administrative rights (which I don't want to do), and still try to use SQL Authentication, would the system let me on? I guess what I am asking is whether I have to setup some WinNT server permission in order to even attempt to use SQL Authentication?
Also, this is in my web config by default. Do I need to change this???
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data
source=127.0.0.1;Trusted_Connection=yes"
cookieless="false"
timeout="20"
Not unless you want to maintain state with State Server or SQL Server.
That doesn't affect your SQL Server connections.
Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================
"Ryan" <ry************@kp.org> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com... Also, this is in my web config by default. Do I need to change this???
mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: dale zhang |
last post by:
Hi,
I write an asp.net web application. It has a “Contact Us†page, where users
fill in their email, subject and text and hit send. Then the email will go to
my hard coded yahoo email...
|
by: Ravikanth[MVP] |
last post by:
Hi
It is possible that IIS and SQL Server can reside on
Seperate Machines and you can use Integrated Windows
Authentication to connect.
Ravikanth
>-----Original Message-----
|
by: Lior Amar |
last post by:
Hey All,
Trying to understand why I can not get SQL server to trust my IIS server. I
have two machines set up, 1 App and 1 DB, and I'm trying to validate the
applications access to the DB server...
|
by: news.microsoft.com |
last post by:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I guess I get this because, my pages are hosted on WinXP IIS and the sql
server is on Win2k3.
...
|
by: Nils Magnus Englund |
last post by:
Hello,
I am having trouble using Integrated Windows Authentication between our
intranet server and our database server, both of which are on our local
domain.
Windows authentication works for...
|
by: Alice Wong |
last post by:
I am setting up my Web ASP.net application to connect to Sql server using
windows authentication.
I set up IIS to have integrated windows authenication and sql to allow
Windows authentication....
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview with answers
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of...
|
by: troywalker |
last post by:
I am new to LDAP and Directory Services, and I have a project that
requires me to authenticate users against a Sun Java System Directory
Server in order to access the application. I have found...
|
by: Preben Zacho |
last post by:
Hi there
The scenario I got is this: I have created a Windows application in VS and I
want to deploy it to another machine running Windows Vista. Since I have no
control over this other machine,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |