CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




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

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" <>
NewsGroup User
Re: SQL Server does not exist or access denied10/2/2005 8:17:24 PM

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" <>
NewsGroup User
Re: SQL Server does not exist or access denied10/3/2005 6:48:17 AM

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" <>
NewsGroup User
Re: SQL Server does not exist or access denied10/3/2005 9:03:34 AM

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:









disable sign in link

web.config confusion

updatecartitem ..plz help

installation of commerce starter kit.

configuration error

login failed error on store login

sending values from checkout.aspx to amex page.

problems with the asp.net starterkit commerce download...please help!

commerce started kit problem

what happens with records in shoppingcart?

how does the register logic work

ssl, please help

great live site

@quantity is not a parameter for procedure cmrc_shoppingcartadditem

shared hosting and using sql express 2005 with the commerce starter kit

exception error during install

_menu.aspx categories

testing for cookies and javascript

my version of the commerce site

reviewlist doesn't get correct productid

category nav question...

can any body help whith shopping bulid based on cookies

database handling architecture for ibuyspy store

need a push in the back......new(whanna)be!!!!

can´t connect to localhost

template problem

sorting at the productlist

user.identity.name: where is it come from?

microsoft commerce example

stored procedures

strange bug when change currency to try

recompiling the ibs to include my new code for my custom checkout

strange error ! can anyone help

bug: install unsucessful

visa & mastercard

error connecting to localhost during install of commerce kit

shipping & handling calculation ?

sql issue w/ registration

how does the software redirect to login.aspx?

unbelievable site example

no admin

finetuning product search

store + msde + vs.net debug error

adding new fields to the database

accents and special symbols

combining dal & bll

installation problems

maybe bug in commerce starter kit?

multiple login pages

extended classifieds / sql
   
  Privacy | Contact Us
All Times Are GMT