| Author |
 Topic  |
|
webby4x4
Starting Member
44 Posts |
 Posted - 24 May 2008 : 14:51:20
|
OK... here's a link to a page that shows the permissions. http://4x4review.com/test.asp
Thanks again... I REALLLLLY appreciate the help!
Rick< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 15:09:35
|
Schema for the forum tables is "rwebster". So I'm starting to understand this now...  .
Just to make sure I'm doing this right, would you mind telling me what to do next?
Rick< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 15:16:43
|
Sorry for being ignorant, but the "schema" deal is really new to me.
What is it that I'm supposed to "set"?
Again, sorry for my ignorance!
RW< |
Edited by - webby4x4 on 24 May 2008 15:17:34 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 May 2008 : 15:23:21
|
| You will need to right click the user in the security folder for the server, choose properties and then get to the screen where you can set the default schema. It's shown on the right side of the screen, when you choose the 2nd option at the left (which I can't remember the name).< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 15:32:27
|
Found it. I've tried setting the default schema to "rwebster" (I even tried dbo, and db_owner), but I keep getting this error in SQL:
"user, group or role 'rwebster' already exists in the current database". <-- no kidding. ;)
I feel like a real idiot (which you're probably agreeing with me, at this point). I'm sorry for being so dense about this.
Rick< |
Edited by - webby4x4 on 24 May 2008 15:36:15 |
|
|
|
webby4x4
Starting Member
44 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 May 2008 : 15:47:51
|
| Ok, seems like the default schema is already rwebster, so either the info you gave is not correct, or I'm missing something... Can you email me the SQL Server access data so that I can login and have a look?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 16:29:18
|
Rui - you're the best!!!
Just so everyone knows... The fix to this was to set the forum table's schema to dbo. That fixed it, and Rui is awesome!
thanks everyone - you guys have always been most helpful.
Rick< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
