|
 |
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>".
|
|
 |