I'm posting here hopeing some here has delt with a similar problem and
has a suggestion for a fix.
If anyone knows the answer to this I’d me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B) I am
trying to make a connection to SQL on computer A but get the
error “SQL Server does not exist or access denied”
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, I’m guessing the problems lies in the security of ASP.NET, but I’m
not sure what to change to make this work.
BTW, I can also connect just fine with the same user/pw with Enterprise
Manger, and Query Analyzer as well as add the connection to Visual
Studio
Anyone with any ideas?
TIA
B
6  4302 
Hi,
post your connection string
cheerrs,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Brian W" <no****@yourbusiness.com> wrote in message
news:Og*************@TK2MSFTNGP15.phx.gbl... I'm posting here hopeing some here has delt with a similar problem and
has a suggestion for a fix.
If anyone knows the answer to this I'd me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B) I am
trying to make a connection to SQL on computer A but get the
error "SQL Server does not exist or access denied"
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, I'm guessing the problems lies in the security of ASP.NET, but I'm
not sure what to change to make this work.
BTW, I can also connect just fine with the same user/pw with Enterprise
Manger, and Query Analyzer as well as add the connection to Visual
Studio
Anyone with any ideas?
TIA
B
Database=TESTDATABASE;Server=MYDBSERVER;user
id=VALIDUSERNAME;password=VALIDPASSWORD
As I said, this same connected string allows me to connect with a Winforms
test application.
Thanks
B
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:u7*************@TK2MSFTNGP14.phx.gbl... Hi,
post your connection string
cheerrs,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Brian W" <no****@yourbusiness.com> wrote in message
news:Og*************@TK2MSFTNGP15.phx.gbl... I'm posting here hopeing some here has delt with a similar problem and
has a suggestion for a fix.
If anyone knows the answer to this I'd me greatly appreciative.
I am not on a domain.
I have SQL Server sitting on computer A
Computer A has:
Windows XP SP2
SQL Server 2000 SP3a
SQL Server is set to use Trusted or SQL authorization
I have added a user X to SQL Server with a password of X
I am writing an ASP.NET app on Computer B. IIS and Dev on B) I am
trying to make a connection to SQL on computer A but get the
error "SQL Server does not exist or access denied"
Now when I create a small Winforms app as a test, I can use the exact
same connection string and open a connection to SQL Server just fine.
So, I'm guessing the problems lies in the security of ASP.NET, but I'm
not sure what to change to make this work.
BTW, I can also connect just fine with the same user/pw with Enterprise
Manger, and Query Analyzer as well as add the connection to Visual
Studio
Anyone with any ideas?
TIA
B
Brian,
An ASPNET application is using the user AspNetUser or something (see it in
your userlist, it is a standard user). That one has to be autorised to use
your database server in a proper way.
Cor
Sure,
User ID=VALIDDBUSER;password=VALIDDBUSERPWD;Initial
Catalog=MYDATABASE;Data Source=MYSERVER;
Ignacio Machin ( .NET/ C# MVP ) wrote: Hi,
post your connection string
cheerrs,
Cor,
I know that to be [usually] true, however, I am not using a trusted
connection to the DB. I added a user/pwd and am passing that in the
connection string.
B
Cor Ligthert wrote: Brian,
An ASPNET application is using the user AspNetUser or something (see
it in your userlist, it is a standard user). That one has to be
autorised to use your database server in a proper way.
Cor
Anyone?
Brian W wrote: Sure,
User ID=VALIDDBUSER;password=VALIDDBUSERPWD;Initial
Catalog=MYDATABASE;Data Source=MYSERVER;
Ignacio Machin ( .NET/ C# MVP ) wrote:
Hi,
post your connection string
cheerrs, This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: G-Fit |
last post by:
Hello group,
I have several servers hosting SQL databases. On each of them, I have
several databases. All those databases have the same structure (even those
on different servers), only the data...
|
by: pradeep_TP |
last post by:
Hi all,
I have a few questions that I have been wanting to ask for long. These are
all related to ADO.net and specifically to conenction to database.
1) If I have opened a connection to a...
|
by: Chris Szabo |
last post by:
I've created a data access layer for a .NET web
application. I'm using C# and framework 1.1. I'm getting
an error from time to time when I close a connection
saying: ...
|
by: Rob Nicholson |
last post by:
We're getting an occasional occurrence of the following error when two users
try and open the same record in our ASP.NET app:
"There is already an open DataReader associated with this Connection...
|
by: Eric Sabine |
last post by:
In my Finally block, I was using cn.close (where cn is an ADO.NET
connection object, SQLConnection to be exact) and then I came across the
following in some microsoft code.
If Not cn Is Nothing...
|
by: Martin B |
last post by:
Hallo!
I'm working with C# .NET 2.0, implementing Client/Server Applications which
are connecting via Network to SQL-Server or Oracle Databases.
To stay independent from the underlaying Database...
|
by: fniles |
last post by:
I am using VS2003 and connecting to MS Access database.
When using a connection pooling (every time I open the OLEDBCONNECTION I use
the exact matching connection string),
1. how can I know how...
|
by: fniles |
last post by:
In the Windows application (using VB.NET 2005) I use connection pooling like
the following:
In the main form load I open a connection using a connection string that I
stored in a global variable...
|
by: Robert Avery |
last post by:
In VBA/VB6, I had a class (incomplete sample below) that watched and
displayed for the user all connection events, so that I could easily
see what SQL was taking a long time, and when it freezes, I...
|
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: 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: 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...
|
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...
|
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...
| |
