Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > BOOK: Beginning ASP.NET 4 : in C# and VB
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #21 (permalink)  
Old August 6th, 2012, 04:33 AM
Imar's Avatar
Wrox Author
Points: 71,768, Level: 100
Points: 71,768, Level: 100 Points: 71,768, Level: 100 Points: 71,768, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,033
Thanks: 80
Thanked 1,582 Times in 1,559 Posts
Default

Hi there,

Good to hear it's working. Did you check out Appendix B? It shows you how to acquire, install and use Management Studio Express...

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #22 (permalink)  
Old August 7th, 2012, 11:50 AM
Authorized User
Points: 203, Level: 4
Points: 203, Level: 4 Points: 203, Level: 4 Points: 203, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Location: Mesquite Texas
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Smile SQL SERVER: Development vs Hosting database methods

Yes, appendix B is very helpful, had win7 SP issues, I think.

Now that I have my databases in SQL Server; ? Use the SQL SERVER AUTHENTICATION method and the "RELEASE" version for going online/live testing via a Hosting service ?

And use WINDOWS AUTHENTICATION method for my development system now? This is the one that should work on my system? Practice/test combining the DBases(PlanetWrok & aspnetDB) this way ? (do this first ?)


And Now that i have SQL server, don't use \.SQLEXPRESS , except for early, easy simple development work ?

Thanks for your help, i'm totally new at this, book is great!! thanks Eddie
Reply With Quote
  #23 (permalink)  
Old August 7th, 2012, 02:11 PM
Imar's Avatar
Wrox Author
Points: 71,768, Level: 100
Points: 71,768, Level: 100 Points: 71,768, Level: 100 Points: 71,768, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,033
Thanks: 80
Thanked 1,582 Times in 1,559 Posts
Default

Hi there,

Quote:
Now that I have my databases in SQL Server; ? Use the SQL SERVER AUTHENTICATION method and the "RELEASE" version for going online/live testing via a Hosting service ?
It depends ;-) If your host only supports SQL authentication, then yes. Otherwise, Windows authentication is preferred. Also, if they allow you to attach or restore database you can use the release version. Otherwise, you need to script it first as explained in the book.

Quote:
And use WINDOWS AUTHENTICATION method for my development system now? This is the one that should work on my system? Practice/test combining the DBases(PlanetWrok & aspnetDB) this way ? (do this first ?)
Yes, although I would still recommend using Express for this.

Quote:
And Now that i have SQL server, don't use \.SQLEXPRESS , except for early, easy simple development work ?
Same here. I would recommend using Express. It's not a toy system; it's a real database engine that just happens to be free. I use the Express engine for pretty much all my development although I do use the tools from the Developer edition.

Quote:
Thanks for your help, i'm totally new at this, book is great!! thanks Eddie
You're welcome.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
EDGY (August 7th, 2012)
  #24 (permalink)  
Old August 9th, 2012, 08:44 AM
Authorized User
Points: 203, Level: 4
Points: 203, Level: 4 Points: 203, Level: 4 Points: 203, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Location: Mesquite Texas
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Smile Remote connection error SQL Server: Pipes Provider

Hey Imar,

I'm getting my dev/test system to use the SQL Server engine. I've got my Dbases loaded and my IIS points to my /Release folder but im getting remote connection errors. Im using the "recreating Dbase" connection settings from pg 726. I have 3 Instances running on SQL but no agents, do i need to stop the others and should 1 agent be up, im using one called MSSQLSERVER2.
i'm using SQL authentication. My page comes up when i call localhost, but get remote connection errors when calling any of the Dbase useage; Me Pipes provider is BAD ?

Your Assistance, suggestions and Guidance is greatly appreciated..
Thanks for your Help Imar,

Error Message
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

SQL Server 2008 R2 management studio
Win7

code:
<connectionStrings>
<!-- <add name="PlanetWroxConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\PlanetWrox.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
<add name="PlanetWroxEntities" connectionString="metadata=res://*/App_Code.PlanetWrox.csdl|res://*/App_Code.PlanetWrox.ssdl|res://*/App_Code.PlanetWrox.msl;provider=System.Data.SqlCl ient;provider connection string=&quot;data source=.\SQLEXPRESS;attachdbfilename=|DataDirector y|\PlanetWrox.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=En tityFramework&quot;" providerName="System.Data.EntityClient" />
-->
<clear />
<add name="PlanetWroxConnectionString1" connectionString="Data Source=EDWARD-PC/MSSQLSERVER2; Initial Catalog=PlanetWrox; User ID=PlanetWroxUser; password=Pa$$w0rD;" providerName="System.Data.SqlClient" />
<add name="PlanetWroxEntities" connectionString="metadata=res://*/App_Code.PlanetWrox.csdl|res://*/App_Code.PlanetWrox.ssdl|res://*/App_Code.PlanetWrox.msl;provider=System.Data.SqlCl ient; provider connection string=&quot;Data Source=EDWARD-PC/MSSQLSERVER2;Initial Catalog=PlanetWrox; User ID=PlanetWroxUser;password=Pa$$w0rD;MultipleActive ResultSets=True&quot;" providerName="System.Data.EntityClient" />
<add name="LocalSqlServer" connectionString="Data Source=EDWARD-PC/MSSQLSERVER2; Initial Catalog=ASPNETDB; User ID=PlanetWroxUser;password=Pa$$w0rD" providerName="System.Data.SqlClient" />
</connectionStrings>

Last edited by EDGY; August 9th, 2012 at 09:09 AM. Reason: include suspect code snippet
Reply With Quote
  #25 (permalink)  
Old August 9th, 2012, 08:49 AM
Imar's Avatar
Wrox Author
Points: 71,768, Level: 100
Points: 71,768, Level: 100 Points: 71,768, Level: 100 Points: 71,768, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,033
Thanks: 80
Thanked 1,582 Times in 1,559 Posts
Default

Hi there,

Can you log in to SSMS directly? Also did you configure all connection strings in web.config to use this new provider? Can you post the code for that file?

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #26 (permalink)  
Old August 9th, 2012, 09:12 AM
Authorized User
Points: 203, Level: 4
Points: 203, Level: 4 Points: 203, Level: 4 Points: 203, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Location: Mesquite Texas
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Smile code snippet requested

I just now added the suspect code snippet to the orig message...Thanks for looking
Reply With Quote
  #27 (permalink)  
Old August 9th, 2012, 09:22 AM
Imar's Avatar
Wrox Author
Points: 71,768, Level: 100
Points: 71,768, Level: 100 Points: 71,768, Level: 100 Points: 71,768, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,033
Thanks: 80
Thanked 1,582 Times in 1,559 Posts
Default

Have you tried EDWARD-PC\MSSQLSERVER2 instead of EDWARD-PC/MSSQLSERVER2? The correct way to address a named instance is with a back slash.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
EDGY (August 9th, 2012)
  #28 (permalink)  
Old August 9th, 2012, 09:22 AM
Authorized User
Points: 203, Level: 4
Points: 203, Level: 4 Points: 203, Level: 4 Points: 203, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Location: Mesquite Texas
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Smile

Imar,
Yea, i can get to SSMS directly, and i only get remote connection errors on my RELEASE version, because i just tested my VS/dev work ,and it got no remote connection errors, it has before, and all the functions/dbases are working properly there. So , it seems just my Release version thats having errors..

Thanks
Reply With Quote
  #29 (permalink)  
Old August 9th, 2012, 09:34 AM
Authorized User
Points: 203, Level: 4
Points: 203, Level: 4 Points: 203, Level: 4 Points: 203, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2012
Location: Mesquite Texas
Posts: 45
Thanks: 11
Thanked 0 Times in 0 Posts
Default Remote connection Error - misspelled Server Name using /

DUDE,
your the Greatest. That was IT, I kept looking at that and did not see it.
Yes, the forward slash was wrong, changed it to backword slash, working GREAT.
As Dieter(mike miers/SNL) said, "Im as happy as a little girl!!"

Hwy, when working an issue like this , should i update my original message or always post new requests ?

Fantastic, Thanks Imar

on to the next step....true deployment...
Reply With Quote
  #30 (permalink)  
Old August 9th, 2012, 09:38 AM
Imar's Avatar
Wrox Author
Points: 71,768, Level: 100
Points: 71,768, Level: 100 Points: 71,768, Level: 100 Points: 71,768, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,033
Thanks: 80
Thanked 1,582 Times in 1,559 Posts
Default

Glad to hear it's working.

I think posting a new message is best. I am subscribed to this forum so I get notifications by e-mail of new posts, and I am sure others here do that too. Updates to existing posts may go unnoticed as no mail is sent out.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
EDGY (August 9th, 2012)
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft SQL Server Management Studio (2008) Question Bill_Thompson SQL Server 2008 3 October 14th, 2010 03:56 AM
Microsoft SQL Server Management Studio Project p177 fh84 BOOK: ASP.NET MVC Website Programming Problem Design Solution ISBN: 9780470410950 1 July 6th, 2010 07:15 AM
SQL Server Management Studio Error! everest SQL Server 2005 0 August 14th, 2008 12:13 PM
attach database in SQL server express manag studio bruhnf SQL Server 2005 0 March 14th, 2006 07:37 AM
Chp10, 11 sql server express management studio bruhnf BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 March 13th, 2006 04:00 PM



All times are GMT -4. The time now is 10:09 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.