SQL Server Authentication

Hey,

I need a little assistance with the SQL Server set up.  I have read the instructions numerous times and have a fair understanding of MS SQL Server but still "No Joy".  

Off the topic.... Can the Access version be Up-Sized to SQL Server?  Looking at the code the big difference is the connection details.  Is this a true or mostly true statement?

 

Any help would be greatly appreciated!

Thanks,

Snosi

Hello,

 

Yes I believe I have entered the correct details in SQL_server_connection.asp

servername "local"

DBUserName "sa"

PassWord "PassWord"

DatabaseName "MyForum"

I am recieving the standard error message when connection fails. 

" Error Connecting to database on SQL server.  Check the following is correct: Name of SQL Server, Database name, and the details in SQL_server_connection.asp."

I have multiple other ASP applications running with a SQL back end but this one has me stumped. 

I am sure it is an error on my end that I just over looked.

That happens when the SQL Server is configures on Windows Authentication only, either change it to mixed mode in the Server Properties if you have Enterprise Manager, or you can do it directly in the Registry > Open regedit and navigate to >
HKLM>Software>Microsoft>MSSQLSERVER>MSSQLSERVER& gt; and change the Login Mode Value to 2 (restart service after that)

Alternatively you can add the ASP user to the database using SQL Script which may be risky if you don't do it right.

No reponsibility if you f up your Registry