Snitz Forums 2000 - Connecting to MSSQL2K problems....

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MS SQL Server

Connecting to MSSQL2K problems....

New Topic

Topic Locked

Printer Friendly

Author

Topic

gecko5
Starting Member

4 Posts

Posted - 16 August 2002 : 23:15:33

Hi All,

I have setup a network at home with 4 boxes. One is dedicated as the
"Server" and is running IIS and MS SQL server. I am in the process of
builing a web site with dynamic content as a learning tool and one of the
functions i want to implement is a forum board. The tool i will be using
for this is of course SNITZ.

My network is setup on a workgroup called "river"
Server is called "Server"
Dev Box is called "BBox"
Other1 is called "Games"
Other2 is called "Spare"

All boxes are assigned IP's (192.168.1.X) and can share back and forth.
Since this is a closed network from the internet, i am not worried about
security at this time.

I have created a blank database in MS SQL through EM called say "db1"
I have set up in the config file

strDBType = "sqlserver"
strConnString = "driver={SQL
Server};server=Server;uid=tim;pwd=;database=db1" '## MS SQL Server
6.x/7.x/2000 (ODBC connection)

The problem is that i know i have to set up something within ODBC, but this is where i am at a loss.

I have created a user called tim, but am not sure if it is done in the right spot and whether it has the proper permissions.

I go to http://server/gecko5/forum/Setup.asp?RC=5

Where i am prompted to select the type of SQL db and to enter a username and password. I enter tim as the username and nothing as the password and i then get an error

++++++++++++++++++++++++
The database could not be opened !!

Code : 80040E4D
++++++++++++++++++++++++

- What do i have to do in the ODBC settings to get this to work? Is it done
on the server? or on the Dev box? (I am thinking on the server, but just
wanted to confirm)
- Do i have to create a user to access the DB in EM? If not what is the
default username and password that i can use that will allow any user full
access to the db?
- In strConnString = "driver={SQL
Server};server=Server;uid=sa;pwd=sa;database=db1", will pointing to Server
alone get me the access i need, or do i have to specify IP, etc...?

Any help on this would be greatly appreciated :)

TIA,

Tim

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 August 2002 : 00:05:55

Do you have your SQL Server configured to accept SQL Server authentication? After you do this, you need to create a login that will use SQL Server Authentication, and then create a user associated with this login, for your database.

To make it easy for table creation, you can assign dbowner role for this user.
With these settings, your connection should work.

Snitz 3.4 Readme | Like the support? Support Snitz too

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 17 August 2002 : 00:11:39

You dont have to setup anything in ODBC, usually this would be done if you are wanting to use a DSN connection.

I would strongly suggest you use the OLEDB connection instead which would look like this

strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;"

Within EM you should create a new user and give him access to your forum db, give him 'owner' rights. This is then the userid and password you should use on the connection string, and the one you'll provide when running setup.asp?rc=5

Kiwihosting.Net - The Forum Hosting Specialists

Edited by - Gremlin on 17 August 2002 00:12:29

gecko5
Starting Member

4 Posts

Posted - 17 August 2002 : 07:15:01

quote:
Originally posted by ruirib

Do you have your SQL Server configured to accept SQL Server authentication?

Is this done under properties for the SQL server under the security tab? It seems to be assigned to windows only? I change it to SQL and windows, but when i say OK and then go back, it reverts back to Windows only???

After you do this, you need to create a login that will use SQL Server Authentication, and then create a user associated with this login, for your database.

I have done this, created a user called tim using SQL server authentication. Assigned him dbowner role and assigned him to the created database "gecko5".
username = tim / password = tim
To make it easy for table creation, you can assign dbowner role for this user.
With these settings, your connection should work.

I wish it did, but i am getting the error

++++++++++++++++++
The database could not be opened !!

Code : 80004005
++++++++++++++++++

I have tried both strings

'strConnString = "Provider=SQLOLEDB;Data Source=Server;database=gecko5;uid=tim;pwd=;tim" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strConnString = "driver={SQL Server};server=Server;uid=tim;pwd=tim;database=gecko5" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)

as well as

'strConnString = "Provider=SQLOLEDB;Data Source=192.168.1.3;database=gecko5;uid=tim;pwd=;tim" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strConnString = "driver={SQL Server};server=192.168.1.3;uid=tim;pwd=tim;database=gecko5" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)

with the same results....

ARGHHHHHHH!!!!

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 17 August 2002 : 07:20:21

try "localhost" as the server name instead, or maybe putting the port number in there too ie 192.168.1.3,1443

failing that I'm afraid I don't have any other ideas right now, I've encoutered similar to this problems myself but its usually been becuase I hadn't assigned the user to the DB.

Kiwihosting.Net - The Forum Hosting Specialists

Edited by - Gremlin on 17 August 2002 07:20:48

Doug G
Support Moderator

USA
6493 Posts

Posted - 17 August 2002 : 13:46:39

The syntax for username and password is different in an OLEDB string, I don't know if the ODBC syntax works but try

'strConnString = "Provider=SQLOLEDB;Data Source=192.168.1.3;database=gecko5;User ID=tim;Password=;tim" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)

Don't forget to remove the beginning apostrophe to "uncomment" the line, and make sure only one connection string line is uncommented. Also, I think the semicolon before tim in the password setting should be after the password.

======
Doug G
======
Computer history and help at www.dougscode.com

gecko5
Starting Member

4 Posts

Posted - 19 August 2002 : 21:32:31

Hi all,

Well i have tried everything suggested here to no avail. Anybody else suggest something else to trouble shoot?

I am at my wits end on this and would really like to implement a SNITZ forum on my site,