Web Wiz Support and Community Forums : SQL Server version install https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 06:52:31 +0000 Thu, 25 Jan 2007 04:28:48 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22500 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server version install : (for anyone else having problems...]]> https://forums.webwiz.net/sql-server-version-install_topic22500_post119803.html#119803 Author: MadDog
Subject: 22500
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.
]]> Thu, 25 Jan 2007 04:28:48 +0000 https://forums.webwiz.net/sql-server-version-install_topic22500_post119803.html#119803 <![CDATA[SQL Server version install : you can also use servername/SQL...]]> https://forums.webwiz.net/sql-server-version-install_topic22500_post119786.html#119786 Author: dj air
Subject: 22500
Posted: 24 January 2007 at 1:18pm

you can also use
 
servername/SQL Instance
 
as the SQL server path
]]> Wed, 24 Jan 2007 13:18:14 +0000 https://forums.webwiz.net/sql-server-version-install_topic22500_post119786.html#119786 <![CDATA[SQL Server version install : I have it sorted now apparently...]]> https://forums.webwiz.net/sql-server-version-install_topic22500_post119785.html#119785 Author: mark-scott
Subject: 22500
Posted: 24 January 2007 at 1:06pm

Embarrassed 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.
]]> Wed, 24 Jan 2007 13:06:53 +0000 https://forums.webwiz.net/sql-server-version-install_topic22500_post119785.html#119785 <![CDATA[SQL Server version install : This might help (try the last...]]> https://forums.webwiz.net/sql-server-version-install_topic22500_post119780.html#119780 Author: iSec
Subject: 22500
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]]> Wed, 24 Jan 2007 11:56:03 +0000 https://forums.webwiz.net/sql-server-version-install_topic22500_post119780.html#119780 <![CDATA[SQL Server version install : Replace 127.0.0.1 with localhost...]]> https://forums.webwiz.net/sql-server-version-install_topic22500_post119779.html#119779 Author: iSec
Subject: 22500
Posted: 24 January 2007 at 11:53am

Replace 127.0.0.1 with localhost ... see if it works.

]]> Wed, 24 Jan 2007 11:53:17 +0000 https://forums.webwiz.net/sql-server-version-install_topic22500_post119779.html#119779 <![CDATA[SQL Server version install : I am testing a new version on...]]> https://forums.webwiz.net/sql-server-version-install_topic22500_post119778.html#119778 Author: mark-scott
Subject: 22500
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? 
]]> Wed, 24 Jan 2007 11:43:13 +0000 https://forums.webwiz.net/sql-server-version-install_topic22500_post119778.html#119778