I'm trying to connect to a SQL 2000 db that is on another server then the
web server.
I setup and ID and PWD to access the SQL db via the code and it works
locally and when I put the
everything on the web server I get an Access denied to SQL Database.
what is causing this, what do i need to change 7 1213
1. Make sure you have mixed mode security (rerun install if not) - sounds
like you have this
2. Check what libraries you have available. In most instances, you want
TCP/IP to avoid having to contact SQL via named pipes (and its install on
the web server). You can install this library on the server through the
install routine. By default, I believe it is not installed.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"Mike" <an*******@disc ussions.microso ft.com> wrote in message
news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. I'm trying to connect to a SQL 2000 db that is on another server then the web server. I setup and ID and PWD to access the SQL db via the code and it works locally and when I put the everything on the web server I get an Access denied to SQL Database.
what is causing this, what do i need to change
we did what you recommend below and still getting the login failed error
message.
here is my connection string, how can i make this point to a DSN instead of
the actual server name right now.
I need to get this app up and running quickly and been going through this
permission issue for 2 days
dim ds as DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New
SqlConnection(" server=SQLServe r;database=MRL_ SSC;UID=ID;PWD= password")
MyCommand = New SqlDataAdapter( "select * from Form", MyConnection)
DS = New DataSet()
MyCommand.Fill( DS, "Form")
MyDataGrid.Data Source = DS.Tables("Form ").DefaultV iew
MyDataGrid.Data Bind()
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote
in message news:es******** *****@TK2MSFTNG P10.phx.gbl... 1. Make sure you have mixed mode security (rerun install if not) - sounds like you have this 2. Check what libraries you have available. In most instances, you want TCP/IP to avoid having to contact SQL via named pipes (and its install on the web server). You can install this library on the server through the install routine. By default, I believe it is not installed.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "Mike" <an*******@disc ussions.microso ft.com> wrote in message news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. I'm trying to connect to a SQL 2000 db that is on another server then
the web server. I setup and ID and PWD to access the SQL db via the code and it works locally and when I put the everything on the web server I get an Access denied to SQL Database.
what is causing this, what do i need to change
Try this, just to be safe:
Change from server=SQLServe r
to server={IP Address of Server}
Since you are using SqlConnection, the rest of the string looks fine. If
that does not work, post the actual wording of the error message, as it may
give some additional clues.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"Mike" <an*******@disc ussions.microso ft.com> wrote in message
news:uj******** ********@TK2MSF TNGP11.phx.gbl. .. we did what you recommend below and still getting the login failed error message. here is my connection string, how can i make this point to a DSN instead
of the actual server name right now. I need to get this app up and running quickly and been going through this permission issue for 2 days
dim ds as DataSet Dim MyConnection As SqlConnection Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection(" server=SQLServe r;database=MRL_ SSC;UID=ID;PWD= password")
MyCommand = New SqlDataAdapter( "select * from Form", MyConnection)
DS = New DataSet() MyCommand.Fill( DS, "Form")
MyDataGrid.Data Source = DS.Tables("Form ").DefaultV iew MyDataGrid.Data Bind()
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM>
wrote in message news:es******** *****@TK2MSFTNG P10.phx.gbl... 1. Make sure you have mixed mode security (rerun install if not) -
sounds like you have this 2. Check what libraries you have available. In most instances, you want TCP/IP to avoid having to contact SQL via named pipes (and its install
on the web server). You can install this library on the server through the install routine. By default, I believe it is not installed.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "Mike" <an*******@disc ussions.microso ft.com> wrote in message news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. I'm trying to connect to a SQL 2000 db that is on another server then the web server. I setup and ID and PWD to access the SQL db via the code and it works locally and when I put the everything on the web server I get an Access denied to SQL Database.
what is causing this, what do i need to change
ok I'll give that a shot.
does having the IP make of difference then the actual name of the server? If
so why?
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote
in message news:uA******** ******@tk2msftn gp13.phx.gbl... Try this, just to be safe:
Change from server=SQLServe r to server={IP Address of Server}
Since you are using SqlConnection, the rest of the string looks fine. If that does not work, post the actual wording of the error message, as it
may give some additional clues.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "Mike" <an*******@disc ussions.microso ft.com> wrote in message news:uj******** ********@TK2MSF TNGP11.phx.gbl. .. we did what you recommend below and still getting the login failed error message. here is my connection string, how can i make this point to a DSN instead of the actual server name right now. I need to get this app up and running quickly and been going through
this permission issue for 2 days
dim ds as DataSet Dim MyConnection As SqlConnection Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection(" server=SQLServe r;database=MRL_ SSC;UID=ID;PWD= password")
MyCommand = New SqlDataAdapter( "select * from Form",
MyConnection) DS = New DataSet() MyCommand.Fill( DS, "Form")
MyDataGrid.Data Source = DS.Tables("Form ").DefaultV iew MyDataGrid.Data Bind()
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote in message news:es******** *****@TK2MSFTNG P10.phx.gbl... 1. Make sure you have mixed mode security (rerun install if not) - sounds like you have this 2. Check what libraries you have available. In most instances, you
want TCP/IP to avoid having to contact SQL via named pipes (and its install on the web server). You can install this library on the server through
the install routine. By default, I believe it is not installed.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "Mike" <an*******@disc ussions.microso ft.com> wrote in message news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. > I'm trying to connect to a SQL 2000 db that is on another server
then the > web server. > I setup and ID and PWD to access the SQL db via the code and it
works > locally and when I put the > everything on the web server I get an Access denied to SQL Database. > > what is causing this, what do i need to change > >
> does having the IP make of difference then the actual name of the server?
If so why?
Depends on the network relationship of the 2 machines. IP address always
works.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Mike" <an*******@disc ussions.microso ft.com> wrote in message
news:On******** ******@TK2MSFTN GP11.phx.gbl... ok I'll give that a shot.
does having the IP make of difference then the actual name of the server?
If so why?
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM>
wrote in message news:uA******** ******@tk2msftn gp13.phx.gbl... Try this, just to be safe:
Change from server=SQLServe r to server={IP Address of Server}
Since you are using SqlConnection, the rest of the string looks fine. If that does not work, post the actual wording of the error message, as it may give some additional clues.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "Mike" <an*******@disc ussions.microso ft.com> wrote in message news:uj******** ********@TK2MSF TNGP11.phx.gbl. .. we did what you recommend below and still getting the login failed
error message. here is my connection string, how can i make this point to a DSN
instead of the actual server name right now. I need to get this app up and running quickly and been going through this permission issue for 2 days
dim ds as DataSet Dim MyConnection As SqlConnection Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection(" server=SQLServe r;database=MRL_ SSC;UID=ID;PWD= password")
MyCommand = New SqlDataAdapter( "select * from Form", MyConnection) DS = New DataSet() MyCommand.Fill( DS, "Form")
MyDataGrid.Data Source = DS.Tables("Form ").DefaultV iew MyDataGrid.Data Bind()
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote in message news:es******** *****@TK2MSFTNG P10.phx.gbl... > 1. Make sure you have mixed mode security (rerun install if not) - sounds > like you have this > 2. Check what libraries you have available. In most instances, you want > TCP/IP to avoid having to contact SQL via named pipes (and its
install on > the web server). You can install this library on the server through the > install routine. By default, I believe it is not installed. > > -- > Gregory A. Beamer > MVP; MCP: +I, SE, SD, DBA > > *************** *************** *************** *** > Think Outside the Box! > *************** *************** *************** *** > "Mike" <an*******@disc ussions.microso ft.com> wrote in message > news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. > > I'm trying to connect to a SQL 2000 db that is on another server then the > > web server. > > I setup and ID and PWD to access the SQL db via the code and it works > > locally and when I put the > > everything on the web server I get an Access denied to SQL
Database. > > > > what is causing this, what do i need to change > > > > > >
OK i have the IP address in the connection string, the ID and PWD setup on
the db server, and i'm still getting access denied.
Any suggestions, I'm totally stumped now
"Kevin Spencer" <ks******@takem pis.com> wrote in message
news:uE******** ******@TK2MSFTN GP12.phx.gbl... does having the IP make of difference then the actual name of the
server? If so why? Depends on the network relationship of the 2 machines. IP address always works.
-- HTH, Kevin Spencer .Net Developer Microsoft MVP Big things are made up of lots of little things.
"Mike" <an*******@disc ussions.microso ft.com> wrote in message news:On******** ******@TK2MSFTN GP11.phx.gbl... ok I'll give that a shot.
does having the IP make of difference then the actual name of the
server? If so why?
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote in message news:uA******** ******@tk2msftn gp13.phx.gbl... Try this, just to be safe:
Change from server=SQLServe r to server={IP Address of Server}
Since you are using SqlConnection, the rest of the string looks fine.
If that does not work, post the actual wording of the error message, as
it may give some additional clues.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "Mike" <an*******@disc ussions.microso ft.com> wrote in message news:uj******** ********@TK2MSF TNGP11.phx.gbl. .. > we did what you recommend below and still getting the login failed error > message. > here is my connection string, how can i make this point to a DSN instead of > the actual server name right now. > I need to get this app up and running quickly and been going through this > permission issue for 2 days > > dim ds as DataSet > Dim MyConnection As SqlConnection > Dim MyCommand As SqlDataAdapter > > > MyConnection = New >
SqlConnection(" server=SQLServe r;database=MRL_ SSC;UID=ID;PWD= password") > > > MyCommand = New SqlDataAdapter( "select * from Form", MyConnection) > > DS = New DataSet() > MyCommand.Fill( DS, "Form") > > MyDataGrid.Data Source = DS.Tables("Form ").DefaultV iew > MyDataGrid.Data Bind() > > > > > > > > "Cowboy (Gregory A. Beamer) [MVP]"
<No************ @comcast.netNoS pamM> wrote > in message news:es******** *****@TK2MSFTNG P10.phx.gbl... > > 1. Make sure you have mixed mode security (rerun install if not) - sounds > > like you have this > > 2. Check what libraries you have available. In most instances, you want > > TCP/IP to avoid having to contact SQL via named pipes (and its install on > > the web server). You can install this library on the server
through the > > install routine. By default, I believe it is not installed. > > > > -- > > Gregory A. Beamer > > MVP; MCP: +I, SE, SD, DBA > > > > *************** *************** *************** *** > > Think Outside the Box! > > *************** *************** *************** *** > > "Mike" <an*******@disc ussions.microso ft.com> wrote in message > > news:%2******** ********@TK2MSF TNGP12.phx.gbl. .. > > > I'm trying to connect to a SQL 2000 db that is on another server then > the > > > web server. > > > I setup and ID and PWD to access the SQL db via the code and it works > > > locally and when I put the > > > everything on the web server I get an Access denied to SQL Database. > > > > > > what is causing this, what do i need to change > > > > > > > > > > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Harry |
last post by:
Using Oracle 8i enterprise on win 2000 (sp3)
Installed the standard configuration & whenever I make a connection it
takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason
there for slowness.
Once I'm connected the queries work pretty much instantanously but to
connect using SQLPLUS, Toad, ODBC, OLEDB all take about 10...
|
by: Mark |
last post by:
OK. Here we go. I have an ASP.NET application that does many hits to a SQL Server DB on a separate server. When I first created this application (2 years ago) and was very new to ASP/ASP.NET, to make the SQL connection string global throughout the application I created a .vb file within the application project and declared a public...
|
by: Rajeev Tipnis |
last post by:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;819450
Questions:
1) Is this patch (fix) applicable to the .NET 1.1
Framework as well? That is, if we have Framework 1.1 (On
Win2K3/IIS6.0), do we still need this patch?
2) Does it specifically solve only this error:
The underlying connection was closed. An unexpected error
|
by: Lenny Shprekher |
last post by:
Hi,
I am getting issues that Oracle collecting opened sessions (connections)
from my webservice using regular System.Data.OleDb.OleDbConnection object.
I am guessing that this is connection pooling issue. Is there is any way to
disable connection pooling for one particular .net webservice?
Thanks,
Leonid
|
by: galico |
last post by:
Hi All,
We are having a very strange problem with the above. We have designed an
application in ASP.NET 2.0 that uses the enterprise library data application
blocks amongst others. We seem to be maxing out the number of connections
allowed to the sql server 7 server after running a few large queries through
the application? There are less...
| |
by: sam44 |
last post by:
Hi,
At startup the user log on and chooses the name of a client from a
dropdownlist, which then changes dynamically the connection string (the
name of the client indicates which database to use).
I then change dynamically the connection string by doing :
My.Settings.Item("ConnectionString") = "some connection sring"
The problem is that if...
|
by: =?Utf-8?B?RFNJU3VwcG9ydA==?= |
last post by:
Hi,
I have this ASP.NET application developed with VS.NET 2003 VB.NET and
deplyed on Windows 2K server IIS 5.
This application uses the following:
- Oracle 10G databse
- MS Data Access Block from MS Enterprise Library June 2005 (with the other
blocks like exception, security...)
- Use Crystal Report Components for printing reports online...
|
by: Fred Zuckerman |
last post by:
I have a A2K database that includes some linked tables (these links are SQL
views).
Sometimes there are "issues" with the SQL server and the users receive a
timeout error whenever they try to access those records. The timeout error
occurs after 60 seconds. Many times the user has given up and used
ctrl-alt-del to end task thinking their...
|
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 many connection has been used ?
2. If the maximum pool size has been reached, what happens when I call the
method Open to open the connection ? Will I...
|
by: hal9000cr |
last post by:
We are running into some problems with the execution of DB2 stored
procedures when their isolation level is set to:
set transaction isolation level READ UNCOMMITTED, READ WRITE;
This is a web application running in JBoss 4.0.1 where a standard
DataSource in JBoss is defined for connections against a DB2 database
on an AS/400 (VRM =...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| |
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. ...
|
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...
|
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...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |