July 1, 2005 at 12:16 pm
Hi all,
My Dell 4100 PC was upgraded from Microsoft Windows ME to Microsoft Windows XP Pro 2 years ago. I can not install Microsoft SQL Server 2000 Developer Edition in my "upgraded" Windows XP Pro Operating System now. Do you think I have a problem with the installation of Microsoft SQL Server 2000 Developer Edition in my "upgraded"
Windows XP Pro Operating System? Please help and advise me how to solve this problem.
Thanks in advance,
Scott Chang
July 1, 2005 at 1:12 pm
What error message are you getting? If you have a microsoft error message then try Google with it - you will most likely get a link to a microsoft article.
July 3, 2005 at 12:43 pm
I executed http://localhost/NorthDB/ch13_ex01.asp and I got the following:The page cannot be displayed | |
There is a problem with the page you are trying to reach and it cannot be displayed. | |
Please try the following:
HTTP 500.100 - Internal Server Error - ASP errorInternet Information Services Technical Information (for support personnel)
It is clearly listed in the Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. /NorthDB/ch13_ex01.asp, line 21 |
Please help and tell me how to solve my SQL Server problem.
Thanks in advance,
Scott Chang
July 3, 2005 at 12:49 pm
Scott - sounds like you have a different problem now than what you originally posted...
this site should help you...http://dbforums.com/t441213.html
**ASCII stupid question, get a stupid ANSI !!!**
July 3, 2005 at 4:41 pm
Hi sushila, Thanks for your response.
Issue #1: I read the Vlad - Dinesh - m SQL Server Reistration posting. I could not do my SQL Server Registration that way, because I do not have 'Tool', 'Security' or 'SQL Server and Windows' radio button in my PC. I found "SQL Server - Lesson 1: Introduction" from http://www.functionx.com/sqlserver/Lesson01.htm. I encountered a problem of registrating the Microsoft SQL Server 2000 Developer Edition in following the steps of functionx-Lession01: it would not let me pass the step in the "Registered SQL Server Properties" => Server: local in (i) Use Window authentication or (ii) Use SQL Server authentication - error message is the Server name already exists. Please help and advise me again if you can.
Issue #2: I bought a copy of the Microsoft SQL Server 2000 Developer Edition from a mail-order vender in Ohio. I tested it by doing http://localhost/NorthDB/ch13_ex01.asp and got that above-mentioned error message. I called the mail-order vender and a Technical Help person told me that my "upgraded" Windows XP Pro would not take the the Microsoft SQL Server 2000 Developer Edition prohram and I must have the "full" and "original" Windows XP Pro program in my PC to take the Microsoft SQL Server 2000 Developer Edition program. That is why I posted my question in this Forum for the first time. Now I am not sure what is really wrong with the Microsoft SQL Server 2000 Developer Edition program in my PC. Please help and advise.
Thanks,
Scott Chang
July 3, 2005 at 10:06 pm
Scott try posting your questions on this XP site http://www.microsoft.com/windowsxp/expertzone/newsgroups/reader.mspx?dg=microsoft.public.windowsxp.basics
As to the tech support you recieved from your vendor he should go back to his comic book reading. While I have not way of testing his theory there should be no difference between an upgraded version of XP and a version from a full install. But just had a thought have you checked the MS site for patches and upgrades to XP
HTH
Mike
July 4, 2005 at 2:24 am
This looks like a relatively straight forward asp error message involving integrated authentication between the web server (running the asp page) and the sql server. There are a number of reasons why this might fail including the Directory Security settings within IIS, whether the web server is running on a different machine from the sql server, the connection string within the asp page etc
What is the db connection string being used in the page ?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply