Web Wiz Forums - Starting up

Print Page | Close Window

Starting up

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19465
Printed Date: 12 April 2026 at 4:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Starting up

Posted By: Wimley
Subject: Starting up
Date Posted: 21 April 2006 at 2:40am

Hi,

I'm trying to set up a forum for the first time.

I'm using the SQL Server 2005 Version.

I can't get logged into the SQL Server on the first page of the msSQL_server_server.asp file to set up the empty database that I have created.

I log into the server with Windows authentication.

Where do I find the correct username(s) to use in the database_connection.asp & msSQL_server_server.asp files ???

Any help appreciated, can't wait to set up this forum...

Thanks,

Wim

-------------
Wim Conix
www.image-belle.com

Replies:

Posted By: WebWiz-Bruce
Date Posted: 21 April 2006 at 10:54am

You need to change the setup of your SQL Server to 'mixed connections' so that it can be logged into via TCP/IP.

ASP needs to use TCP/IP to log into the SQL Server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Wimley
Date Posted: 21 April 2006 at 1:16pm

Hi,

Thanks for your answer, but I'm still not getting logged in.

I changed authentication mode to mixed as you suggested, and am trying to login with SQL Authentication, but it seems I'm using wrong username. Is there a predefined username to use ? Or do I have to create a user somewhere ?

Server name = WIMLEY\WIMLEY

Username = WIMLEY\Wim

Password = xxxxxx

This doesn't work in SQL Authentication, however this is what's used by Windows Authentication (I guess).

Is it possible that you send me an empty .bak database, which I can restore ? So I can get started. All my other ASP-applications are working well with Windows Authentication.

Many thanks and regards,

Wim

-------------
Wim Conix
www.image-belle.com

Posted By: WebWiz-Bruce
Date Posted: 21 April 2006 at 1:28pm

The setup file uses the same connection as the main forum, so if the setup file doesn't work nor will the forum.

The connection string is in the database_connection.asp file, update that file to match the connection string in your other ASP aplications

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Wimley
Date Posted: 21 April 2006 at 1:42pm

Hi,

Unfortunately I always work with DSN connections like

MM_conn_fotodat_STRING = "dsn=PhotoWIM;"

DSN with Windows Authentication

Is there a possibility to use a DSN for the forum too ?

Greets,

Wim

-------------
Wim Conix
www.image-belle.com

Posted By: WebWiz-Bruce
Date Posted: 21 April 2006 at 2:25pm

The problem with DSN connections is that they are slow and often course other issues when used with ADO.

If you can use a DSN connection then usually there is no problem with using a DSN-less connection to the database that web wiz forums uses.

If the SQL Server is on the same server as the web host and you have the server adminstrator account enabled in SQL Server I often use the follwoing login details:-

SQL Server = localhost
Username = sa
Pass = your SQL Servers password
Database Name = the name of a database already setup on the SQL server

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Wimley
Date Posted: 21 April 2006 at 4:11pm

Thanks, I finally managed to get the connection working.

I think I'm gonna change all my connections to DSN less in the future.

Wim

-------------
Wim Conix
www.image-belle.com