SQL Server does not exist after moving to new Sql Server

[Geoff]

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]]

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]

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]" <pb*******@yahoo.nospammin.com> wrote in message
news:31**********************************@microsof t.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.

[Patrick.O.Ige]

Maybe try re -registering your new database name.
And make sure you have the right permissions set
Patrick

"Geoff" <cb****@earthlink.net> wrote in message
news:kW*****************@newsread1.news.pas.earthl ink.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]" <pb*******@yahoo.nospammin.com> wrote in message
news:31**********************************@microsof t.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.