SQL Express setup - can't even get past the setup!
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=22709
Printed Date: 08 April 2026 at 3:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Express setup - can't even get past the setup!
Posted By: stevejebson
Subject: SQL Express setup - can't even get past the setup!
Date Posted: 16 February 2007 at 8:20pm
Apologies but i'm a real beginner here....
I'm running SQL Server Express and i've created a blank database TestDB
when I fire up SQL Server Express the "Server Name" is TREVOR\SQLEXPRESS the Windows Authentication is set and there's no password.
in the database_connection.asp file i have the following settings...
strSQLServerName = "TREVOR\SQLEXPRESS"
strSQLDBUserName = "TREVOR\Development1"
strSQLDBPassword = ""
strSQLDBName = "TestDB"
and when i load up the msSQL_server_setup.asp page i'm entering...
SQL Server Username: Development1
SQL Server Password:
SQL Server Username for creating tables: DBO
but i'm getting the Error Connecting to database on SQL Server
any ideas ?
tia
Steve
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 17 February 2007 at 8:59am
You can't use Windows authentication for this connection.
You need to ensure that you have installed SQL Server Express in mixed mode with TCP/IP connections enabled.
By default SQL Express doesn't allow remote connections, so if you are not using it on a localhost you should search Google for some articles on enabling remote connections for SQL Express.
With SQL Server Express running as a localhost you need to enter the following:-
strSQLServerName = "localhost\SQLEXPRESS"
For the rest of the settings you need top have created a blank database on SQL Server Express and then also create a user giving that user DBO rights (Database Owner) on the database you have just created.
You then need to fill in your other details in your database connections file giving the database name, username, and password you have just created on the SQL Server.
-------------
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: dank
Date Posted: 17 February 2007 at 4:13pm
Another question regarding installation.İs it posibble to run forum on my own machine?I've installed IIS,MySql,created empty database, changed database_connection.asp file as follows strSQLServerName = "localhost" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "root" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "***" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "webwiz" 'Holds the name of the database
but get the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Table 'webwiz.tbldatetimeformat' doesn't exist
/web/forum/forum/functions/functions_date_time_format.asp,
What should i do ?Thank you.
|
Posted By: WebWiz-Bruce
Date Posted: 18 February 2007 at 3:41pm
Dank this topic is about SQL Express, your post appears to be about mySQL, a completly different topic. If this is the case please start a new topic.
-------------
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
|
|