Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Connecting to SQL Server 2000

Reply
Thread Tools

Connecting to SQL Server 2000

 
 
=?Utf-8?B?QW5keQ==?=
Guest
Posts: n/a
 
      04-16-2004
I am trying to connect to SQL Server 2000 from asp.net and I keep getting an error "Login failed". Everything is working fine in test server but the production server is having a problem Test SQL is 7.5 abd production SQL is 2000
 
Reply With Quote
 
 
 
 
AT
Guest
Posts: n/a
 
      04-17-2004
Check if IIS server has SQL Server Client software installed.

Or try installing it and check if you can connect from IIS server to SQL
2000 using Query Analyzer.

If this works then check if connection string used in ASP is good. Meaning
it contains password etc.

--
_________________________
Anatoli Trifonov
Software Developer & Consultant
Minds are like parachutes - they only function when open.
--Thomas Dewar

"Andy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am trying to connect to SQL Server 2000 from asp.net and I keep getting

an error "Login failed". Everything is working fine in test server but the
production server is having a problem Test SQL is 7.5 abd production SQL is
2000


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
Connecting to SQL 2000 database with SQL 2005 tools installed =?Utf-8?B?TmVpbCBQYWRkb2Nr?= ASP .Net 1 05-02-2007 03:18 PM
Do the Self-Paced Training Kits: Microsoft SQL Server 2000 include Eval copy of SQL Server? Brian Whiting Microsoft Certification 2 12-29-2005 04:24 AM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM
Microsoft Exchange 2000 Server OR Microsoft SQL Server 2000 Sam MCSE 11 06-03-2005 08:29 PM



Advertisments