Windows 2003 + SQL 2000 problem

Hello

Im having problems with a simple connectionstring that's driving me crazy on
a windows 2003 machine.

earlier I had 2 seperate machines, running win 2000 and sql 2000, works
perfectly, then I was given the task to move the site to a windows 2003 that
shall run against same sql 2000. Now it cant connect to sql-server, with
same login as before.

I created a .udl file on win 2k3 machine just for testing and it
works........ "Connection Successful"..... but when I use that connection
string with the asp-code I get: "SQL Server does not exists or access
denied".

I ran tracer on sql-machine and nothing shows there. All servers are on same
domain, and it makes no sense why it doesnt work when the test with the udl
file said the connection with user, pass and selected db works. All servers
are in same domain and everything.

Just did a response.write("test") which works...... but this is really
getting on my nerves now. grrr

Any ideas of what might be wrong here? must be something with the win 2k3
machine....

TIA
/Lasse

Re: Windows 2003 + SQL 2000 problem

Lasse Edsvik wrote:
> Hello
>
> Im having problems with a simple connectionstring that's driving me
> crazy on a windows 2003 machine.
>
> earlier I had 2 seperate machines, running win 2000 and sql 2000,
> works perfectly, then I was given the task to move the site to a
> windows 2003 that shall run against same sql 2000. Now it cant
> connect to sql-server, with same login as before.
>
> I created a .udl file on win 2k3 machine just for testing and it
> works........ "Connection Successful"..... but when I use that
> connection string with the asp-code I get: "SQL Server does not
> exists or access denied".
>
> I ran tracer on sql-machine and nothing shows there. All servers are
> on same domain, and it makes no sense why it doesnt work when the
> test with the udl file said the connection with user, pass and
> selected db works. All servers are in same domain and everything.
>
> Just did a response.write("test") which works...... but this is really
> getting on my nerves now. grrr
>
> Any ideas of what might be wrong here? must be something with the win
> 2k3 machine....
>

Have you eliminated all the possibilities outlined here:
http://www.aspfaq.com/show.asp?id=2009

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Windows 2003 + SQL 2000 problem

Bob,

pretty much, same code works on the win 2k machine so there must be
something wrong with the win 2k3 machine.

been connecting to databases for years and years and years and now this
simple crap doesnt work :(

could it be something with AD-rights or something like that?

I just dont get why it can connect when i test the connection from the .udl
file when i put in the settings there, and not from the code...... makes no
sense, both are on same machine.





"Bob Barrows [MVP]" wrote in message
news:%23pUULCbQFHA.2876@TK2MSFTNGP09.phx.gbl...
> Lasse Edsvik wrote:
> > Hello
> >
> > Im having problems with a simple connectionstring that's driving me
> > crazy on a windows 2003 machine.
> >
> > earlier I had 2 seperate machines, running win 2000 and sql 2000,
> > works perfectly, then I was given the task to move the site to a
> > windows 2003 that shall run against same sql 2000. Now it cant
> > connect to sql-server, with same login as before.
> >
> > I created a .udl file on win 2k3 machine just for testing and it
> > works........ "Connection Successful"..... but when I use that
> > connection string with the asp-code I get: "SQL Server does not
> > exists or access denied".
> >
> > I ran tracer on sql-machine and nothing shows there. All servers are
> > on same domain, and it makes no sense why it doesnt work when the
> > test with the udl file said the connection with user, pass and
> > selected db works. All servers are in same domain and everything.
> >
> > Just did a response.write("test") which works...... but this is really
> > getting on my nerves now. grrr
> >
> > Any ideas of what might be wrong here? must be something with the win
> > 2k3 machine....
> >
>
> Have you eliminated all the possibilities outlined here:
> http://www.aspfaq.com/show.asp?id=2009
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Re: Windows 2003 + SQL 2000 problem

Same machine: different users...

You are the user testing the udl. The IUSR account is the one trying to
connect. Go back and reread the faq. I'm pretty sure there's a KB article
cited in there that has your solution

Lasse Edsvik wrote:
> Bob,
>
> pretty much, same code works on the win 2k machine so there must be
> something wrong with the win 2k3 machine.
>
> been connecting to databases for years and years and years and now
> this simple crap doesnt work :(
>
> could it be something with AD-rights or something like that?
>
> I just dont get why it can connect when i test the connection from
> the .udl file when i put in the settings there, and not from the
> code...... makes no sense, both are on same machine.
>
>
>
>
>
> "Bob Barrows [MVP]" wrote in message
> news:%23pUULCbQFHA.2876@TK2MSFTNGP09.phx.gbl...
>> Lasse Edsvik wrote:
>>> Hello
>>>
>>> Im having problems with a simple connectionstring that's driving me
>>> crazy on a windows 2003 machine.
>>>
>>> earlier I had 2 seperate machines, running win 2000 and sql 2000,
>>> works perfectly, then I was given the task to move the site to a
>>> windows 2003 that shall run against same sql 2000. Now it cant
>>> connect to sql-server, with same login as before.
>>>
>>> I created a .udl file on win 2k3 machine just for testing and it
>>> works........ "Connection Successful"..... but when I use that
>>> connection string with the asp-code I get: "SQL Server does not
>>> exists or access denied".
>>>
>>> I ran tracer on sql-machine and nothing shows there. All servers are
>>> on same domain, and it makes no sense why it doesnt work when the
>>> test with the udl file said the connection with user, pass and
>>> selected db works. All servers are in same domain and everything.
>>>
>>> Just did a response.write("test") which works...... but this is
>>> really getting on my nerves now. grrr
>>>
>>> Any ideas of what might be wrong here? must be something with the
>>> win 2k3 machine....
>>>
>>
>> Have you eliminated all the possibilities outlined here:
>> http://www.aspfaq.com/show.asp?id=2009
>>
>> --
>> Microsoft MVP - ASP/ASP.NET
>> Please reply to the newsgroup. This email account is my spam trap so
>> I don't check it very often. If you must reply off-line, then remove
>> the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Windows 2003 + SQL 2000 problem

Bob,

well, im using an sqlserver-user so it cant be an NTFS-user problem?


"Bob Barrows [MVP]" wrote in message
news:una$yZbQFHA.3336@TK2MSFTNGP10.phx.gbl...
> Same machine: different users...
>
> You are the user testing the udl. The IUSR account is the one trying to
> connect. Go back and reread the faq. I'm pretty sure there's a KB article
> cited in there that has your solution
>
> Lasse Edsvik wrote:
> > Bob,
> >
> > pretty much, same code works on the win 2k machine so there must be
> > something wrong with the win 2k3 machine.
> >
> > been connecting to databases for years and years and years and now
> > this simple crap doesnt work :(
> >
> > could it be something with AD-rights or something like that?
> >
> > I just dont get why it can connect when i test the connection from
> > the .udl file when i put in the settings there, and not from the
> > code...... makes no sense, both are on same machine.
> >
> >
> >
> >
> >
> > "Bob Barrows [MVP]" wrote in message
> > news:%23pUULCbQFHA.2876@TK2MSFTNGP09.phx.gbl...
> >> Lasse Edsvik wrote:
> >>> Hello
> >>>
> >>> Im having problems with a simple connectionstring that's driving me
> >>> crazy on a windows 2003 machine.
> >>>
> >>> earlier I had 2 seperate machines, running win 2000 and sql 2000,
> >>> works perfectly, then I was given the task to move the site to a
> >>> windows 2003 that shall run against same sql 2000. Now it cant
> >>> connect to sql-server, with same login as before.
> >>>
> >>> I created a .udl file on win 2k3 machine just for testing and it
> >>> works........ "Connection Successful"..... but when I use that
> >>> connection string with the asp-code I get: "SQL Server does not
> >>> exists or access denied".
> >>>
> >>> I ran tracer on sql-machine and nothing shows there. All servers are
> >>> on same domain, and it makes no sense why it doesnt work when the
> >>> test with the udl file said the connection with user, pass and
> >>> selected db works. All servers are in same domain and everything.
> >>>
> >>> Just did a response.write("test") which works...... but this is
> >>> really getting on my nerves now. grrr
> >>>
> >>> Any ideas of what might be wrong here? must be something with the
> >>> win 2k3 machine....
> >>>
> >>
> >> Have you eliminated all the possibilities outlined here:
> >> http://www.aspfaq.com/show.asp?id=2009
> >>
> >> --
> >> Microsoft MVP - ASP/ASP.NET
> >> Please reply to the newsgroup. This email account is my spam trap so
> >> I don't check it very often. If you must reply off-line, then remove
> >> the "NO SPAM"
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Re: Windows 2003 + SQL 2000 problem

Yes it can. Please reread the FAQ.

Lasse Edsvik wrote:
> Bob,
>
> well, im using an sqlserver-user so it cant be an NTFS-user problem?
>
>
> "Bob Barrows [MVP]" wrote in message
> news:una$yZbQFHA.3336@TK2MSFTNGP10.phx.gbl...
>> Same machine: different users...
>>
>> You are the user testing the udl. The IUSR account is the one trying
>> to connect. Go back and reread the faq. I'm pretty sure there's a KB
>> article cited in there that has your solution
>>
>> Lasse Edsvik wrote:
>>> Bob,
>>>
>>> pretty much, same code works on the win 2k machine so there must be
>>> something wrong with the win 2k3 machine.
>>>
>>> been connecting to databases for years and years and years and now
>>> this simple crap doesnt work :(
>>>
>>> could it be something with AD-rights or something like that?
>>>
>>> I just dont get why it can connect when i test the connection from
>>> the .udl file when i put in the settings there, and not from the
>>> code...... makes no sense, both are on same machine.
>>>
>>>
>>>
>>>
>>>
>>> "Bob Barrows [MVP]" wrote in message
>>> news:%23pUULCbQFHA.2876@TK2MSFTNGP09.phx.gbl...
>>>> Lasse Edsvik wrote:
>>>>> Hello
>>>>>
>>>>> Im having problems with a simple connectionstring that's driving
>>>>> me crazy on a windows 2003 machine.
>>>>>
>>>>> earlier I had 2 seperate machines, running win 2000 and sql 2000,
>>>>> works perfectly, then I was given the task to move the site to a
>>>>> windows 2003 that shall run against same sql 2000. Now it cant
>>>>> connect to sql-server, with same login as before.
>>>>>
>>>>> I created a .udl file on win 2k3 machine just for testing and it
>>>>> works........ "Connection Successful"..... but when I use that
>>>>> connection string with the asp-code I get: "SQL Server does not
>>>>> exists or access denied".
>>>>>
>>>>> I ran tracer on sql-machine and nothing shows there. All servers
>>>>> are on same domain, and it makes no sense why it doesnt work when
>>>>> the test with the udl file said the connection with user, pass and
>>>>> selected db works. All servers are in same domain and everything.
>>>>>
>>>>> Just did a response.write("test") which works...... but this is
>>>>> really getting on my nerves now. grrr
>>>>>
>>>>> Any ideas of what might be wrong here? must be something with the
>>>>> win 2k3 machine....
>>>>>
>>>>
>>>> Have you eliminated all the possibilities outlined here:
>>>> http://www.aspfaq.com/show.asp?id=2009
>>>>
>>>> --
>>>> Microsoft MVP - ASP/ASP.NET
>>>> Please reply to the newsgroup. This email account is my spam trap
>>>> so I don't check it very often. If you must reply off-line, then
>>>> remove the "NO SPAM"
>>
>> --
>> Microsoft MVP - ASP/ASP.NET
>> Please reply to the newsgroup. This email account is my spam trap so
>> I don't check it very often. If you must reply off-line, then remove
>> the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Windows 2003 + SQL 2000 problem

Here is a good test for you: give the IUSR account a password. log into the
box using the IUSR account. Test the udl (or create a new one) Any
difference?

Lasse Edsvik wrote:
> Bob,
>
> well, im using an sqlserver-user so it cant be an NTFS-user problem?
>
>
> "Bob Barrows [MVP]" wrote in message
> news:una$yZbQFHA.3336@TK2MSFTNGP10.phx.gbl...
>> Same machine: different users...
>>
>> You are the user testing the udl. The IUSR account is the one trying
>> to connect. Go back and reread the faq. I'm pretty sure there's a KB
>> article cited in there that has your solution
>>
>> Lasse Edsvik wrote:
>>> Bob,
>>>
>>> pretty much, same code works on the win 2k machine so there must be
>>> something wrong with the win 2k3 machine.
>>>
>>> been connecting to databases for years and years and years and now
>>> this simple crap doesnt work :(
>>>
>>> could it be something with AD-rights or something like that?
>>>
>>> I just dont get why it can connect when i test the connection from
>>> the .udl file when i put in the settings there, and not from the
>>> code...... makes no sense, both are on same machine.
>>>
>>>
>>>
>>>
>>>
>>> "Bob Barrows [MVP]" wrote in message
>>> news:%23pUULCbQFHA.2876@TK2MSFTNGP09.phx.gbl...
>>>> Lasse Edsvik wrote:
>>>>> Hello
>>>>>
>>>>> Im having problems with a simple connectionstring that's driving
>>>>> me crazy on a windows 2003 machine.
>>>>>
>>>>> earlier I had 2 seperate machines, running win 2000 and sql 2000,
>>>>> works perfectly, then I was given the task to move the site to a
>>>>> windows 2003 that shall run against same sql 2000. Now it cant
>>>>> connect to sql-server, with same login as before.
>>>>>
>>>>> I created a .udl file on win 2k3 machine just for testing and it
>>>>> works........ "Connection Successful"..... but when I use that
>>>>> connection string with the asp-code I get: "SQL Server does not
>>>>> exists or access denied".
>>>>>
>>>>> I ran tracer on sql-machine and nothing shows there. All servers
>>>>> are on same domain, and it makes no sense why it doesnt work when
>>>>> the test with the udl file said the connection with user, pass and
>>>>> selected db works. All servers are in same domain and everything.
>>>>>
>>>>> Just did a response.write("test") which works...... but this is
>>>>> really getting on my nerves now. grrr
>>>>>
>>>>> Any ideas of what might be wrong here? must be something with the
>>>>> win 2k3 machine....
>>>>>
>>>>
>>>> Have you eliminated all the possibilities outlined here:
>>>> http://www.aspfaq.com/show.asp?id=2009
>>>>
>>>> --
>>>> Microsoft MVP - ASP/ASP.NET
>>>> Please reply to the newsgroup. This email account is my spam trap
>>>> so I don't check it very often. If you must reply off-line, then
>>>> remove the "NO SPAM"
>>
>> --
>> Microsoft MVP - ASP/ASP.NET
>> Please reply to the newsgroup. This email account is my spam trap so
>> I don't check it very often. If you must reply off-line, then remove
>> the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

RE: Windows 2003 + SQL 2000 problem

Lasse,

I had the exact same issue. Apply SQL Service Pack 3a to your SQL
installation, and I bet it will solve your porblem.

"Lasse Edsvik" wrote:

> Hello
>
> Im having problems with a simple connectionstring that's driving me crazy on
> a windows 2003 machine.
>
> earlier I had 2 seperate machines, running win 2000 and sql 2000, works
> perfectly, then I was given the task to move the site to a windows 2003 that
> shall run against same sql 2000. Now it cant connect to sql-server, with
> same login as before.
>
> I created a .udl file on win 2k3 machine just for testing and it
> works........ "Connection Successful"..... but when I use that connection
> string with the asp-code I get: "SQL Server does not exists or access
> denied".
>
> I ran tracer on sql-machine and nothing shows there. All servers are on same
> domain, and it makes no sense why it doesnt work when the test with the udl
> file said the connection with user, pass and selected db works. All servers
> are in same domain and everything.
>
> Just did a response.write("test") which works...... but this is really
> getting on my nerves now. grrr
>
> Any ideas of what might be wrong here? must be something with the win 2k3
> machine....
>
> TIA
> /Lasse
>
>
>