I have been running the access version without any problems but only because I haven't been able to get the SQL version connected to create the tables. Here what I've done so far per your previous post:
- Installed SQLExpress in mixed mode, TCP/IP connections have been enabled via connection mgr.
- Connected to SQL's default instance logging in with SQL Server Authentication using the "sa" account and password I created during install.
- This account is also the db owner for the blank database I have created called "test_db" and has premissions for "db creator" applied.
- When I try and connect using the "msSQL_server_setup.asp" file and I enter my credentials I am constantly receiving the errors shown below.
--------------------------------------------------------------------------------------------
Here's what my database_connection.asp file looks like:
strSQLServerName = "localhost\SQLEXPRESS" '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 = "*******" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "test_db" 'Holds the name of the database
Note: The "sa" account has db creator roles assigned. I have also created another account and assigned it with these permissions, made the changes to the database_connection .asp file to reflect these changes and then tried logging in again with the new account from the "msSQL_server_setup.asp" page but still to no avail. I feel as though I've tried every combination of logging in. Obviously there's something I'm doing wrong so if anyone can identify that from what I've just explained then I woudl greatly appreciate it.
-------------------------------------------------------------------
Here's what I get when I try and connect:
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.
Thanks for any help folks,
Craig
Topic Options
Post Options
Thanks(0)
