| Author |
 Topic Search  Topic Options
|
masson 
Newbie
Joined: 06 May 2003
Location: United States
Status: Offline
Points: 13
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problem Installing Forum..
Posted: 01 May 2009 at 8:39pm |
I'm attempting to install the MS SQL version of the forum, but am getting an error upon running msSQL_server_setup.asp. I'm using SQL 2005 Express. I've added "webwizforums" to my SQL database.
Here's the error: Error Connecting to database on SQL Server
Check the following is
set up and correct:-
SQL Server User Name
SQL Server Password
Name
of the SQL Server
Database name set up by you on the server
Empty Database
set up by you on the SQL Server
Check also that you have entered the
correct details in the file 'database_connection.asp' found in the 'database'
directory.
Detailed Error Message: [DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.
Error
Details: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied.
database_connection.asp looks like this strSQLServerName = "NT02/SQLEXPRESS" strSQLDBUserName = "administrator" strSQLDBPassword = "password" strSQLDBName = "webwizforums"
I've also tried strSQLServerName = "192.168.1.3"
Any ideas? Thanks! |
 |
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 May 2009 at 12:39pm |
|
I'm not sure if I am reading this right but you need a blank database, so delete the database you have done, unless of course you have something else on it, then start again and setup a new one
Procedure is to setup a new blank database on your server in which case you choose your username and password, and database name (which you can call that anything you want normally - it could be a mixture of letters, numbers but with no spaces)
Be sure that you have the correct details such as your server name, then you should transfer this information into your database_connection.asp file
Upload the files and then run the msSql_server_setup.asp file again and input the correct information
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 May 2009 at 3:06pm |
|
By default SQL Server Express only allows local trusted connections.
To be able to talk to the database from ASP (which web wiz forums is written in), you need to install SQL Server in mixed mode with TCP/IP connections enabled.
If the SQL Server resides on another machine then you also need to allow remote connections to the SQL Server.
|
|
|
|
masson
Newbie
Joined: 06 May 2003
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 May 2009 at 4:39pm |
I did not install the forum in muli-mode, so I re-installed it in multi-mode and enabled TCP-IP. But still I'm getting the same message.
Do I need to install using a windows username or one local to the SQL Server? I created a couple local to the sql server, gave them access to the database, but still no luck. I've tried every combination I can think of. When I login with a windows username, should it be domain name/username or username@domainname.com or just the username? Again I've tried all of the combinations I can think of and nothing.
I also made sure to add my windows users as role: sysadmin, and mapped the user to the db as well.
My current database_connection.asp looks like: strSQLServerName = "192.168.1.3" strSQLDBUserName = "ADVLASER/admin" strSQLDBPassword = "password" ' I am using the right password strSQLDBName = "webwizforumsomear" ' changed the name when I created a new one
Any help would be great. I'm new to sql server. I'm sure it will be great once I get it working. |
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 May 2009 at 5:05pm |
|
You need to use an SQL Server user to login, not a windows account.
Create a new SQL Server user in SQL Server using SQL login not windows authentication. Then give that user DBO rights over the database.
If you still get stuck please give the exact error message.
|
|
|
|
masson
Newbie
Joined: 06 May 2003
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 May 2009 at 6:48pm |
OK I added another sql local user. On the DBO, do I set this up through the user mappings as here (www.advlaser.net/temp/wiz4.jpg) or is it somewhere else? And should the server role for the user be sys admin? Thanks!
Here's the error message, same as before.. Error Connecting to database on SQL Server
Check the following is
set up and correct:-
SQL Server User Name
SQL Server Password
Name
of the SQL Server
Database name set up by you on the server
Empty Database
set up by you on the SQL Server
Check also that you have entered the
correct details in the file 'database_connection.asp' found in the 'database'
directory.
Detailed Error Message:
[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied.
Error
Details:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or access denied.
|
|
Jono
Mod Builder Group
Joined: 18 September 2006
Location: United Kingdom
Status: Offline
Points: 100
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 May 2009 at 7:44pm |
Hi Masson,
You got your SQL user account to have db_denydatareader and db_denydatawriter, so... you can't read or write to your database... Just have db_owner ticked, untick everything else.
Also you appear to have used forward slashes "/" e.g. ADVLASER/admin - These should be back slashes "\".
Hope this helps.
Edit: Oh, and it shouldn't need the SysAdmin role.
|
|
masson
Newbie
Joined: 06 May 2003
Location: United States
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 04 May 2009 at 8:42pm |
Ok, I've update user to Database owner only checked www.advlaser.net/temp/wiz5.jpg
and I've changed both of them have no roles checked (unchecked sysadmin)
My error is still Error Connecting to database on SQL Server.
Is there a way to get a better error?
|
|
