Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 SQL 2005, IIS6, authentication questions		  New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 3

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  11:52:09  Show Profile
OK, I'm revisiting this on day two. At present, you're telling me I need to remove IUSR from login rights to my SQL database. I'm going to go do that now.

I removed IUSR from Logins or Roles in SQL 2005 and now I receive an access denied message. IUSR only had connect and view rights in SQL.

I am using trusted connection as my SQL and IIS are on the same server. Here's my connection string:

strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME\FORUM;database=FORUM;uid=bobsmith;pwd=XXXXXX;Trusted_Connection=yes;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)

Here's the message I receive now:

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'bobsmith'.

/inc_header.asp, line 111

This is with IUSR removed from both Logins & Users in SQL.
Edited by - bobsmith on 17 May 2006 12:09:00
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 17 May 2006 :  12:08:11  Show Profile  Visit HuwR's Homepage
remove the trusted_connection=yes

IUSR should not have any right to anything in your database at all period.
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  12:09:50  Show Profile
quote:
Originally posted by HuwR

remove the trusted_connection=yes

IUSR should not have any right to anything in your database at all period.


I have removed trusted connection.

IUSR is gone from logins and users in sql database.

Getting this message now:

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'cliff'.

/inc_header.asp, line 111
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 17 May 2006 :  12:16:32  Show Profile  Visit HuwR's Homepage
is cliff the username in you config.asp and is cliff the user set up for your db in SQL
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  12:18:04  Show Profile
that username is what is in the config.asp and that username is an administratthe server and that user has full rights in SQL.

When I look at the tables created in the database, I do not see any users with rights.
Edited by - bobsmith on 17 May 2006 12:22:28
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 17 May 2006 :  12:20:38  Show Profile  Visit HuwR's Homepage
are you sure that the login details in your config.asp are correct, ie you haven't misspelled the password
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  12:23:23  Show Profile
checked it several times. Read previous post edit though...it does not appear that the user cliff has any permission on the database tables.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 17 May 2006 :  12:25:07  Show Profile  Visit HuwR's Homepage
is your sqlserver publicly accessible ? if so might I suggest that you get someone who knows what they are doing to set it up for you
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  12:25:55  Show Profile
Under permissions for the database, the user cliff has ALL explicit permissions gtranted by the dbo
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  12:26:55  Show Profile
quote:
Originally posted by HuwR

is your sqlserver publicly accessible ? if so might I suggest that you get someone who knows what they are doing to set it up for you


It is. via RDP, etc...
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 17 May 2006 :  12:29:18  Show Profile  Visit HuwR's Homepage
if you want to email me a temp login to your RD I can take a quick look for you if you want. my email is huw at forum.snitz.com
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  12:31:52  Show Profile
e-mailed test to make initial contact.
Go to Top of Page

bobsmith
Starting Member

25 Posts
Posted - 17 May 2006 :  22:18:38  Show Profile
Turns out that I had not created my user in SQL, but was rather trying to use an AD integrated user. Huw helped me fix that.
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07