MBR IT/.NET 247 : ASP.Net & SQLServer on ASPFriends.com 'ngfx-sqlclient' list

ASP.Net & SQLServer

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.

-- Moved from [aspngibuyspy] to [ngfx-sqlclient] by Bob Levittan <Click here to reveal e-mail address> --

I have had my ASP.Net app and SQLServer working on the same machine with
Windows Authentication --- No Problem.

I am now working on moving the SQLServer to a separate machine.
In my asp.net web.config file I have had the connection string spec as
follows:
<add key="ConnectionString"
value="server=(local);Trusted_Connection=true;database=iBuySpyBasedPortal"
/>

I am trying to setup this up to working with the now remote SQLServer and or
a ODBC DSN.
I changed server to the remote sqlserver name, get trusted connection error.

I am running into permissios issues.
Some research indicated that I need to grant previliges to the ASPNET iis
user for SQLServer access.

I also tried setting up the connection string with a SQL authentication
account. Run into

Any pointers will be greatly appreciated.

Thank you

Fred

Reply to this message...

Chris Brown

I use

<appSettings>
<add key="conn" value="Data Source=sqlserver;Initial Catalog=database;User
ID=sqluser;Persist Security Info=True" />
</appSettings>

in my web.config file, using SQL authentication. Check you've got SQL and
Windows authentication set, that gave me a big headache not long ago

hth

Chris
----- Original Message -----
From: "FS" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Saturday, July 06, 2002 8:51 PM
Subject: [ngfx-sqlclient] ASP.Net & SQLServer

> -- Moved from [aspngibuyspy] to [ngfx-sqlclient] by Bob Levittan
<Click here to reveal e-mail address> --
[Original message clipped]

Reply to this message...

Try installing the MDAC 2.7

Kind regards

J Duarte

http://www.sippa.net

-----Mensaje original-----
De: FS [mailto:Click here to reveal e-mail address]
Enviado el: sábado, 06 de julio de 2002 21:52
Para: ngfx-sqlclient
Asunto: [ngfx-sqlclient] ASP.Net & SQLServer

-- Moved from [aspngibuyspy] to [ngfx-sqlclient] by Bob Levittan
<Click here to reveal e-mail address> --

I have had my ASP.Net app and SQLServer working on the same machine with
Windows Authentication --- No Problem.

I am now working on moving the SQLServer to a separate machine.
In my asp.net web.config file I have had the connection string spec as
follows:
<add key="ConnectionString"
value="server=(local);Trusted_Connection=true;database=iBuySpyBasedPortal"
/>

I am trying to setup this up to working with the now remote SQLServer and or
a ODBC DSN.
I changed server to the remote sqlserver name, get trusted connection error.

I am running into permissios issues.
Some research indicated that I need to grant previliges to the ASPNET iis
user for SQLServer access.

I also tried setting up the connection string with a SQL authentication
account. Run into

Any pointers will be greatly appreciated.

Thank you

Fred

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

Reply to this message...

Iain Smallwood

Your message is unclear as to what you have tried - have you granted the
ASPNET user SQL permissions? That is the account under which ASP.NET
will run. It will be a LOCAL not a domain account so will have problems
being trusted by a different machine on the network.

Try setting IIS security for you app directory to use Windows not
Anonymous authentication, OR to Anonymous with a specific domain user,
granting either way SQL privs to your Database.

Then you can add a line so that where in your web.config you had
<authentication mode="Windows" />

underneath it you now have
<identity impersonate="true"/>

This line will cause ASP to run under the account IIS is running under.
If you look in the help you can alternatively use tokens or whatever to
impersonate for a finite period if this would be a security breach. The
lower security you run under the better basically.

Hope this helps.

Cheers,
Iain

-----Original Message-----
From: FS [mailto:Click here to reveal e-mail address]
Sent: 06 July 2002 20:52
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] ASP.Net & SQLServer

-- Moved from [aspngibuyspy] to [ngfx-sqlclient] by Bob Levittan
<Click here to reveal e-mail address> --

I have had my ASP.Net app and SQLServer working on the same machine with
Windows Authentication --- No Problem.

I am now working on moving the SQLServer to a separate machine. In my
asp.net web.config file I have had the connection string spec as
follows:
<add key="ConnectionString"
value="server=(local);Trusted_Connection=true;database=iBuySpyBasedPorta
l"
/>

I am trying to setup this up to working with the now remote SQLServer
and or a ODBC DSN. I changed server to the remote sqlserver name, get
trusted connection error.

I am running into permissios issues.
Some research indicated that I need to grant previliges to the ASPNET
iis user for SQLServer access.

I also tried setting up the connection string with a SQL authentication
account. Run into

Any pointers will be greatly appreciated.

Thank you

Fred

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

Disclaimer
This message may contain information which is legally privileged and/or
confidential. If you are not the intended recipient, you are hereby
notified that any unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such notification not
withstanding, any comments or opinions expressed are those of the
originator, not of Taylor Made Computer Solutions, unless otherwise
explicitly stated.

Reply to this message...

ToddC@match.com

The problem is, ASPNET is a local user to the IIS machine, and the SQL Box
doesn't know anything about it.

For this to work you need to create a Domain Level login, call it say
remoteASPNET, and configure the ASP.NET Worker Process (aspnet_wp.exe) via
the machine.config (processModel node) to use the domain level login.

Then give the remoteASPNET user login and permissions in your SQL Server.

Does that make sense?

tc

-----Original Message-----
From: FS [mailto:Click here to reveal e-mail address]
Sent: Saturday, July 06, 2002 2:52 PM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] ASP.Net & SQLServer

-- Moved from [aspngibuyspy] to [ngfx-sqlclient] by Bob Levittan
<Click here to reveal e-mail address> --

I have had my ASP.Net app and SQLServer working on the same machine with
Windows Authentication --- No Problem.

I am now working on moving the SQLServer to a separate machine.
In my asp.net web.config file I have had the connection string spec as
follows:
<add key="ConnectionString"
value="server=(local);Trusted_Connection=true;database=iBuySpyBasedPortal"
/>

I am trying to setup this up to working with the now remote SQLServer and or
a ODBC DSN.
I changed server to the remote sqlserver name, get trusted connection error.

I am running into permissios issues.
Some research indicated that I need to grant previliges to the ASPNET iis
user for SQLServer access.

I also tried setting up the connection string with a SQL authentication
account. Run into

Any pointers will be greatly appreciated.

Thank you

Fred

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

Reply to this message...

José Luis Chávez del Cid

Have you tried to add the \\machine\username (might be something like \\IISSERVER\ASPNET) to the security section on SQL Server, and givinig priviliges to this Windows User on the database tables.

José Luis Chávez del Cid
www.sat.gob.gt

------------------------------------------------
On Mon, 8 Jul 2002 17:22:26 +0200, "JL" <Click here to reveal e-mail address> wrote:

[Original message clipped]

Reply to this message...

Juan F. Posadas

I think the issues are in the system domain. The SQL server has to have
trusted and windows authentication set properly and be in the domain.
Meaning, your SQL Server had to be installed with domain privileges

Juan Posadas

-----Original Message-----
From: José Luis Chávez del Cid [mailto:Click here to reveal e-mail address]
Sent: Monday, July 08, 2002 11:28 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] RE: ASP.Net & SQLServer

Have you tried to add the \\machine\username (might be something like
\\IISSERVER\ASPNET) to the security section on SQL Server, and givinig
priviliges to this Windows User on the database tables.

José Luis Chávez del Cid
www.sat.gob.gt

------------------------------------------------
On Mon, 8 Jul 2002 17:22:26 +0200, "JL" <Click here to reveal e-mail address> wrote:

[Original message clipped]

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

Reply to this message...

Tim Curtin

change the connection string to "data source=otherSQLServer" or an IP
address if public and not "(local)".

[Original message clipped]

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Reply to this message...

José Luis Chávez del Cid

Sorry, my answer was pretty wrong, but what TC says is the correct one.
José Luis Chávez del Cid
------------------------------------------------ On Mon, 08 Jul 2002
14:15:28 -0400, "Tim Curtin" wrote: > change the connection string to
"data source=otherSQLServer" or an IP > address if public and not
"(local)". > > >From: "Juan F. Posadas" > >Reply-To: "ngfx-sqlclient" >
>To: "ngfx-sqlclient" > >Subject: [ngfx-sqlclient] RE: ASP.Net &
SQLServer > >Date: Mon, 8 Jul 2002 11:59:35 -0500 > > > >I think the
issues are in the system domain. The SQL server has to have > >trusted
and windows authentication set properly and be in the domain. >
[Original message clipped]

2002 11:28 AM > >To: ngfx-sqlclient > >Subject: [ngfx-sqlclient] RE:
ASP.Net & SQLServer > > > > > >Have you tried to add the
\\machine\username (might be something like > >\\IISSERVER\ASPNET) to
the security section on SQL Server, and givinig > >priviliges to this
Windows User on the database tables. > > > >José Luis Chávez del Cid >
[Original message clipped]

sábado, 06 de julio de 2002 21:52 > > > Para: ngfx-sqlclient > > >
Asunto: [ngfx-sqlclient] ASP.Net & SQLServer > > > > > > > > > -- Moved
from [aspngibuyspy] to [ngfx-sqlclient] by Bob Levittan > > > -- > > > >
> > I have had my ASP.Net app and SQLServer working on the same machine
with > > > Windows Authentication --- No Problem. > > > > > > I am now
working on moving the SQLServer to a separate machine. > > > In my
asp.net web.config file I have had the connection string spec as > > >
follows: > > > > > >
[Original message clipped]

server to the remote sqlserver name, get trusted connection > >error. >
> > > > > I am running into permissios issues. > > > Some research
indicated that I need to grant previliges to the ASPNET > >iis > > >
user for SQLServer access. > > > > > > I also tried setting up the
connection string with a SQL authentication > > > account. Run into > >
[Original message clipped]

http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT > >
> > > > > > > > > > | [ngfx-sqlclient] member Click here to reveal e-mail address YOUR ID > > > | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp
= JOIN/QUIT > > > > > > >| [ngfx-sqlclient] member
Click here to reveal e-mail address = YOUR ID > >|
http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT > >
> > > >| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID > >|
http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT > >
[Original message clipped]

Reply to this message...

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com