Web Wiz Support and Community Forums : Starting up https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 02:23:52 +0000 Fri, 21 Apr 2006 16:11:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19465 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Starting up : Thanks, I finally managed to get...]]> https://forums.webwiz.net/starting-up_topic19465_post105180.html#105180 Author: Wimley
Subject: 19465
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
]]> Fri, 21 Apr 2006 16:11:49 +0000 https://forums.webwiz.net/starting-up_topic19465_post105180.html#105180 <![CDATA[Starting up : The problem with DSN connections...]]> https://forums.webwiz.net/starting-up_topic19465_post105170.html#105170 Author: WebWiz-Bruce
Subject: 19465
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



Edited by -boRg- - 21 April 2006 at 2:26pm]]> Fri, 21 Apr 2006 14:25:50 +0000 https://forums.webwiz.net/starting-up_topic19465_post105170.html#105170 <![CDATA[Starting up : Hi, Unfortunately I always...]]> https://forums.webwiz.net/starting-up_topic19465_post105167.html#105167 Author: Wimley
Subject: 19465
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
]]> Fri, 21 Apr 2006 13:42:28 +0000 https://forums.webwiz.net/starting-up_topic19465_post105167.html#105167 <![CDATA[Starting up : The setup file uses the same connection...]]> https://forums.webwiz.net/starting-up_topic19465_post105165.html#105165 Author: WebWiz-Bruce
Subject: 19465
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
]]> Fri, 21 Apr 2006 13:28:02 +0000 https://forums.webwiz.net/starting-up_topic19465_post105165.html#105165 <![CDATA[Starting up : Hi, Thanks for your answer,...]]> https://forums.webwiz.net/starting-up_topic19465_post105160.html#105160 Author: Wimley
Subject: 19465
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
]]> Fri, 21 Apr 2006 13:16:17 +0000 https://forums.webwiz.net/starting-up_topic19465_post105160.html#105160 <![CDATA[Starting up : You need to change the setup of...]]> https://forums.webwiz.net/starting-up_topic19465_post105142.html#105142 Author: WebWiz-Bruce
Subject: 19465
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.
]]> Fri, 21 Apr 2006 10:54:05 +0000 https://forums.webwiz.net/starting-up_topic19465_post105142.html#105142 <![CDATA[Starting up : Hi, I&#039;m trying to set...]]> https://forums.webwiz.net/starting-up_topic19465_post105085.html#105085 Author: Wimley
Subject: 19465
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
]]> Fri, 21 Apr 2006 02:40:13 +0000 https://forums.webwiz.net/starting-up_topic19465_post105085.html#105085