SQL Server Does Not exist

[george r smith]

Gentlemen,
I know that this problem has happened before and I searched and tried
all solutions but
problem is not solved.

I install asp.net community starter kit with some help from this
newsgroup.Insta ll went fine,
database was created on the SQL server machine but when I bring up
browser and try to
connect I get:
"SQL Server does not exist or access denied" error message.

IIS and visual studion running on workstation (2000 pro). SQL server
is
running on a workgroup computer (2003).

I can access the SQL server using isqlw from workstation. Checked
connection string in web.config it looks OK as follows:
<database>
<add key="connection String"
"Server=GSMITH; UID=sa;PWD=xxxx ;database=Commu nityStarterKit" />

Can anyone help. Funny thing is that this is the exact setup as home
and it works fine
there but not here

thanks
grs

[Scot Rose [MSFT]]

RE: SQL Server Does Not exist

Maybe name resolution. What happens if you use the SQL Servers IP Address rather than the name?

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : scotr@online.mi crosoft.com <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.




--------------------[color=blue]
>From: "george r smith" <gsmith@budgete xt.com>
>Subject: SQL Server Does Not exist
>Date: Tue, 19 Aug 2003 16:19:47 -0500
>Lines: 30
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <uABVfepZDHA.10 04@TK2MSFTNGP12 .phx.gbl>
>Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
>NNTP-Posting-Host: 216-63-152-112.budgetext.c om 216.63.152.112
>Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP12.phx.g bl
>Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.csharp:1775 40
>X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
>
> Gentlemen,
> I know that this problem has happened before and I searched and tried
>all solutions but
> problem is not solved.
>
> I install asp.net community starter kit with some help from this
>newsgroup.Inst all went fine,
> database was created on the SQL server machine but when I bring up
>browser and try to
> connect I get:
> "SQL Server does not exist or access denied" error message.
>
> IIS and visual studion running on workstation (2000 pro). SQL server
>is
> running on a workgroup computer (2003).
>
> I can access the SQL server using isqlw from workstation. Checked
> connection string in web.config it looks OK as follows:
> <database>
> <add key="connection String"
>"Server=GSMITH ;UID=sa;PWD=xxx x;database=Comm unityStarterKit " />
>
> Can anyone help. Funny thing is that this is the exact setup as home
>and it works fine
> there but not here
>
> thanks
> grs
>
>
>[/color]

[george r smith]

Re: SQL Server Does Not exist

Scot,
Tried IP address no luck - still blows up. I have msdn it does not seem to
be much help.
How can isqlw work and the community starter kit connection string does not.
I have
the line of code but it provides not help to me, because the code then goes
to the microsoft binaries.
Here is the dump as suggested by the IDE
Source Error:

Line 128: dadCommunities. SelectCommand.C ommandType =
CommandType.Sto redProcedure;
Line 129: DataSet dstCommunities = new DataSet();
Line 130: dadCommunities. Fill( dstCommunities );
Line 131: return dstCommunities;
Line 132: }

Source File: C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter
Kit
(CSVS)\Communit yStarterKit\Eng ine\Framework\C ommunities\Comp onents\Communit y
Utility.cs Line: 130

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) +474

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
System.Data.Com mon.DbDataAdapt er.QuietOpen(ID bConnection connection,
ConnectionState & originalState) +44
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +38
ASPNET.StarterK it.Communities. CommunityUtilit y.GetAllCommuni tiesFromDB()
in C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\Communit yStarterKit\Eng ine\Framework\C ommunities\Comp onents\Communit y
Utility.cs:130
ASPNET.StarterK it.Communities. CommunityUtilit y.GetAllCommuni ties() in
C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\Communit yStarterKit\Eng ine\Framework\C ommunities\Comp onents\Communit y
Utility.cs:111
ASPNET.StarterK it.Communities. CommunityUtilit y.GetCommunityI nfo() in
C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\Communit yStarterKit\Eng ine\Framework\C ommunities\Comp onents\Communit y
Utility.cs:75

ASPNET.StarterK it.Communities. CommunitiesModu le.Application_ BeginRequest(Ob j
ect source, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET
Community Starter Kit
(CSVS)\Communit yStarterKit\Eng ine\Framework\B aseClasses\Comm unitiesModule.c s
:64

System.Web.Sync EventExecutionS tep.System.Web. HttpApplication +IExecutionStep .
Execute() +60
System.Web.Http Application.Exe cuteStep(IExecu tionStep step, Boolean&
completedSynchr onously) +87




"Scot Rose [MSFT]" <scotr@online.m icrosoft.com> wrote in message
news:JOJI7KyZDH A.2116@cpmsftng xa06.phx.gbl...[color=blue]
> Maybe name resolution. What happens if you use the SQL Servers IP Address[/color]
rather than the name?[color=blue]
>
> Want to know more? Check out the MSDN Library at http://msdn.microsoft.com[/color]
or the Microsoft Knowledge Base at http://support.microsoft.com[color=blue]
>
> Scot Rose, MCSD
> Microsoft Visual Basic Developer Support
> Email : scotr@online.mi crosoft.com <Remove word online. from address>
>
> This posting is provided "AS IS", with no warranties, and confers no[/color]
rights.[color=blue]
>
>
>
>
> --------------------[color=green]
> >From: "george r smith" <gsmith@budgete xt.com>
> >Subject: SQL Server Does Not exist
> >Date: Tue, 19 Aug 2003 16:19:47 -0500
> >Lines: 30
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> >Message-ID: <uABVfepZDHA.10 04@TK2MSFTNGP12 .phx.gbl>
> >Newsgroups: microsoft.publi c.dotnet.langua ges.csharp
> >NNTP-Posting-Host: 216-63-152-112.budgetext.c om 216.63.152.112
> >Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP12.phx.g bl
> >Xref: cpmsftngxa06.ph x.gbl[/color][/color]
microsoft.publi c.dotnet.langua ges.csharp:1775 40[color=blue][color=green]
> >X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.csharp
> >
> > Gentlemen,
> > I know that this problem has happened before and I searched and[/color][/color]
tried[color=blue][color=green]
> >all solutions but
> > problem is not solved.
> >
> > I install asp.net community starter kit with some help from this
> >newsgroup.Inst all went fine,
> > database was created on the SQL server machine but when I bring up
> >browser and try to
> > connect I get:
> > "SQL Server does not exist or access denied" error message.
> >
> > IIS and visual studion running on workstation (2000 pro). SQL[/color][/color]
server[color=blue][color=green]
> >is
> > running on a workgroup computer (2003).
> >
> > I can access the SQL server using isqlw from workstation. Checked
> > connection string in web.config it looks OK as follows:
> > <database>
> > <add key="connection String"
> >"Server=GSMITH ;UID=sa;PWD=xxx x;database=Comm unityStarterKit " />
> >
> > Can anyone help. Funny thing is that this is the exact setup as[/color][/color]
home[color=blue][color=green]
> >and it works fine
> > there but not here
> >
> > thanks
> > grs
> >
> >
> >[/color]
>
>[/color]