Database Discussion - SQL Evaluation

Print Page | Close Window

SQL Evaluation

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3261
Printed Date: 29 March 2026 at 10:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Evaluation

Posted By: Gullanian
Subject: SQL Evaluation
Date 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!

Replies:

Posted By: WebWiz-Bruce
Date 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

-------------
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: Gullanian
Date Posted: 04 June 2003 at 7:40am

ok thanks ill risk it, i can always reinstall iis anyways

Posted By: WebWiz-Bruce
Date 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 http://www.microsoft.com/data - www.microsoft.com/data

-------------
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: Gullanian
Date 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?

Posted By: michael
Date 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. http://webapp.us/div/mixedmode.jpg - Click here to see where

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date 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

Posted By: michael
Date 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.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 06 June 2003 at 6:02pm

worked like a charm, many thanks!