p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

aspdotnet_website_programming thread: Re: Can't connect to SQL server


Message #1 by "Bill Sabey" <mrbillzydeco@y...> on Tue, 25 Feb 2003 15:36:42
I ran into a similar problem. When I setup thePhile database in sqlserver 
(msde) it defaulted to Windows Authentication.  I probably could have gone 
back and added sqlserver authentication (to allow 'sa' login), but instead 
I added the anonymous login as a valid login in sqlserver (using 
enterprise manager) and gave it access to thePhile database.

To find the anonymous login, view properties on the web application 
folder, thePhileVB, under IIS.  On the directory security tab, edit the 
anonymous access.  The user id IUSR_<machine name> is the one to be added 
as a valid login for thePhile database.

I changed the connection string in each of the .config files (in config 
folder) to "Integrated Security=SSPI;Persist Security Info=False;Initial 
Catalog=thePhile;Data Source=<machine name>;Packet Size=4096;Workstation 
ID=<machine name>".
Message #2 by "Saturnius" <saturnius@g...> on Tue, 25 Feb 2003 18:16:37
Hi,
Thank you very much for your help. The problem is solved now.
I downloaded the code again and had to edit the connection string of the 
ThePhile\config\Accounts.Config and other config-files.
Cheers! 

> I ran into a similar problem. When I setup thePhile database in 
sqlserver 
(> msde) it defaulted to Windows Authentication.  I probably could have 
gone 
b> ack and added sqlserver authentication (to allow 'sa' login), but 
instead 
I>  added the anonymous login as a valid login in sqlserver (using 
e> nterprise manager) and gave it access to thePhile database.

> To find the anonymous login, view properties on the web application 
f> older, thePhileVB, under IIS.  On the directory security tab, edit the 
a> nonymous access.  The user id IUSR_<machine name> is the one to be 
added 
a> s a valid login for thePhile database.

> I changed the connection string in each of the .config files (in config 
f> older) to "Integrated Security=SSPI;Persist Security Info=False;Initial 
C> atalog=thePhile;Data Source=<machine name>;Packet Size=4096;Workstation 
I> D=<machine name>".

  Return to Index