Hi all,
As the subject says I'm having trouble connecting to SQL Server 2K via
Visual Studio.NET 2002 (VB). It tells me that SQL Server does not exist or
access is denied. I know that the server exists because its on the machine
I'm working on. There is no reason for me to be denied access. I am using
a trusted connection and access has been granted to the ASPNET account for
the referenced Database. I have been developing asp apps for years now I am
just moving to the .NET revolution so I do know how to connect to a database
via asp and there is nothing wrong with my connection string. I have to
assume that when I create an asp.net app in vs.net that the web.config file
is some how preventing me from accessing the Database. Is there some
setting that has to initialized in this file or even the machine.config
file? I have included the web.config file source below. Thanks for any
help
Brian
'************** **************
'** WEB.CONFIG SOURCE
'************** **************
<?xml version="1.0" encoding="utf-8" ?>
<configuratio n>
<system.web>
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation
about
debugging ASP.NET files.
-->
<compilation defaultLanguage ="vb" debug="true" />
<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly " to enable custom error messages,
"Off" to disable.
Add <error> tags for each of the errors you want to handle.
-->
<customErrors mode="RemoteOnl y" />
<!-- AUTHENTICATION
This section sets the authentication policies of the application. Possible
modes are "Windows",
"Forms", "Passport" and "None"
-->
<authenticati on mode="Windows" />
<!-- AUTHORIZATION
This section sets the authorization policies of the application. You can
allow or deny access
to application resources by user or role. Wildcards: "*" mean everyone, "?"
means anonymous
(unauthenticate d) users.
-->
<authorizatio n>
<allow users="*" /> <!-- Allow all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page within an
application.
Set trace enabled="true" to enable application trace logging. If
pageOutput="tru e", the
trace information will be displayed at the bottom of each page. Otherwise,
you can view the
application trace log by browsing the "trace.axd" page from your web
application
root.
-->
<trace enabled="false" requestLimit="1 0" pageOutput="fal se"
traceMode="Sort ByTime" localOnly="true " />
<!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong to a
particular session.
If cookies are not available, a session can be tracked by adding a session
identifier to the URL.
To disable cookies, set sessionState cookieless="tru e".
-->
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data source=127.0.0. 1;user id=sa;password= "
cookieless="fal se"
timeout="20"
/>
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
</configuration> 1 2315
On Fri, 11 Jul 2003 11:56:07 -0230, Brian Pittman wrote: Hi all,
As the subject says I'm having trouble connecting to SQL Server 2K via Visual Studio.NET 2002 (VB). It tells me that SQL Server does not exist or access is denied. I know that the server exists because its on the machine I'm working on. There is no reason for me to be denied access. I am using a trusted connection and access has been granted to the ASPNET account for the referenced Database. I have been developing asp apps for years now I am just moving to the .NET revolution so I do know how to connect to a database via asp and there is nothing wrong with my connection string. I have to assume that when I create an asp.net app in vs.net that the web.config file is some how preventing me from accessing the Database. Is there some setting that has to initialized in this file or even the machine.config file? I have included the web.config file source below. Thanks for any help
Brian
'************** ************** '** WEB.CONFIG SOURCE '************** ************** <?xml version="1.0" encoding="utf-8" ?>
<configuratio n>
<system.web>
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation about
debugging ASP.NET files.
-->
<compilation defaultLanguage ="vb" debug="true" />
<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly " to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.
-->
<customErrors mode="RemoteOnl y" />
<!-- AUTHENTICATION
This section sets the authentication policies of the application. Possible modes are "Windows",
"Forms", "Passport" and "None"
-->
<authenticati on mode="Windows" /> <!-- AUTHORIZATION
This section sets the authorization policies of the application. You can allow or deny access
to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous
(unauthenticate d) users.
-->
<authorizatio n>
<allow users="*" /> <!-- Allow all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page within an application.
Set trace enabled="true" to enable application trace logging. If pageOutput="tru e", the
trace information will be displayed at the bottom of each page. Otherwise, you can view the
application trace log by browsing the "trace.axd" page from your web application
root.
-->
<trace enabled="false" requestLimit="1 0" pageOutput="fal se" traceMode="Sort ByTime" localOnly="true " /> <!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong to a particular session.
If cookies are not available, a session can be tracked by adding a session identifier to the URL.
To disable cookies, set sessionState cookieless="tru e".
-->
<sessionState
mode="InProc"
stateConnection String="tcpip=1 27.0.0.1:42424"
sqlConnectionSt ring="data source=127.0.0. 1;user id=sa;password= "
cookieless="fal se"
timeout="20"
/>
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8" />
</system.web>
</configuration>
Try using different names for your machine. Also trying Windows
authentication or sa/password (sql server login)
machinename
localhost
(local)
127.0.0.1
machinename\\vs dotnet
...
Karim This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: StephenRichter |
last post by:
I have installed the trial of db2 enterprise server on my w2k PC. Have
also installed fix pack 8 of that product.
I am using it to connect from an asp.net web page to an IBM as400. the
400 is at v5r1.
>From the db2 command line shell I am able to connect to the as400
database.
The error I am getting is:
|
by: Kristof Thys |
last post by:
Hello,
I'm developing a C# - windows forms application. To get some information
for my application, I'm connecting to an URL, wich gives me XML
generated using php.
With 90% of the users, this code just works fine:
WebRequest request = WebRequest.Create(URL);
|
by: vicky |
last post by:
Hello Experts,
Trying to run sample Postgrel's ECPG(Embedded
SQL)programs on RHL 9.0.
Im unable to connect to PostgreSQL database (sirishadb) when I run
the program ....
# su postgres (enter)
|
by: newladder |
last post by:
Hi all,
Iam struck with one of the problem with postgres. Please help me out....
Iam trying to connect to connect to postgres database on remote machine with the IP address 10.2.1.4. Iam unable to get connected.
below is my script.
<?php
$connection_string = 'DRIVER={PostgreSQL};SERVER=10.2.1.4:5432;DATABASE=Admin';
|
by: cyberking |
last post by:
Hi.
I have just started learning PHP along with MySQL.
I am trying to connect to the MySQL DB server but unable to. I have been tryin. Please help. Its urgent cos I shall soon have to work on PHP .
My testing program is as follows :
<?php
$si = function_exists('mysqli_connect');
| |
by: ynyus75 |
last post by:
Hey!
I am unable to connect some of the services that I host from my laptop at home, such as SMTP and MySQL on port numbers 25 and 3306 respectively.
But I am able to some services such as Telnet, Remote Desk Connection, SSH.
Here are my details
ISP: Time Warner
Connection Type: Cable
Router: Lynksys
Port Farwarding: enabled port farwarding to HTTP, Telnet, HTTPS, Remote Desktop Connection, SSH, MySQL etc to my laptop.
Connection Type...
|
by: Steve |
last post by:
I moved my database from one server to another SQL server. I did a backup and restore of the database. I can connect to the database on server A from my asp.net app but when I try to connect to my database server B, I'm gettting 'login failed for user 'username'
I've added the username to the database on server B, I can open up SMS and connect to the database that way, but I can't connect from my asp.net web app.
any suggestions on what...
|
by: Markw |
last post by:
Hi folks I think I've got a variable problem but not 100% sure.
Background: I took the CMS example from chapter 6 in "Build your Own Database Driven Website Using PHP&MySQL" and have attempted to modify it for use in my own database. It almost works for me LOL.
contact.php returns my dive buddies first and last name and gives me the option to either Edit or Delete them. Currently the delete option is not active.
When I choose to edit...
|
by: Harmony504 |
last post by:
HELP!
Setup: PHP5.2.5, IIS 5.1, XP, AS/400 (DB/400 or DB2)
I am trying to connect to a DB2 database from my computer. I installed DB2 Connect and set up the ODBC Driver in the Data Source Administrator. I uncommented the extension=php_ibm_db2.dll line in my php.ini file.
<?php
$DBName = "WSC520"; // The name of the database
...
|
by: yawnmoth |
last post by:
I'm trying to connect to an Active Directory server and am having some
difficulties. Here's the code I'm using:
<?php
if (!($ldap = ldap_connect('domain.tld'))
{
exit('unable to connect');
}
ldap_bind($ldap, 'username', 'password');
|
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: 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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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: 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...
| |