Still Hard time. I dont understand why it is so difficult to connect to a great database like sql server.
It is so simple using MS Access but till date I was never able to connect to sql server.
I have used Integrated authentication. And steps followed are as listed below using SQL Server Express Edition 2005 Advanced. I have created Database using Management Studio.
I do not know the password of sa to try above steps. Also may know how to enable SQL Server Authentication?
The steps I followed:
strSQLServerName = "localhost\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "forumuser" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "1forum" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "forums" 'Holds the name of the database
- I have created a empty database called forums.
- I have created a new user under security folder in SQL Server Express 2005 called "forumuser".
The password I gave is 1forum
Now I right clicked on the empty database "forumuser" and went to properties.
In properties I selected user mapping. Here I checked option for forums database.
Pressed OK
Now in msSQL_server_setup.asp page:
I selected user name: forumuser
password: 1forum
Now pressed Submit.
But it did not work !!!
Thanks for helping me.
Please do the needful.
Edited by jaimalleshk - 31 March 2007 at 2:30pm