Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Starting up
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Starting up
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Wimley View Drop Down
Newbie
Newbie
Avatar

Joined: 21 April 2006
Location: Belgium
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Wimley Quote  Post ReplyReply Direct Link To This Post Topic: Starting up
    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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Wimley View Drop Down
Newbie
Newbie
Avatar

Joined: 21 April 2006
Location: Belgium
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Wimley Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Wimley View Drop Down
Newbie
Newbie
Avatar

Joined: 21 April 2006
Location: Belgium
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Wimley Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Wimley View Drop Down
Newbie
Newbie
Avatar

Joined: 21 April 2006
Location: Belgium
Status: Offline
Points: 6 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Wimley Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.