SQL Server does not exist or access denied
From: Ira W (irawald_at_hotmail.com)
Date: 08/28/03
- Next message: Michel Gallant: "Re: Simple Encryption"
- Previous message: Tim: "Simple Encryption"
- Next in thread: Chris Jackson: "Re: SQL Server does not exist or access denied"
- Reply: Chris Jackson: "Re: SQL Server does not exist or access denied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 28 Aug 2003 09:53:39 -0700
System worked great on development computer (IIS and SQL
on the same machine).
Will not work in production environment (IIS and SQL on
separate
computers): "SQL Server does not exist or access denied."
I know that this has been discussed many times. I believe
I tried most of the suggestions - but I still can not get
to SQL Server. I have spent so many hours trying to make
this work. Ultra frustration.
ON the IIS computer:
* User/password is defined on the computer for use by the
application.
* Directory permissions set to permit access
- Temp folder set to read/write/delete
- winnt\microsoft.net\framework set to read only
- winnt\microsoft.net\framework\version\temporary asp.net
files set to read/write/delete
* In IIS:
- Application installed in a virtual directory.
- IIS is set for anonymous access w/user and password
defined.
* Root of virtual directory contains web.config.
- All access for database uses a connection string as
follows:
integrated security=SSPI;data source=computer;persist
security
info=False;initial
catalog=database;uid=user;pwd=password;
- Authentication set as forms based
* In machine.config
- <processModel .. userName="user"
password="password" ... />
On the sql server computer:
* exact same user/password is validated
* SQL server references the user.
* Database references the user.
* Permissions are set for relevant tables and procedures.
- Next message: Michel Gallant: "Re: Simple Encryption"
- Previous message: Tim: "Simple Encryption"
- Next in thread: Chris Jackson: "Re: SQL Server does not exist or access denied"
- Reply: Chris Jackson: "Re: SQL Server does not exist or access denied"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
