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
 Why users folder does not show any of my users?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

itsmiles
Starting Member

USA
25 Posts

Posted - 18 October 2009 :  20:55:15  Show Profile
Hi,

I connected to my DB using MS Studio Management Express.

In the users folder I only have Snitz users: 1) dbo, guest, information_schema, and sys.

20 users of my forum are not there. Am I looking in the right folder.

cheers,
itsmiles

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 19 October 2009 :  03:37:14  Show Profile  Visit HuwR's Homepage
no, your users are in the members table of the forum db, they are not users of your sql server
Go to Top of Page

itsmiles
Starting Member

USA
25 Posts

Posted - 23 October 2009 :  15:01:10  Show Profile
hi,

can not find members tables.

Have looked thru:

Sys db -> Master -> Tables
Sys Functions -> Table Value Function

Went thur 4 times thru every folder in the file menue.

Don't know where they are hidding.

cheers
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 23 October 2009 :  15:29:27  Show Profile  Visit AnonJr's Homepage
The table is located in the same database as the rest of your forum - your forum members are NOT part of your SQL Server
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 23 October 2009 :  18:32:39  Show Profile  Send ruirib a Yahoo! Message
With so many doubts about what is what, I really wouldn't advise you to mess with the database - and this means no disrespect, but you run the risk of messing with something you will maybe regret.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

itsmiles
Starting Member

USA
25 Posts

Posted - 29 June 2010 :  17:13:11  Show Profile
My user db folder is located not in www/ folder of my web site, but on my MS SQL db server.

I can log into my db using Studio Exress, But still Can Find My Forum Members in table forum, so I can Back them.

Went TO:

1. Sys db -> Master -> Table

2. MSDB -> Table


Don't see any more Tables????

Where Do I Need To Look?
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 29 June 2010 :  19:53:14  Show Profile  Visit AnonJr's Homepage
Did you run setup.asp and actually create the tables?
Go to Top of Page

itsmiles
Starting Member

USA
25 Posts

Posted - 04 July 2010 :  20:28:06  Show Profile
Yes I created several users myself.

Found the db name of my MS SQL provider. Logged in the db using MS SQL Studio Client.

Open db folder of my SQL db server. Did not find the users whom I registered.

Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 05 July 2010 :  01:02:38  Show Profile  Visit AnonJr's Homepage
As Huw mentioned at the start - Forum members are not part of your SQL Server setup. They are in the members table in your forum's database.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 05 July 2010 :  02:28:51  Show Profile  Visit HuwR's Homepage
what name did you give for your SQL database ? the members table will be in the forum database it will not be in master or MSDB

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

itsmiles
Starting Member

USA
25 Posts

Posted - 05 July 2010 :  11:50:47  Show Profile
db MS SQL was given a name of my website

I think this is my problem

db name with my provider is --> 801167_default

Which is in Control Panel of MS SQL of my provider.

Cheers,
Dreamweaver101.1

P.S. In 801167_default I did NOT find any of my created users
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07