Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio 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
 
 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old August 18th, 2010, 07:50 AM
Authorized User
 
Join Date: Jul 2010
Posts: 27
Thanks: 2
Thanked 0 Times in 0 Posts
Default

HTML Code:
The user ID in the connection string is a SQL Server user, defined in SQL Server with access to your database. It's not related to any of the records in one of your tables.
Does this means that is using SQl Server authentication?

if so the authentication mode is set to windows.

can that be possible?

regards

Matt
  #12 (permalink)  
Old August 18th, 2010, 08:12 AM
Imar's Avatar
Wrox Author
Points: 72,045, Level: 100
Points: 72,045, Level: 100 Points: 72,045, Level: 100 Points: 72,045, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,083
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Quote:
Does this means that is using SQl Server authentication?
With the connection string you posted: yes. However, it's possible that code in the application takes it apart and uses it for different purposes.

Quote:
if so the authentication mode is set to windows.

can that be possible?
No. You need mixed mode to use SQL Authentication.

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!
The Following User Says Thank You to Imar For This Useful Post:
MattHoff (August 18th, 2010)
  #13 (permalink)  
Old August 18th, 2010, 08:31 AM
Authorized User
 
Join Date: Jul 2010
Posts: 27
Thanks: 2
Thanked 0 Times in 0 Posts
Default

One more thing is not clear

in the original connection string there is the following:

Code:
<add name="LocalSqlServer" connectionString="Data Source=ADEVELOPMENT\SQLEXPRESS;Initial Catalog=PTOPersonalization;User ID=V2Application;Password=wrox" providerName=""/>
The initial Catalog PTOPersonalization does not exist in the book code and is not mentioned in the book.

What do you think about this?

The machine configuration file has the LocalSqlServer connection string as follow

<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspn etdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>

Shall i put in the web.config file the original database instead of Initial PTOPersonalization or shall i remove from the machine configuration file and the web.config file the SQLServer connection string?

The reason i am asking this is because i want to add a role in the Authorization Rules of IIS and associate this with V2Application but it does not allow me to do so when i remove the LocalSqlServer connection string from the configuration file with initial catalog as PTOpersonalization which does not exist aniway and is not mentioned in the book.

Am i on the right direction in adding a role in the IIS Authorization rules to the V2Application?

Hope is clear
  #14 (permalink)  
Old August 18th, 2010, 09:01 AM
Imar's Avatar
Wrox Author
Points: 72,045, Level: 100
Points: 72,045, Level: 100 Points: 72,045, Level: 100 Points: 72,045, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,083
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

I don't know because I don't have the book so I don't know how this is supposed to work.

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!
  #15 (permalink)  
Old August 18th, 2010, 09:20 AM
Authorized User
 
Join Date: Jul 2010
Posts: 27
Thanks: 2
Thanked 0 Times in 0 Posts
Default

However thanks for the support
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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




All times are GMT -4. The time now is 02:47 AM.


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