Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Evaluation
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Evaluation
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Topic: SQL Evaluation
    Posted: 04 June 2003 at 6:58am
Hi guys, ive downloaded the SQL evaluation copy, can anyone please tell me how to creat backups or not let it overwrite anything in my IIS because I only want it temporarialy and last time i did it IIS stopped working with access!
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: 04 June 2003 at 7:22am

I've never known SQL server to effect anything to do with IIS.

It could be that it is installing the latest ODBC drivers, if it is then these no-longer support Access 97 and you may need to change your access databases to Access 2000 or 2002
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 7:40am
ok thanks ill risk it, i can always reinstall iis anyways
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: 04 June 2003 at 8:35am
If Access fails to run after then it sounds more like  a database driver problem, so I would try reinstalling the MDAC drivers from www.microsoft.com/data
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 9:02am

im having trouble connecting to the SQL database.... (with webwiz forum)

i created a new database called Forum

i look in properties my server name is TOM

i enter these two details in the sql server connection file

i run sql server setup.asp and it keeps saying my details are wrong, what username should i be using?

 
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 04 June 2003 at 9:23am
By default SQL server installs with Windows Authentication only. For that to work with the forum you would have to use a different connection string. It would be easier to go into the properties of the server and change it to mixed mode, then you can connect with sa and the password you chose for it. Click here to see where
Blog | MPG Tracker
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 05 June 2003 at 12:44pm

ok i set security to how its shown in the pic......

What username and password do I enter for

/msSQL_server_setup.asp

Thanks for your help
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 06 June 2003 at 9:16am
try Username:sa Password:______ (being it blank) This is the default I think if you switch. You can always change the sa password going to the security control in Enterprise Manager.
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply Page  12>

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.