CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit Tags:
Item Type: NewsGroup Date Entered: 10/2/2005 4:45:45 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 3 Views: 16 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
4 Items, 1 Pages 1 |< << Go >> >|
Suranjith
Asp.Net User
SQL Server does not exist or access denied10/2/2005 4:45:45 PM

0/0

Hi,
I have downloaded the Commerce starter kit.
I 'm trying to connect to sql database through visual studio .net
 
but I getting this error

SQL Server does not exist or access denied
Line 63:
Line 64:             // Execute the command
Line 65:             myConnection.Open();
Line 66:             SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Line 67:

Even through the through the installation the connection was succesfull all the tables were created in the commerce database in my SQl server.

please help me My question is why is not connecting to the sql database.

thanks
janaka
Spire128
Asp.Net User
Re: SQL Server does not exist or access denied10/2/2005 8:17:24 PM

0/0

Hi

You need to chabge this line in the wb config to point to your sever

<add key="ConnectionString" value="server=YourServer;uid=YourUserName;pwd=Yourpassword;database=Commerce" />


or if u are useing locale host server it will be something like below using your server name

<add key="ConnectionString" value="server=Desktop;Trusted_Connection=true;database=Commerce" />





Suranjith
Asp.Net User
Re: SQL Server does not exist or access denied10/3/2005 6:48:17 AM

0/0

Thanks for the reply

I 'm testing my SQL is in Local host.

my web config code is

<add key="ConnectionString" value="server=localhost;Trusted_Connection=true;database=Commerce" />

Still getting the same error

Do I need to change the computer name on this add key code
My computer name is "Galle"

I 'm having this problem for long time now
I can not connect any local SQL databases through Visual Studio .net
 
Please help

Spire128
Asp.Net User
Re: SQL Server does not exist or access denied10/3/2005 9:03:34 AM

0/0

Is the Sql server called localhost if the server name is called for example Desktop then u need to change it in the Web Config to your Sql server instance name, and check that the Sql server is set up for trusted permissions ie windows authentication
4 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
ASP.NET: Tips, Tutorials, and Code Authors: Scott Mitchell, Pages: 878, Published: 2002
The Debugger's Handbook Authors: J. F. DiMarzio, Pages: 458, Published: 2007
Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications Authors: Helen Feddema, Pages: 700, Published: 2007
Visual Basic .NET Database Programming Authors: Rod Stephens, Pages: 405, Published: 2002
Professional SQL Server 2005 Administration Authors: Brian Knight, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steven Wort, Joe Salvatore, Haidong Ji, Pages: 735, Published: 2006
SQL Server 2005 Bible Authors: Paul Nielsen, Pages: 1293, Published: 2006
Beginning ASP.NET 1.1 Databases: From Novice to Professional Authors: Damien Foggon, Daniel Maharry, Pages: 600, Published: 2004
Pro ASP.NET 2.0 in VB 2005: From Professional to Expert Authors: Laurence Moroney, Matthew MacDonald, Pages: 1253, Published: 2006
Pro ASP.NET 2.0 in C# 2005: Create Next-generation Web Applications with the Latest Version of Microsoft's Revolutionary Technology Authors: Matthew MacDonald, Mario Szpuszta, Pages: 1426, Published: 2006
Hacking Exposed Windows Server 2003: Windows Server 2003 Authors: Joel Scambray, Stuart McClure, Pages: 541, Published: 2003

Web:
Potential causes of the "SQL Server does not exist or access ... "SQL Server does not exist or access denied" is a generic Microsoft Data Access Components (MDAC) message that indicates that the computer that is running ...
SQL Server does not exist or access denied. Apr 3, 2008 ... I get this error message with SQL Server 2005 on an XP Pro machine. ... don't need network access - the intention is a single user on a ...
SQL Server Storage Engine & Tools (SSQA.net) : SQL Server does not ... Aug 13, 2007 ... SQL Server does not exist or access denied. I hope you will get to see the above error message most often and I say a common question among ...
SQL Server Does not Exist or Access Denied SQL Server Does not Exist or Access Denied. How many times have you seen this error? SQL SERVER DOES NOT EXIST OR ACCESS DENIED The cause of this error can ...
Error: SQL Server does not exist or access denied - MSDN Forums Error: SQL Server does not exist or access denied Thread Starter: SeekTechHelp Started: 25 May 2006 11:34 PM UTC Replies: 10 ...
SQL Server does not exist or access denied SQL Server does not exist or access denied Every day, more enterprises resort to the internet to provide their clients with access to their SQL Server 2000 ...
SQL Server Forums - SQL Server does not exist or access denied SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web request. ...
SQL Protocols : VSS: SQL Server does not exist or access denied I recently worked on three customer issues. In all those cases, customers were not able to backup databases using Microsoft Volume Shadow Copy Service (VSS) ...
BizTalk Error: "SQL Server does not exist or access denied." Error Message: "SQL Server does not exist or access denied." Reason: The problem is probably that the project properties contain the wrong SQL Server. ...
Re: SQL Server does not exist or access denied. Apr 4, 2008 ... network utility or SQL Server configuration manager). ... SQL Server Error: 17 . ..




Search This Site:










display page name in skin ...

vwd 2008

module container bug

hi can anyone help me??

hello world 3.0 module tutorial

visual studio 2005

how is session timeout detected? (forms authentication)

why the dataprovider has to be in a separate project/dll ?

sharing security between 2 apps

dnn 3 requirements

re: request for help on structure of nested classes for module settings

question on how the project deals with connections

asp.net 2.0 hard coded password recovery

masterpages & treeview navigation

several sitemaps in the same app?

pop-up menu showing "below" content

help please with solpartmenu on skin

web deployment project + vs2005 bug

how to use webpartzone control in gridview control's template?

sending secure email...

using editurl or navigateurl to get back from edit page to view page when itemid parameter is needed

c# inheritance question regarding modulesettings class

"display container" setting

child menu was disabled

user-defined form module

where are the modules in 3.1.1?

controlling of dns using asp.net programming

can't log in

server error accessing edit skins in enhanced version from nexxus

help! changed admin password now nothing runs!

 
All Times Are GMT