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.CommandType =
CommandType.StoredProcedure;
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)\CommunityStarterKit\Engine\Framework\Commun ities\Components\Community
Utility.cs Line: 130
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASPNET.StarterKit.Communities.CommunityUtility.Get AllCommunitiesFromDB()
in C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\Commun ities\Components\Community
Utility.cs:130
ASPNET.StarterKit.Communities.CommunityUtility.Get AllCommunities() in
C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\Commun ities\Components\Community
Utility.cs:111
ASPNET.StarterKit.Communities.CommunityUtility.Get CommunityInfo() in
C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\Commun ities\Components\Community
Utility.cs:75
ASPNET.StarterKit.Communities.CommunitiesModule.Ap plication_BeginRequest(Obj
ect source, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET
Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\BaseCl asses\CommunitiesModule.cs
:64
System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep.
Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +87
"Scot Rose [MSFT]" <sc***@online.microsoft.com> wrote in message
news:JO**************@cpmsftngxa06.phx.gbl...
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 : sc***@online.microsoft.com <Remove word online. from address>
This posting is provided "AS IS", with no warranties, and confers no
rights.
--------------------From: "george r smith" <gs****@budgetext.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: <uA**************@TK2MSFTNGP12.phx.gbl>
Newsgroups: microsoft.public.dotnet.languages.csharp
NNTP-Posting-Host: 216-63-152-112.budgetext.com 216.63.152.112
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.languages.csharp:177540X-Tomcat-NG: microsoft.public.dotnet.languages.csharp
Gentlemen,
I know that this problem has happened before and I searched and
triedall solutions but
problem is not solved.
I install asp.net community starter kit with some help from this
newsgroup.Install 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
serveris
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="connectionString"
"Server=GSMITH;UID=sa;PWD=xxxx;database=Community StarterKit" />
Can anyone help. Funny thing is that this is the exact setup as
homeand it works fine
there but not here
thanks
grs
