"Geoff" wrote:

> All my pages come up with "SQL Server does not exist or access denied" after
> moving to a new Sql Server with a different name. None of my pages come up
> even though I am addressing the servername by IP Address. I can access the
> Server through Enterprise Manager and Query Analyzer using the same IP. I've
> also made sure the changes were made in Web.config. It worked fine before
> the switch.
>
>
>

"Peter Bromberg [C# MVP]" <pbromberg@yahoo.nospammin.com> wrote in message
news:318C5070-9E6F-45A0-A0B4-8F9166F1E1E5@microsoft.com...
> Geoff,
> Ensure that the new SQL Server is set up for "Mixed Mode" authentication -
> both Windows and SQL server logins.
> Peter
>
> --
> Co-founder, Eggheadcafe.com developer portal:
> http://www.eggheadcafe.com
> UnBlog:
> http://petesbloggerama.blogspot.com
>
>
>
>
> "Geoff" wrote:
>
> > All my pages come up with "SQL Server does not exist or access denied"
after
> > moving to a new Sql Server with a different name. None of my pages come
up
> > even though I am addressing the servername by IP Address. I can access
the
> > Server through Enterprise Manager and Query Analyzer using the same IP.
I've
> > also made sure the changes were made in Web.config. It worked fine
before
> > the switch.
> >
> >
> >

"Geoff" <cbs***@earthlink.net> wrote in message
news:kWsyf.2691$Hd4.2417@newsread1.news.pas.earthlink.net...
> It is set up for mixed mode and I can access the server through Query
> Analyzer, Enterprise Manager and my .asp pages are still able to connect
> through ODBC without a problem.
>
> "Peter Bromberg [C# MVP]" <pbromberg@yahoo.nospammin.com> wrote in message
> news:318C5070-9E6F-45A0-A0B4-8F9166F1E1E5@microsoft.com...
> > Geoff,
> > Ensure that the new SQL Server is set up for "Mixed Mode"
authentication -
> > both Windows and SQL server logins.
> > Peter
> >
> > --
> > Co-founder, Eggheadcafe.com developer portal:
> > http://www.eggheadcafe.com
> > UnBlog:
> > http://petesbloggerama.blogspot.com
> >
> >
> >
> >
> > "Geoff" wrote:
> >
> > > All my pages come up with "SQL Server does not exist or access denied"
> after
> > > moving to a new Sql Server with a different name. None of my pages
come
> up
> > > even though I am addressing the servername by IP Address. I can access
> the
> > > Server through Enterprise Manager and Query Analyzer using the same
IP.
> I've
> > > also made sure the changes were made in Web.config. It worked fine
> before
> > > the switch.
> > >
> > >
> > >
>
>