Wrox Programmer Forums
|
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 15th, 2005, 10:55 PM
Registered User
 
Join Date: Sep 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server does not exist or access denied

my computer name is HUANG
sql server instance is (LOCAL)
DATABASE NAME is:thePhile
user:sa
pass:sa

I want to know how to "Change the connection string settings in web.cong file Change the connection string settings in all the config files residing in the config folder"

Now I set:
Web.Config
    <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=local;user id=sa;password=sa"
            cookieless="false"
            timeout="20"
    />

Other config:
<ConnectionString>server=HUANG;database=thePhile;u id=sa;pwd=sa;</ConnectionString>

But I IIS show error,
SQL Server does not exist or access denied
who can help me,thank you !

 
Old September 15th, 2005, 11:37 PM
Registered User
 
Join Date: Sep 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK,now

    <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=127.0.0.1;user id=sa;password=sa"
            cookieless="false"
            timeout="20"
    />
----------------------------------------------------
other xml

server=(local);uid=sa;pwd=sa;Database=thePhile

 
Old September 17th, 2005, 10:32 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Most of us aren't using sql server session state so we should change that connection string in web.config.

For most of us users of ThePhile, the config files in the config folder are the only place where we need a valid connection string.
 
Old September 21st, 2005, 01:04 PM
Registered User
 
Join Date: Sep 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to mcdeeiis Send a message via Yahoo to mcdeeiis
Default

Can any one help me out, for the above topic, i changed the user id and password according to my settings, but the problem still persists...
It says:
--------------------------------------

An unexpected error has occurred on this page.The system administrators have been notified.

The error occurred in:
http://localhost/ThePhileVB/Default.aspx

Error Message:
SQL Server does not exist or access denied.
--------------------------------------


Success if often just an idea away...
 
Old September 21st, 2005, 03:12 PM
Registered User
 
Join Date: Sep 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I use:

 <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="SERVER=sqlservername;DATABASE =thephile;UID=sqluseraccountname;pwd=sqluseraccoun tpassword"
            cookieless="false"
            timeout="20"
    />

 
Old September 23rd, 2005, 10:04 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Like I said, this connection string is not used if you're not using SQL Server session state. Check out the "InProc" value - that means "in process", which means you are NOT using SQL server session state.

The only connection strings that matter are in the config folder.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server does not exist or access denied happygv SQL Server 2000 0 April 9th, 2008 02:27 AM
SQL Server does not exist or access denied jennypretty Classic ASP Databases 3 May 18th, 2007 11:43 AM
SQL Server does not exist or access denied. jimbeam36 BOOK: ASP.NET Website Programming Problem-Design-Solution 3 November 3rd, 2004 08:51 AM
SQL Server does not exist or access denied haidee_mccaffrey Classic ASP Databases 19 June 28th, 2004 09:38 PM
SQL Server does not exist or access denied. nitinmailbox All Other Wrox Books 1 June 25th, 2003 06:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.