Connecting to SQL from IIS

Hi All,
I'm attempting to connect my .asp page to an SQL 2005 server and I'm
receiving the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user ''. The
user is not associated with a trusted SQL Server connection.
The SQL server is set for mixed authentication and my connection string
points to an ODBC connection on my web server (and it showed that it was
successfully able to connect after the DSN was created). Are there other
steps on my SQL server that need to be performed to allow for authentication
from IIS? I will also post my connection string below from my ASP page:
<%
Const adOpenStatic = 3
Const adLockReadOnly = 1
'Open Connection to Database
set Conn = Server.CreateObject("ADODB.Connection")
qryDSN = "DSN=BT"
Conn.open qryDSN
set rs = Server.CreateObject("ADODB.RecordSet")
sql = "SELECT CO_COMPANY_NAME FROM COMPANIES"
rs.open sql, conn, adOpenStatic, adLockReadOnly
rs.movefirst
do while not rs.EOF
response.Write(rs.fields(0))
loop
%>
Any help is appreciated!!
Joe Corey
MCSE, MCSA, Security+
jcorey@.andrew.cmu.eduIs the DSN using a SQL Authen. or WIndows Authenticatio. I guess it is
using Windows Authentication and the SQL Server is not on the same box
like the IIS Server. If so, and my guess was right, you will have to
enabled the IIS to delegate authentication. More about this can be
found on the MSDN knowledge base article. Simply search for "Delegation
AND SQL SERVER". After setting up a security principal name SPN you
will be able to authenticate the users.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

Connecting to SQL Failed

I am trying to connect to SQL following the directions in Learn ASP.NET in 24 hours I am on page 332-334 where i try to create a Data base for the first time.

I am using a localhost configuration.

I get the following message

"Unable to connect to database server.

SQL does not exist or access denied.

ConnectionOpen(Connect())"

However I see that SQL server(SQLEXPRESS) and SQL server browser are both running and their start state is automatic

Hi,

You can reach SQLEXPRESS instance as ComputerName\SQLExpress

connecting to SQL db in an asp.net page

Ok, I'm an experienced asp developer switching to asp.net.

I've used the "Quickstart Tutorials" (http://www.asp.net/Tools/redir.aspx?path=quickstart) and have gotten started that way and built a few things based on that, but they only show XML connection info. Now I need to switch to SQL so I can connect to MS SQL Server for some stored procedures.

Anyone have suggestions?

(I've dug through some articles on msdn, etc, but I've only found so far theory and not code. And let me tell 'ya, I'm big on learning about code from code.)

If this helps, the specific tasks I'm trying to do are:
Have user select a static value from a drop down list, enter a word in a text box, and submit the form (so far so good), which connects to the db and returns the datagrid filled with results (the part I don't have). I already have my sp, just can't connect to it and get results back into the page.The Tutorials on this site have an example of doing just that. Check outPerforming a Parameterized Select

Sound like you have all of the pieces you need, you just need to stitch them together. Viewing the source code of that example should help you do just that. Post back if you are having trouble implementing it.

Terri|||I receive this error:

Server Error in '/Test1' Application.
------------------------

The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested Url: /Test1/VB/datagrid2.aspx|||The problem is probably with the SqlConnection -- specifically, it is trying to read the connection string out of the web.config file. This is a good practice. But, let's try to get the sample running for you first.

Instead of this line:

MyConnection = New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("PubsString"))

Try this line (assuming you are using a local SQL Server with Windows authentication)

MyConnection = New SqlClient.SqlConnection("server=(local);database=pubs;Trusted_Connection=yes")

Terri|||Ok, I'm looking at these various example ways to set up and connect to dbs.

I have a local sql server running on my machine.
I can use the sa account.
I have databases, sps, and tables already on it.

I've tried looking at the examples and changing to fit, but either I'm missing something or I've put info in the wrong place.

hum.|||YAY YAY YAY!!!

Thank you! I changed your line:
MyConnection = New SqlClient.SqlConnection("server=(local);database=pubs;Trusted_Connection=yes")

To:
MyConnection = New SqlClient.SqlConnection("server=(local);database=mydbname;uid=sa;pwd=sa;")

and it works in the datagrid2.aspx sample file! 8)

Whew!

Ok, now time to get this working in my files...

Thanks again!

Connecting to Northwind

On the 3rd page of the Tutorial 1, there is a section Connecting to the Database in a Microsoft SQL Server 2000 or 2005 Database Server. It instructs you to connect to the Northwind database in the C:\DataTutorial\App_Data directory. I have Northwind.mdf showing up in my Server Explorer and it is 3.7 mb in size in the directory, but the Server Explorer shows it with a - sign beside it and I cannot figure any way to get access to the tables, views, etc. I have read and re-read everything I can find on this and I know I am missing something simple, but I am stumped. Can anyone offer some help? Thanks, Ron

Do you have the Northwind database server-attached to your running srver, or did you setup the database as a user instance in your server explorer ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Jens,

It appears that Visual Studio solved the problem. When I opened my project today, the Northwnd.mdf database showed up fully populated in the Server Explorer window.

If you have any clue as to what I could have done yesterday to not properly permit the database to show, I would love to know so I don't do it again. I don't know if I had my "database server-attached to your running srver, or did you setup the database as a user instance in your server explorer ?" All I did was put the file in northwnd.mdf file into the c:\DataTutorial\App_Data\ directory. When it didn't show up, I also executed the instwnd.sql file with debug turned off, but, at least yesterday, that didn't seem to help.

Thanks again,

Ron Hall

sqlsql

connecting to MSDE using SSPI

Please advise: I have created a simple ASPX page to test if I can connect to MSDE on a Server 2003 system. The connection string that works ok is:

server=WS1;database=northwind;integrated security=false;user id=sa;password=xxx;

but the string that does not work is:

server=WS1;database=northwind;integrated security=SSPI;

which is the string I would like to use for normal web access. This string works fine on my development system (where I use XP Pro and IIS 5.1)

In IIS6 on the "production server" the directory security on the virtual dir is set to allow anonymous access, using user IUSR_WS1 (where WS1 is the name of the system) and to integrated security.

Please help! Thank you

John BI forgot to say the error message I am getting is:

login failed for user 'NTAUTHORITY\NETWORK SERVICE'|||There is a KB for this problem:PRB: "Login Failed" Error Message When You Create a Trusted Data Connection from ASP.NET to SQL Server. See if any of the 3 suggested Resolutions work for you.

To me, the 3rd suggestion seems to be the best course of action. And taking that further, what seems to make the most sense is to add a new database role called "webuser" or something similar, and then add the NT AUTHORITY\NETWORK SERVICE user to that role. This will give you more flexibility if the web app moves to a Windows 2000 machine -- you would just be able to add the ASPNET account as another member of that webuser role.

Terri|||Thank you for your reply. I looked at the article, but I regret to say it does not make much sense to me at this stage. I have bought the MSDE Admin tool to administer MSDE, or could use the osql tool, but am not clear how to:

a. add a new database role (is this adding a "normal" user group)? I dont see any reference to a "database role".

b. add the NTAUTHORITY\NETWORK SERVICE user to that role. I have looked at the list of users and there is no such name. I must be looking in the wrong place.

Excuse my ignorance!

TIA

John B|||You should downloadSQL Server 2000 Books Online. This is a huge download but an essential reference.

I have to admit, I am confused on this issue. I have now come across an article right on this siteRunning ASP.NET 1.1 with IIS 6.0, and part of it covers supporting integrated authentication with SQL Server. The suggestion I gave you was based on something I read elsewhere that seemed to make sense.

Further information on the path I suggested:

The system stored procedure to add a database role is sp_addrole. You'd use it like this:

EXEC sp_addrole 'webuser'

The system stored procedure to add a security account for a Windows user to the current database and enable it to be granted permissions to perform activities in the database is sp_grantdbaccess.

EXEC sp_grantdbaccess 'NT AUTHORITY\NETWORK SERVICE', 'Network Service'

The system stored procedure to add a security account as a member of an existing database role in the current database is sp_addrolemember.

EXEC sp_addrolemember 'webuser', 'Network Service'

Terri|||Thank you. The article you suggested in the last post is very helpful. I have now solved the problem, thanks to an article I found www.cgnit.com/resources/ntauthority_networkservice_error.html

which hits it bang on the nose, and may be useful to others.

It seems to me that all the books, and many of the forums suggest that when you run an ASP.NET app and use anonymous access, the system uses the identity mcxxx\aspnet (where mcxxx is the domain or machine no). But what I have found so far is that under Server 2003, the identity assumed is the mysterious user NTAUTHORITY\NETWORKSERVICE which is NOT found in the list of users, but is apparently a member of the IIS_WPG group, so configuring this group to access the database solves the problem and allows an anonymous user to access records according to the permissions set within MSDE or SQL Server.

Can anyone confirm this is true? Is the ASPNET user in fact NEVER used in Server 2003, but only in W2000 or XP?|||Yes, I can confirm that. I ran into this today, setting up ibuyspy on a Windows2003 server. Here's the quote I found in the machine.config file:
When ASP.NET is running under IIS 6 in native mode, the IIS 6 process model is
used and settings in this section are ignored. Please use the IIS administrative
UI to configure things like process identity and cycling for the IIS
worker process for the desired application

I went ahead and added the IIS_WPG to access the DB I cared about, but you could also setup your own IIS6 AppPool with seperate identity information.

/Brad|||

I cannot but say, its a great thread !!

regards

Connecting to Analysis Services using HTTP

my analysis server is hosted on a win2k server with IIS, the hosting page is
on another machine. I have followed everything as per MS KB article and I
could not connect through the analysis server using http. i have similar
implementation on my dev machine but the main difference is my OLAP is on
top of winxp. i just wanted to know if i am missing any other setting not
specified on the MS KB article on how to implement OLAP cube through HTTP
over win2k operating system.

note: i tried connecting to olap using the MDX sample application using
MSOLAP.2 provider and connecting through a simple office web component. I
think the best way to test the connection is through the MDX sample
application that comes with Analysis Server installation.Check security for IIS and to the C:\Program Files\Microsoft Analaysis
Server\Bin folder and hidden share. Without any error messages there
is little we can help you with.|||Adam,
I am able to access the msolap.asp through the website. that means I
have permission to the file on the IIS side.
I will be checking the permission on the Analysis Server folder.

Whenever I try to connect using the MDX Sample Application to the HTTP
server(with my cubes) the app seem to hang. after waiting
for about 2 minutes it gives me an error "unable to connect..."

"Adam J. Tybor" <adam.tybor@.gmail.com> wrote in message
news:1096106771.514490.178060@.k17g2000odb.googlegr oups.com...
> Check security for IIS and to the C:\Program Files\Microsoft Analaysis
> Server\Bin folder and hidden share. Without any error messages there
> is little we can help you with.

Connecting to a remote OLE DB

Hey, all. I've mainly worked with MySQL databases before. I'm working on an (old) ASP page that uses this connection string:

strConnect ="Provider=SQLOLEDB; Data Source=SQL1.MYDBSERVER.NET; Initial Catalog=...; User ID=...; Password=..."

It works fine on the production server, but the local copy fails if I try to access the Products page (which uses the database), with this error:

Microsoft OLE DB Providerfor SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/html/products.asp, line 19

Similarly, if I plug the connection info into Tools/Connect to Database in Visual Studio, I get:

Connection failed:
SQLState:'08001'SQL Server Error: 17[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

Am I doing something wrong? Do I need more info from the hosting provider to connect remotely? Or is the database not accepting remote connections at all?

Thanks in advance for your help!

It might be that you do not have permission to access it or it might be that database is old (version 7.0) and that you cannot connect from Management studio. Check it with hosting provider.

Connecting to a Clients SQL server

I am not sure if its possible, hopefully it is. I would like to create a custom page for one of my clients to log into and access information from their SQL server. If I have all the connection information, i.e user id and password etc. Can this be done. I know how to connect to an SQL server locally. If anyone can give me a point in the right direction, it would be greatly appreciative.

If this is possible, I am looking at adding a button on this page to allow the client to transfer records that meet specific criteria in a column in their database into a designated database on my server.

Thanks for any help.If your server can access their SQL Server, sure. Ask them for the TCP/IP connection information, and if you can see their server, you should be able to pull it off.

The difference from what you may be doing locally, is that instead of server=(local), you'll likely have the IP address of their server, and you may be using Windows Authentication locally, but you'll use SQL security to connect to their machine.

Regards,

Xander

connecting AS400

hi all,
we are running a dts that migrates data from an as400 to sql 2K.
the string data is hebrew (code page 1252).
for that, we have been using a hit odbc:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
untill now we were running the dts from sql 7.0 and that worked well.
the porblem started after copying (and then rewriting) the package to sql 2k
:
when running the dts manually (execute package) it's o.k, but when running
the dts via a job the hebrew characters are being mirrored in the sql 2k.
(e.g, written from left to write instead of right to left).
again, in sql 7 it worked well both ways.
some details:
-in both cases (job and manually) we execute the package from the same serve
r.
-the win login account used for manual executing is identical to the log on
accounts of server service and server agent.
we are using a system dsn.
I have found in a newsgroup a tip to solve that: using a user dsn.
but when I tried that another porblem came up:
when running manualy - it was, again, ok
but when running via a job (or with dtsrun) the server couldn't find the odb
c.
here is the error massage:
DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2DTSRun OnStart: DTSStep_DTSDataPumpTask_1DTSRun
OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
string: [Microsoft][ODBC Driver Manager] Data source name not found
and no
default driver specified Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0Error Detail Records:Error:
-2147467259 (80004005); Provider Error: 0 (0) Error string: Error
source: Help file: Help context: 0DTSRun OnFinish:
DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
so.. any help will be usefull (regarding the hebrew mirroring or regarding
finding the user dsn)
thanks,
elad.Elad, shalom
I assume you got connected by using Client Access to the AS400.
Look , first of all it depends on lot of things
1) Right click on the server within a package and press "Advance" button.
Under Property name you will find Auto Translate=1 or =0. Try to play with
it.
" " <@.discussions.microsoft.com> wrote in message
news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
> hi all,
> we are running a dts that migrates data from an as400 to sql 2K.
> the string data is hebrew (code page 1252).
> for that, we have been using a hit odbc:
> ODBC OPTIMIZED (READ ONLY) 32 BIT
> VERSION 4.00.06.20
> HIT SOFTWARE, INC
> untill now we were running the dts from sql 7.0 and that worked well.
> the porblem started after copying (and then rewriting) the package to sql
> 2k:
> when running the dts manually (execute package) it's o.k, but when running
> the dts via a job the hebrew characters are being mirrored in the sql 2k.
> (e.g, written from left to write instead of right to left).
> again, in sql 7 it worked well both ways.
> some details:
> -in both cases (job and manually) we execute the package from the same
> server.
> -the win login account used for manual executing is identical to the log
> on
> accounts of server service and server agent.
> we are using a system dsn.
> I have found in a newsgroup a tip to solve that: using a user dsn.
> but when I tried that another porblem came up:
> when running manualy - it was, again, ok
> but when running via a job (or with dtsrun) the server couldn't find the
> odbc.
> here is the error massage:
> DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1DTSRun
> OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
> Error
> string: [Microsoft][ODBC Driver Manager] Data source name not fou
nd and
> no
> default driver specified Error source: Microsoft OLE DB Provider for
> ODBC
> Drivers Help file: Help context: 0Error Detail Records:Error:
> -2147467259 (80004005); Provider Error: 0 (0) Error string: Error
> source: Help file: Help context: 0DTSRun OnFinish:
> DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
> so.. any help will be usefull (regarding the hebrew mirroring or regarding
> finding the user dsn)
> thanks,
> elad.
>
>
>
>|||hi Uri,
well, I used the HIT odbc for as400.
here are it's details again:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
and, for that odbc I couldn't find a auto translate property.
I also looked for a download of the client access odbc but couldn't find it.
so... I will thakfull for a link
thanks,
elad.
"Uri Dimant" wrote:

> Elad, shalom
> I assume you got connected by using Client Access to the AS400.
> Look , first of all it depends on lot of things
> 1) Right click on the server within a package and press "Advance" button.
> Under Property name you will find Auto Translate=1 or =0. Try to play with
> it.
>
>
> "_ìò? ùì?_" <@.discussions.microsoft.com> wrote in message
> news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
>
>

connecting AS400

hi all,
we are running a dts that migrates data from an as400 to sql 2K.
the string data is hebrew (code page 1252).
for that, we have been using a hit odbc:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
untill now we were running the dts from sql 7.0 and that worked well.
the porblem started after copying (and then rewriting) the package to sql 2k:
when running the dts manually (execute package) it's o.k, but when running
the dts via a job the hebrew characters are being mirrored in the sql 2k.
(e.g, written from left to write instead of right to left).
again, in sql 7 it worked well both ways.
some details:
-in both cases (job and manually) we execute the package from the same server.
-the win login account used for manual executing is identical to the log on
accounts of server service and server agent.
we are using a system dsn.
I have found in a newsgroup a tip to solve that: using a user dsn.
but when I tried that another porblem came up:
when running manualy - it was, again, ok
but when running via a job (or with dtsrun) the server couldn't find the odbc.
here is the error massage:
DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2DTSRun OnStart: DTSStep_DTSDataPumpTask_1DTSRun
OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
string: [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0Error Detail Records:Error:
-2147467259 (80004005); Provider Error: 0 (0) Error string: Error
source: Help file: Help context: 0DTSRun OnFinish:
DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
so.. any help will be usefull (regarding the hebrew mirroring or regarding
finding the user dsn)
thanks,
elad.Elad, shalom
I assume you got connected by using Client Access to the AS400.
Look , first of all it depends on lot of things
1) Right click on the server within a package and press "Advance" button.
Under Property name you will find Auto Translate=1 or =0. Try to play with
it.
"àìòã ùìåí" <@.discussions.microsoft.com> wrote in message
news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
> hi all,
> we are running a dts that migrates data from an as400 to sql 2K.
> the string data is hebrew (code page 1252).
> for that, we have been using a hit odbc:
> ODBC OPTIMIZED (READ ONLY) 32 BIT
> VERSION 4.00.06.20
> HIT SOFTWARE, INC
> untill now we were running the dts from sql 7.0 and that worked well.
> the porblem started after copying (and then rewriting) the package to sql
> 2k:
> when running the dts manually (execute package) it's o.k, but when running
> the dts via a job the hebrew characters are being mirrored in the sql 2k.
> (e.g, written from left to write instead of right to left).
> again, in sql 7 it worked well both ways.
> some details:
> -in both cases (job and manually) we execute the package from the same
> server.
> -the win login account used for manual executing is identical to the log
> on
> accounts of server service and server agent.
> we are using a system dsn.
> I have found in a newsgroup a tip to solve that: using a user dsn.
> but when I tried that another porblem came up:
> when running manualy - it was, again, ok
> but when running via a job (or with dtsrun) the server couldn't find the
> odbc.
> here is the error massage:
> DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1DTSRun
> OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
> Error
> string: [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> default driver specified Error source: Microsoft OLE DB Provider for
> ODBC
> Drivers Help file: Help context: 0Error Detail Records:Error:
> -2147467259 (80004005); Provider Error: 0 (0) Error string: Error
> source: Help file: Help context: 0DTSRun OnFinish:
> DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
> so.. any help will be usefull (regarding the hebrew mirroring or regarding
> finding the user dsn)
> thanks,
> elad.
>
>
>
>|||hi Uri,
well, I used the HIT odbc for as400.
here are it's details again:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
and, for that odbc I couldn't find a auto translate property.
I also looked for a download of the client access odbc but couldn't find it.
so... I will thakfull for a link
thanks,
elad.
"Uri Dimant" wrote:
> Elad, shalom
> I assume you got connected by using Client Access to the AS400.
> Look , first of all it depends on lot of things
> 1) Right click on the server within a package and press "Advance" button.
> Under Property name you will find Auto Translate=1 or =0. Try to play with
> it.
>
>
> "à ìòã ùìåí" <@.discussions.microsoft.com> wrote in message
> news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
> > hi all,
> > we are running a dts that migrates data from an as400 to sql 2K.
> > the string data is hebrew (code page 1252).
> > for that, we have been using a hit odbc:
> > ODBC OPTIMIZED (READ ONLY) 32 BIT
> > VERSION 4.00.06.20
> > HIT SOFTWARE, INC
> >
> > untill now we were running the dts from sql 7.0 and that worked well.
> > the porblem started after copying (and then rewriting) the package to sql
> > 2k:
> > when running the dts manually (execute package) it's o.k, but when running
> > the dts via a job the hebrew characters are being mirrored in the sql 2k.
> > (e.g, written from left to write instead of right to left).
> > again, in sql 7 it worked well both ways.
> >
> > some details:
> > -in both cases (job and manually) we execute the package from the same
> > server.
> > -the win login account used for manual executing is identical to the log
> > on
> > accounts of server service and server agent.
> > we are using a system dsn.
> >
> > I have found in a newsgroup a tip to solve that: using a user dsn.
> > but when I tried that another porblem came up:
> > when running manualy - it was, again, ok
> > but when running via a job (or with dtsrun) the server couldn't find the
> > odbc.
> > here is the error massage:
> >
> > DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
> > DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
> > DTSStep_DTSExecuteSQLTask_2DTSRun OnStart:
> > DTSStep_DTSDataPumpTask_1DTSRun
> > OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
> > Error
> > string: [Microsoft][ODBC Driver Manager] Data source name not found and
> > no
> > default driver specified Error source: Microsoft OLE DB Provider for
> > ODBC
> > Drivers Help file: Help context: 0Error Detail Records:Error:
> > -2147467259 (80004005); Provider Error: 0 (0) Error string: Error
> > source: Help file: Help context: 0DTSRun OnFinish:
> > DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
> >
> > so.. any help will be usefull (regarding the hebrew mirroring or regarding
> > finding the user dsn)
> >
> > thanks,
> > elad.
> >
> >
> >
> >
> >
> >
> >
>
>

connecting AS400

hi all,
we are running a dts that migrates data from an as400 to sql 2K.
the string data is hebrew (code page 1252).
for that, we have been using a hit odbc:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
untill now we were running the dts from sql 7.0 and that worked well.
the porblem started after copying (and then rewriting) the package to sql 2k:
when running the dts manually (execute package) it's o.k, but when running
the dts via a job the hebrew characters are being mirrored in the sql 2k.
(e.g, written from left to write instead of right to left).
again, in sql 7 it worked well both ways.
some details:
-in both cases (job and manually) we execute the package from the same server.
-the win login account used for manual executing is identical to the log on
accounts of server service and server agent.
we are using a system dsn.
I have found in a newsgroup a tip to solve that: using a user dsn.
but when I tried that another porblem came up:
when running manualy - it was, again, ok
but when running via a job (or with dtsrun) the server couldn't find the odbc.
here is the error massage:
DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2DTSRun OnStart: DTSStep_DTSDataPumpTask_1DTSRun
OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error
string: [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0Error Detail Records:Error:
-2147467259 (80004005); Provider Error: 0 (0) Error string: Error
source: Help file: Help context: 0DTSRun OnFinish:
DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
so.. any help will be usefull (regarding the hebrew mirroring or regarding
finding the user dsn)
thanks,
elad.
Elad, shalom
I assume you got connected by using Client Access to the AS400.
Look , first of all it depends on lot of things
1) Right click on the server within a package and press "Advance" button.
Under Property name you will find Auto Translate=1 or =0. Try to play with
it.
" " <@.discussions.microsoft.com> wrote in message
news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
> hi all,
> we are running a dts that migrates data from an as400 to sql 2K.
> the string data is hebrew (code page 1252).
> for that, we have been using a hit odbc:
> ODBC OPTIMIZED (READ ONLY) 32 BIT
> VERSION 4.00.06.20
> HIT SOFTWARE, INC
> untill now we were running the dts from sql 7.0 and that worked well.
> the porblem started after copying (and then rewriting) the package to sql
> 2k:
> when running the dts manually (execute package) it's o.k, but when running
> the dts via a job the hebrew characters are being mirrored in the sql 2k.
> (e.g, written from left to write instead of right to left).
> again, in sql 7 it worked well both ways.
> some details:
> -in both cases (job and manually) we execute the package from the same
> server.
> -the win login account used for manual executing is identical to the log
> on
> accounts of server service and server agent.
> we are using a system dsn.
> I have found in a newsgroup a tip to solve that: using a user dsn.
> but when I tried that another porblem came up:
> when running manualy - it was, again, ok
> but when running via a job (or with dtsrun) the server couldn't find the
> odbc.
> here is the error massage:
> DTSRun: Loading...DTSRun: Executing...DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1DTSRun
> OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
> Error
> string: [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> default driver specified Error source: Microsoft OLE DB Provider for
> ODBC
> Drivers Help file: Help context: 0Error Detail Records:Error:
> -2147467259 (80004005); Provider Error: 0 (0) Error string: Error
> source: Help file: Help context: 0DTSRun OnFinish:
> DTSStep_DTSDataPumpTask_1DTSRun: Package execution complete.NULL
> so.. any help will be usefull (regarding the hebrew mirroring or regarding
> finding the user dsn)
> thanks,
> elad.
>
>
>
>
|||hi Uri,
well, I used the HIT odbc for as400.
here are it's details again:
ODBC OPTIMIZED (READ ONLY) 32 BIT
VERSION 4.00.06.20
HIT SOFTWARE, INC
and, for that odbc I couldn't find a auto translate property.
I also looked for a download of the client access odbc but couldn't find it.
so... I will thakfull for a link
thanks,
elad.
"Uri Dimant" wrote:

> Elad, shalom
> I assume you got connected by using Client Access to the AS400.
> Look , first of all it depends on lot of things
> 1) Right click on the server within a package and press "Advance" button.
> Under Property name you will find Auto Translate=1 or =0. Try to play with
> it.
>
>
> "Xìò? ùì?X" <@.discussions.microsoft.com> wrote in message
> news:12A0B201-3D38-4626-9DD1-155623940393@.microsoft.com...
>
>

Connect to SQL with NT authentication from form...

I have a login page that checks the given userid/password against ADSI and redirects the user if successful. My problem seems to come when I try to connect to the SQL database with the user's NT credentials. I have the user's NT account setup in SQL, have anony. disabled in IIS, using Integrated Windows Security in IIS, and am using the following connection string:

connectionString = "data source=SqlServer;initial catalog=pubs;Trusted_Connection=Yes"

I also have this entry in my Web.Config file: <identity impersonate="true" /
Actually, it seems to connect OK, but I can not select any data. I just receive "Select permission denied..." errors even though the user has been given these permissions in SQL.

Any advice would be greatly appreciated.

Thanks,
-BenYou need to set the proper access rights in for the User in SQL Server itself.|||The user has all the proper permissions on the SQL server.

connect to sql server via aps page ado :(

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This the error message that i get when connect the sql server via asp page using ado.

the sql server is a default instance on a fail over cluster.

name pipes is enabled both on server network and at client network

any help.

--sanjayNormally, this occurs when you have not granted access to the iusr account that iis uses. Also, the following article list several other areas:

article (http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306518&)

Let me know if you need further assistance.

Good luck.|||Originally posted by sanjay_kumar_r
Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This the error message that i get when connect the sql server via asp page using ado.

the sql server is a default instance on a fail over cluster.

name pipes is enabled both on server network and at client network

any help.

--sanjay

Guys,

I have this same problem...

Until yesterday averything is fine but since today I receive this error message.

Any help?

What does it means: "Normally, this occurs when you have not granted access to the iusr account that iis uses"?
I have just the "sa" usar in SQL...
What I need to check?|||I found the error.

My firewall blocked the dllhost.exe .
I give the permition and everything is fine again...