SQL Server version install
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=22500
Printed Date: 08 April 2026 at 6:51am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server version install
Posted By: mark-scott
Subject: SQL Server version install
Date Posted: 24 January 2007 at 11:43am
|
I am testing a new version on my own workstation: Windows XPsp2 with IIS / ASP and SQL 2005 Express edition.
I have created the blank database called Forum, SQL 2005 is in mixed mode authentication. the relevent part of database_connection.asp is:
strSQLServerName = "127.0.0.1" 'Holds the name of the SQL Server (This is the
name/location or IP address of the SQL Server)
strSQLDBUserName = "sa" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "xxxxxxxx" 'Holds the password (for SQL Server Authentication) strSQLDBName = "Forum" 'Holds the name of the database However, when I run mssql_server_setup.asp and re-enter the same details on the page it comes back with cannot connect.
I have changed servername to the DNS name of my PC and also the IP but it still comes back with the error. I even tried appending SQLEXPRESS to the end (as shown in the management studio) but I cannot seem to connect.
Any ideas?
|
Replies:
Posted By: iSec
Date Posted: 24 January 2007 at 11:53am
|
Replace 127.0.0.1 with localhost ... see if it works. |
Posted By: iSec
Date Posted: 24 January 2007 at 11:56am
| This might help (try the last reply): http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=286281&SiteID=1 - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=286281&SiteID=1 |
Posted By: mark-scott
Date Posted: 24 January 2007 at 1:06pm
 I have it sorted now apparently my SA account was disabled - the microscopic red arrow at the bottom which I failed to notice. I logged in as SA then the error box came back as disabled.
Re-enabled the SA account and it has now populated the database.
Thanks for your help.
|
Posted By: dj air
Date Posted: 24 January 2007 at 1:18pm
|
you can also use
servername/SQL Instance
as the SQL server path
|
Posted By: MadDog
Date Posted: 25 January 2007 at 4:28am
|
(for anyone else having problems connection) for SQL Express use ".\SQLExpress" for the server name. This is a default server name when you install it. ------------- http://www.iportalx.net" rel="nofollow"> 
|