Hell-hohoho to all...
Just begun working with asp.net linking to sqlServer 2000, had some
problems with the (null) user, but previous posts have got me past
that by storing an identity in the web.config file. However, I want
to dyamically set the login info, from a prompted box. I'm aware of
the security issues here, but I'll ignore that for now. The kb
article I saw set the following info in the connection string of the
sql connection:
data source=[SERVER MACHINE];initial catalog=[DB NAME];user id=
[DOMAIN\USER];password=[PASSWORD]
While the same user info worked when hard-coded into the config file,
here it sqys that
Login failed for user 'pcc.login\fray a'
at the point of connection.open ().
Am I missing something from the connection string? That's exactly
what the knowledgebase article said.
Any help? Cheers, and holiday greetings.
Andrew Fray 6 1246
It may not necessarily be in the connection string. Did you grant a
login and permissions for the fraya account? Also, I don't think
pcc.login\fraya is valid syntax what with the dot between pcc and
login.
-- Mary
MCW Technologies http://www.mcwtech.com
On 22 Dec 2003 03:11:19 -0800, an*********@hot mail.com (Andrew) wrote: Hell-hohoho to all... Just begun working with asp.net linking to sqlServer 2000, had some problems with the (null) user, but previous posts have got me past that by storing an identity in the web.config file. However, I want to dyamically set the login info, from a prompted box. I'm aware of the security issues here, but I'll ignore that for now. The kb article I saw set the following info in the connection string of the sql connection:
data source=[SERVER MACHINE];initial catalog=[DB NAME];user id= [DOMAIN\USER];password=[PASSWORD]
While the same user info worked when hard-coded into the config file, here it sqys that
Login failed for user 'pcc.login\fray a'
at the point of connection.open ().
Am I missing something from the connection string? That's exactly what the knowledgebase article said.
Any help? Cheers, and holiday greetings. Andrew Fray
Like I say, I had it working with identitiy impersonation, so I needed
the identity set up on the sql server. And pcc.login is valid,
honest!
cheers,
Andrew Fray
Mary Chipman <mc***@nomail.p lease> wrote in message news:<0e******* *************** **********@4ax. com>... It may not necessarily be in the connection string. Did you grant a login and permissions for the fraya account? Also, I don't think pcc.login\fraya is valid syntax what with the dot between pcc and login.
-- Mary MCW Technologies http://www.mcwtech.com
On 22 Dec 2003 03:11:19 -0800, an*********@hot mail.com (Andrew) wrote:
Hell-hohoho to all... Just begun working with asp.net linking to sqlServer 2000, had some problems with the (null) user, but previous posts have got me past that by storing an identity in the web.config file. However, I want to dyamically set the login info, from a prompted box. I'm aware of the security issues here, but I'll ignore that for now. The kb article I saw set the following info in the connection string of the sql connection:
data source=[SERVER MACHINE];initial catalog=[DB NAME];user id= [DOMAIN\USER];password=[PASSWORD]
While the same user info worked when hard-coded into the config file, here it sqys that
Login failed for user 'pcc.login\fray a'
at the point of connection.open ().
Am I missing something from the connection string? That's exactly what the knowledgebase article said.
Any help? Cheers, and holiday greetings. Andrew Fray
Can you log in using that connection info from the same machine using
another tool, like Query Analyzer?
-- Mary
MCW Technologies http://www.mcwtech.com
On 23 Dec 2003 01:11:22 -0800, an*********@hot mail.com (Andrew) wrote: Like I say, I had it working with identitiy impersonation, so I needed the identity set up on the sql server. And pcc.login is valid, honest! cheers, Andrew Fray
Mary Chipman <mc***@nomail.p lease> wrote in message news:<0e******* *************** **********@4ax. com>... It may not necessarily be in the connection string. Did you grant a login and permissions for the fraya account? Also, I don't think pcc.login\fraya is valid syntax what with the dot between pcc and login.
-- Mary MCW Technologies http://www.mcwtech.com
On 22 Dec 2003 03:11:19 -0800, an*********@hot mail.com (Andrew) wrote:
>Hell-hohoho to all... >Just begun working with asp.net linking to sqlServer 2000, had some >problems with the (null) user, but previous posts have got me past >that by storing an identity in the web.config file. However, I want >to dyamically set the login info, from a prompted box. I'm aware of >the security issues here, but I'll ignore that for now. The kb >article I saw set the following info in the connection string of the >sql connection: > >data source=[SERVER MACHINE];initial catalog=[DB NAME];user id= >[DOMAIN\USER];password=[PASSWORD] > >While the same user info worked when hard-coded into the config file, >here it sqys that > >Login failed for user 'pcc.login\fray a' > >at the point of connection.open (). > >Am I missing something from the connection string? That's exactly >what the knowledgebase article said. > >Any help? Cheers, and holiday greetings. >Andrew Fray
Absolutley, Enterprise Manager logs in, and I have full access.
I'm really stumped when it comes to this.
Cheers,
Andrew Fray
I can't think of anything else to try myself -- maybe open a support
incident or start a new thread?
-- Mary
MCW Technologies http://www.mcwtech.com
On 24 Dec 2003 01:13:24 -0800, an*********@hot mail.com (Andrew) wrote: Absolutley, Enterprise Manager logs in, and I have full access. I'm really stumped when it comes to this. Cheers, Andrew Fray
The reason I suggest starting a new thread is that often other people
don't jump in or even read a long existing thread since they figure
your question has been answered adequately, which in this case it has
not.
-- Mary
MCW Technologies http://www.mcwtech.com
On Wed, 24 Dec 2003 16:02:58 -0500, Mary Chipman <mc***@nomail.p lease>
wrote: I can't think of anything else to try myself -- maybe open a support incident or start a new thread?
-- Mary MCW Technologies http://www.mcwtech.com
On 24 Dec 2003 01:13:24 -0800, an*********@hot mail.com (Andrew) wrote:
Absolutley, Enterprise Manager logs in, and I have full access. I'm really stumped when it comes to this. Cheers, Andrew Fray This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: cooldv |
last post by:
i am running a website on Windows 2000 server with ASP 3 webpages and
Access 2000 database. (with a hosting company)
traffic is slow at this time but expect to grow. lately i have been
reading about sql database and sql server, specially this article:
http://www.aspfaq.com/show.asp?id=2195
will someone help me understand:
1. with *SQL Server*, do i keep my current Access 2000 database and
ASP pages?
|
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: Martin Meyer im Hagen |
last post by:
Hello,
I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a server
machine. It works almost fine, except the application which uses the SQL
Server. The main part of the application runs (since the last update) fine,
but other tools of that application (database import and the database
manager for check and rebuild) doesn't. They hang up or kill the database.
Our software developer says that these problems are in...
|
by: JA |
last post by:
Hi,
I am total newbie to SQL Server. My new host tells me I can connect through
AccessXP or 2002. I have Access 2000. Can I not connect with that also?
Thanks, JA
|
by: Bon |
last post by:
Hello all
Would it be possible to migrate the MS Access 2000 to MS SQL Server
2000?
My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS Access 2000 interface. Would it be possible?
| |
by: B Moor |
last post by:
Host PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM
SQL Server 2000 sp3 (or latest).MS Office 2k3
I have the access 2k3 front end running on server (this may get
changed) and all was well until an upgrade 1 week ago when I installed
a new version of the mde (with very minor changes) and a new VB
application via a VB6 installer setup.exe.
Access uses odbc to linked tables on SQL Server, plus a few local
tables.
|
by: Microsoft |
last post by:
Hi,
I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The...
|
by: Neil |
last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL
Server to SQL 2005, and are considering upgrading to Access 2003. Someone
mentioned that they had heard about some incompatibilities between Access
2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying
with Access 2000 be better?
Thanks!
Neil
|
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
attending interviews. If you own a company best way to judge if the
candidate is worth of it.
http://www.questpond.com/InterviewRatingSheet.zip
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |