Problems Accessing New MSDE

[Fred Nelson]

Help!

I just upgraded MSDE to the latest version on my Windows 2000 server.
Everything appears to work fine - the enterprise manager on both the server
and on my computer are able to access the new database and I have loaded it
with all of its data using the enterprise manager. (Actually I've completed
the entire cycle three times!)

The catch is that my VB.NET web application is no longer able to access the
database! I'm using the same connection string as before.

I have a VB.NET client program that CAN access the database with no problems
at all.

I've posted this question in the MSDE forum - I'm hoping that others have
already faced this issue and found a solution!

Also: Is there a way to determine why my calls to stored procedures are
failing - perhaps this would help!

Any help would be GREATLY appreciated!

Thanks,

Fred

[Jim Hughes]

Re: Problems Accessing New MSDE

By default, networking is disabled in the latest vesions of MSDE. See the
readme file for instructions for how to enable networking and assign the SA
password.

It can be done by hacking the registry and stopping/starting mssqlserver.
Search Google. There are probly other ways as well.

"Fred Nelson" <fred@smartybir d.com> wrote in message
news:ORLSE17wEH A.3840@tk2msftn gp13.phx.gbl...[color=blue]
> Help!
>
> I just upgraded MSDE to the latest version on my Windows 2000 server.
> Everything appears to work fine - the enterprise manager on both the
> server
> and on my computer are able to access the new database and I have loaded
> it
> with all of its data using the enterprise manager. (Actually I've
> completed
> the entire cycle three times!)
>
> The catch is that my VB.NET web application is no longer able to access
> the
> database! I'm using the same connection string as before.
>
> I have a VB.NET client program that CAN access the database with no
> problems
> at all.
>
> I've posted this question in the MSDE forum - I'm hoping that others have
> already faced this issue and found a solution!
>
> Also: Is there a way to determine why my calls to stored procedures are
> failing - perhaps this would help!
>
> Any help would be GREATLY appreciated!
>
> Thanks,
>
> Fred
>
>[/color]

[Fred Nelson]

Re: Problems Accessing New MSDE

Hi Jim:

I have enabled network protocols and I can access my SQL-MSDE from the
enterprise manager both on the server itself and from my computer.
Additionally I can access it from a remote VB.NET client program.

I can't access it from the web server that is also running on the same
machine.

Also: I have set up two other machines in the same way and the work fine!

So: I'm very confused - I haven't found many articles on google that are
helpful.

If you have any suggestions I would greatly appreciate it.

Thanks,

Fred


"Jim Hughes" <NOSPAMJ3033@Ho tmail.com> wrote in message
news:eAXMxA8wEH A.1292@TK2MSFTN GP10.phx.gbl...[color=blue]
> By default, networking is disabled in the latest vesions of MSDE. See the
> readme file for instructions for how to enable networking and assign the[/color]
SA[color=blue]
> password.
>
> It can be done by hacking the registry and stopping/starting mssqlserver.
> Search Google. There are probly other ways as well.
>
> "Fred Nelson" <fred@smartybir d.com> wrote in message
> news:ORLSE17wEH A.3840@tk2msftn gp13.phx.gbl...[color=green]
> > Help!
> >
> > I just upgraded MSDE to the latest version on my Windows 2000 server.
> > Everything appears to work fine - the enterprise manager on both the
> > server
> > and on my computer are able to access the new database and I have loaded
> > it
> > with all of its data using the enterprise manager. (Actually I've
> > completed
> > the entire cycle three times!)
> >
> > The catch is that my VB.NET web application is no longer able to access
> > the
> > database! I'm using the same connection string as before.
> >
> > I have a VB.NET client program that CAN access the database with no
> > problems
> > at all.
> >
> > I've posted this question in the MSDE forum - I'm hoping that others[/color][/color]
have[color=blue][color=green]
> > already faced this issue and found a solution!
> >
> > Also: Is there a way to determine why my calls to stored procedures are
> > failing - perhaps this would help!
> >
> > Any help would be GREATLY appreciated!
> >
> > Thanks,
> >
> > Fred
> >
> >[/color]
>
>[/color]

[Fred Nelson]

Re: Problems Accessing New MSDE

Hey Jim:

Just a follow up: I found that something in the MSDE installation "hosed"
my default web site - no idea what it was. To fix it I temporarily made
another site my default, deleted the programs, re-installed and life is good
again!

I put the "old" msde back on the system and it still didn't work so I tried
this.

Now the next step is to install the new MSDE again and know that I will need
to redeploy the program.

Hope this helps you sometime in the future!

Fred

"Jim Hughes" <NOSPAMJ3033@Ho tmail.com> wrote in message
news:eAXMxA8wEH A.1292@TK2MSFTN GP10.phx.gbl...[color=blue]
> By default, networking is disabled in the latest vesions of MSDE. See the
> readme file for instructions for how to enable networking and assign the[/color]
SA[color=blue]
> password.
>
> It can be done by hacking the registry and stopping/starting mssqlserver.
> Search Google. There are probly other ways as well.
>
> "Fred Nelson" <fred@smartybir d.com> wrote in message
> news:ORLSE17wEH A.3840@tk2msftn gp13.phx.gbl...[color=green]
> > Help!
> >
> > I just upgraded MSDE to the latest version on my Windows 2000 server.
> > Everything appears to work fine - the enterprise manager on both the
> > server
> > and on my computer are able to access the new database and I have loaded
> > it
> > with all of its data using the enterprise manager. (Actually I've
> > completed
> > the entire cycle three times!)
> >
> > The catch is that my VB.NET web application is no longer able to access
> > the
> > database! I'm using the same connection string as before.
> >
> > I have a VB.NET client program that CAN access the database with no
> > problems
> > at all.
> >
> > I've posted this question in the MSDE forum - I'm hoping that others[/color][/color]
have[color=blue][color=green]
> > already faced this issue and found a solution!
> >
> > Also: Is there a way to determine why my calls to stored procedures are
> > failing - perhaps this would help!
> >
> > Any help would be GREATLY appreciated!
> >
> > Thanks,
> >
> > Fred
> >
> >[/color]
>
>[/color]

[Nikolay Petrov]

Re: Problems Accessing New MSDE

What type of authentication do you use in your web server.
If you use SQL authentication, maybe your MSDE is only configured to use
Windows auth. If so look at the readme how to enable it.


"Fred Nelson" <fred@smartybir d.com> wrote in message
news:ORLSE17wEH A.3840@tk2msftn gp13.phx.gbl...[color=blue]
> Help!
>
> I just upgraded MSDE to the latest version on my Windows 2000 server.
> Everything appears to work fine - the enterprise manager on both the
> server
> and on my computer are able to access the new database and I have loaded
> it
> with all of its data using the enterprise manager. (Actually I've
> completed
> the entire cycle three times!)
>
> The catch is that my VB.NET web application is no longer able to access
> the
> database! I'm using the same connection string as before.
>
> I have a VB.NET client program that CAN access the database with no
> problems
> at all.
>
> I've posted this question in the MSDE forum - I'm hoping that others have
> already faced this issue and found a solution!
>
> Also: Is there a way to determine why my calls to stored procedures are
> failing - perhaps this would help!
>
> Any help would be GREATLY appreciated!
>
> Thanks,
>
> Fred
>
>[/color]