Error Locating Server/Instance

Hi All, i'm using Sql Server 2005 Standard, IIS 6.0 an Windows 2003 Server.
I deployed my project on IIS (Default web site) everything goes well, but i created new web site on IIS called MCSite and deplyed here same project as to Default web site. I navigate to project on new web site, the login screen show, i've inserted credentials(credentials to application not to SQL Server!!) and try to login, then an error message show: error 26:Error Locating Server/Instance.

Can someone help me what to do with that?
Thank you very muchCan you send connection string which you r using

thanks|||A quick Google of the error message you listed revealed numerous causes and solutions to the problem. Rather than list them all here, I request you try Google first and come back if you are still having the issue.

Error in ASP/SQL Server

Hello,
I have searched all over the web in order to find a solution to this,
but nothing I find seems to fit my problem.
My IIS and SQL Server reside on the same server. I am trying to
connect my ASP page to that SQL Server. My connection string looks
like
"Provider=sqloledb;Data Source=XXX.XXX.XXX.XXX;Initial
Catalog=DATABASE;Persist Security Info=False;UID=uid;PWD=PASS;Network
Library=DBMSSOCN"
When trying to access the page, I receive
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I have tried putting the port number at the end of the data source.
I tried troubleshooting the problem with seeing if I can get into SQL
Server Enterprise Manager and Query Analyzer using that UID and PWD. I
could.
I checked my SQL server security setting and it is setup with both SQL
Server and Windows authenication. Everything seems to be set up
properly.
I have tcp/ip enabled with the correct port.
I have used just the server name in the connection string.
Nothing seems to narrow down the problem.
Any help would be greatly appreciated. A web site! Advice! I'm not
picky.
Thanks,
Amanda
devanoy@.hotmail.com> "Provider=sqloledb;Data Source=XXX.XXX.XXX.XXX;Initial

quote:

---

> Catalog=DATABASE;Persist Security Info=False;UID=uid;PWD=PASS;Network
> Library=DBMSSOCN"

---

Did you try 127.0.0.1 or LOCALHOST or (local) as the Data Source parameter?
Do you really have a database named "DATABASE"?
Is your user/password information correct?
Is SQL Server listening on the correct port (1433)?
Are you sure this is a default install and not a named instance?|||Amanda (devanoy@.hotmail.com) writes:

quote:

---

> I have searched all over the web in order to find a solution to this,
> but nothing I find seems to fit my problem.
> My IIS and SQL Server reside on the same server. I am trying to
> connect my ASP page to that SQL Server. My connection string looks
> like
> "Provider=sqloledb;Data Source=XXX.XXX.XXX.XXX;Initial
> Catalog=DATABASE;Persist Security Info=False;UID=uid;PWD=PASS;Network
> Library=DBMSSOCN"
> When trying to access the page, I receive
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.

---

Why that Network Library parameter? I would try removing it.
Also, for Data Source I would try (local) instead, to make things simpler.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I don't believe it. Removing the network library from the connection string
worked!
And no, my database name is not DATABASE.
Thanks a lot!!
Amanda
Erland Sommarskog <sommar@.algonet.se> wrote in message news:<Xns9465469FC4FEYazorman@.127.0.0.1>...

quote:

---

> Amanda (devanoy@.hotmail.com) writes:
> Why that Network Library parameter? I would try removing it.
> Also, for Data Source I would try (local) instead, to make things simpler.

---