Re: SQL Server does not exist after moving to new Sql Server
- From: "Patrick.O.Ige" <naijacoder@xxxxxxxxxxx>
- Date: Mon, 16 Jan 2006 16:54:11 +1100
Maybe try re -registering your new database name.
And make sure you have the right permissions set
Patrick
"Geoff" <cbsinc@xxxxxxxxxxxxx> wrote in message
news:kWsyf.2691$Hd4.2417@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:318C5070-9E6F-45A0-A0B4-8F9166F1E1E5@xxxxxxxxxxxxxxxx
> > 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.
> > >
> > >
> > >
>
>
.
- References:
- Prev by Date: I am facing a serious issue when trying to start an application
- Next by Date: ASP.NET 2.0 File Upload Limits
- Previous by thread: Re: SQL Server does not exist after moving to new Sql Server
- Next by thread: vs2005 bug status?
- Index(es):
Relevant Pages
|
