My server is on Windows XP pro. Its Sql Server 2000.
When I am trying to access it from a client machine through ASP .Net, it is giving me an exception while opening the connection conn.Open();
System.Data.SQL Client.SQLExcep tion.
{"Cannot open database requested in login 'Database Name'. Login fails.\r\nLogin failed for user 'sa'."}
I tried everything. Change the configuration mode of the server to mixed configuration mode, enabled TCP/IP etc.
No idea what could be the problem.
Do server installations need to have a check at some necessary things/configurations? ?
Please help.
3  1695  
My server is on Windows XP pro. Its Sql Server 2000.
When I am trying to access it from a client machine through ASP .Net, it is giving me an exception while opening the connection conn.Open();
System.Data.SQL Client.SQLExcep tion.
{"Cannot open database requested in login 'Database Name'. Login fails.\r\nLogin failed for user 'sa'."}
I tried everything. Change the configuration mode of the server to mixed configuration mode, enabled TCP/IP etc.
No idea what could be the problem.
Do server installations need to have a check at some necessary things/configurations? ?
Please help.
Hi,
shikha...
do as given below.....
Open the Notepad and blank file save with ".udl" extension on desktop... than double click that file than you will get one window for database connection called datalink Properties... in that window select Provider as sql server and than select server and username and password then select database then test the connection if it succeds...
than open again that file in notepad u will get connection string so copy this connection string in web.config file....
definately your problem will be solved.....
Hi,
shikha...
do as given below.....
Open the Notepad and blank file save with ".udl" extension on desktop... than double click that file than you will get one window for database connection called datalink Properties... in that window select Provider as sql server and than select server and username and password then select database then test the connection if it succeds...
than open again that file in notepad u will get connection string so copy this connection string in web.config file....
definately your problem will be solved.....
thanks a ton..but it got solved by installing SP4 for sql server 2000.
thanks a ton..but it got solved by installing SP4 for sql server 2000.
Ok but store your connection string in web.config file...
you will not face problem in the future....
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: David W. Fenton |
last post by:
I'm no stranger to this error message, but I have a client who is
experiencing it, but, fortunately, without any actual data
corruption, and it's driving them made. Their inability to grasp
that the cause is fundamentally a networking problem is also making
me pull my hair out.
Some history:
The network is composed of five computers dating back to 1995, each
purchased one at a time, and each having a different OS, etc. Until
|
by: Ann Marinas |
last post by:
Hi all,
I would like to ask for some help regarding separating the asp.net
webserver and the sql server.
I have created an asp.net application for a certain company. Initially,
we installed both the iis and sql server in a single machine. Not too
long ago, the machine had some hardware problems, and management has
decided to purchase new servers, for both asp.net and sql server.
|
by: deltalimagolf |
last post by:
I now get the following error message after copying an asp.net application to
the deployment web server. I don't have SQLExpress or any version of SQL
2005 installed. I found the "LocalSQLServer" connection string in the
machine.config, changed that to look at a SQL 2000 database, but the error
still comes up.
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be...
|
by: Ann Marinas |
last post by:
Hi there,
I am currently developing an ASP.NET program that connects to a SQL Server
2000 database. I also have SQL Server 2005 Express installed on the same
local machine.
Prior to installing SQL Server 2005, my apps were working and is connecting
flawlessly to a database on the SQL Server 2000. Now, whenever I connect to
the same database with the 2005 version installed, I keep on getting this
error:
|
by: John Shadel |
last post by:
I have the following setup:
1. ASP.NET 2.0 web app hosted on a web server (inetpub directory
hosting physical files of the web site on a different drive name, E:
than the SQL Server Instance, which is on C:)
2. SQL Server on the same server, with security settings enabling
ASPNET group and groups containing users allowed to interact with the
website added to SQL Server Instance security settings.
3. Impersonation = true, i.e. ASPNET...
| | |
by: James |
last post by:
Hello,
I have written a simple logon page that redirects to another page when
successful. All works fine on my computer but when I upload it I get the
error message below.
I have written it in ASP.net v2, and have put it on IIS v6 on windows server
2003.
I think it may be something to do with connection string to the database,
|
by: NEWS |
last post by:
My application is giving error .pls help .
error :
Server Error in '/webpdms' Application.
--------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40...
|
by: mairhtin o'feannag |
last post by:
Hello,
I'm having problems connecting to my new v9 db box. The pertinent
information is below:
DB2_db2inst1 60000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_END 60003/tcp
|
by: aboutjav.com |
last post by:
Hi,
I need some help. I am getting this error after I complete the asp.net
register control and click on the continue button. It crashed when it
tries to get
it calls this Profile property
((string)(this.GetPropertyValue("Address1")));
|
by: Cirene |
last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm
using, webhost4life.
NOTE: I HAVE deployed other SQL Server sites to the same account with no
issues.
Now I'm getting this error. Any idea why?
Server Error in '/myuser4/MyWebApp' Application.
--------------------------------------------------------------------------------
|
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: 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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 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: 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...
| |
