February 12, 2010 at 9:09 am
I have just installed MS SQL server 2005 express on my computer, at some point while installing , i chose to use windows authentication which does not require any passwords. the installation went on fine to completion. But my problem is that i have a program that relies on the MS SQL server for its databse server. when i run the program, it prompts me to enter the following details:
Database Server
Database NAme
Database user and
Database password.
I have no information where to get all that, i tried to create a new user for the database associated with the program but it wont let me in using the details. where am i going wrong in this? Because the programs manual does not mention anything about creating database user before login, it only says you get the username and password from the system administrator. The program am trying to install can be found from this link school management system. Please help me coz i cant get through the manufacturer of the system although my knowledge in MS SQL is very limited or better HOW CAN I CREATE A DATABASE USER AND PASSWORD FOR LOGIN. Regards
February 13, 2010 at 1:51 am
Did you also download/install Management Studio? If you did you can run this, connect to the Express instance using Windows authentication, right-click on the instance and change the properties to change the authentication mode of the instance. Once you've done that you can right-click on security and create a new sql login and also create a new database.
You can also do it via command line but I'd recommend you use Management Studio.
February 13, 2010 at 3:02 am
i have installed something called microsoft SQL Server Management Studio. Is it what u r refering to ? I cant locate anything like security option. please help
February 13, 2010 at 3:11 am
if you are comfortable, we can use Teamviewer program to view my desktop and configure the sql server for me while i watch. please confirm these through my email mrkiumbe@gmail.com. regards
February 13, 2010 at 4:21 am
Start SQL Server Management Studio. In the login box enter your desktop/server name and select Windows Authentication - this should connect to your instance. In the Object Explorer pane, right-click on the instance and select properties. In there go to Security and change it to "SQL Server and Windows Authentication mode". Then you need to restart SQL Server, reconnect, create a new database in the Database folder in Object Explorer and then add the login in the Security folder in Object Explorer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply