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.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 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="connectionString"
"Server=GSMITH;UID=sa;PWD=xxxx;database=CommunityStarterKit" />

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

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 : (e-mail address removed) <Remove word online. from address>

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




--------------------

 

[george r smith]

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\Communities\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.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object 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.GetAllCommunitiesFromDB()
in C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\Communities\Components\Community
Utility.cs:130
ASPNET.StarterKit.Communities.CommunityUtility.GetAllCommunities() in
C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\Communities\Components\Community
Utility.cs:111
ASPNET.StarterKit.Communities.CommunityUtility.GetCommunityInfo() in
C:\Program Files\ASP.NET Starter Kits\ASP.NET Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\Communities\Components\Community
Utility.cs:75

ASPNET.StarterKit.Communities.CommunitiesModule.Application_BeginRequest(Obj
ect source, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET
Community Starter Kit
(CSVS)\CommunityStarterKit\Engine\Framework\BaseClasses\CommunitiesModule.cs
:64

System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.
Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87

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