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?
Topic Options
Post Options
Thanks(0)
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.
