Creating local MS SQL 2005 database

Hi Experts,

I am trying to create a database in a local MS SQL 2005 server, but I am having many problems. Can anyone help me with a step-by-step on how to create a database with the following things I need?

Database host:
Database port: (I think it is 1433 by default)
Database name: ("it must be processDB")
Database user: (I cannot create a user which I want to call "applicant")
Database password: (The same as the username)

I want this database not to use "Windows Authentication".

I have tried searching on the web, but I haven't found what I really need.

Thanks a lot!
hermorAsked:
Who is Participating?
 
dqmqCommented:
Host: you don't need that to create a database
Port: you don't need that either
Name: you already have that
User: you already have that
password:  database users don't have passwords.

"Windows Authentication" is something you specify for the server, not for the database. Furthermore, you cannot turn if off.

Basically, to create a default database, startup SQL Server Management Studio and logon to the server with an account that has the necessary permissions.  From Object Explorer window, right click on "Databases" and choose create New. The wizard will prompt you the rest of the way.   Once the database is created, you can expand "Process DB", right cllick on users and choose create New.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
to create the user in the database, you have FIRST to create the login (sql authentication) => ensure that sql authentication is enabled.
what exact problem(s) do you have?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>"Windows Authentication" is something you specify for the server, not for the database. Furthermore, you cannot turn if off.
just to clarify that:
you cannot turn it of, but as long as you did not define as Windows-Authenticated logins in the server, it is not used!

0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
hermorAuthor Commented:
Ok, the real problem I have is that I am not able to connect to the local database from a third party application. I have tried using MS SQL and Oracle 10g and with both I received errors. For example, "IO Exception: The Network Adapter could not establish the connection. Is there a way to test the address from the command or any other place in Windows?

Using MS SQL: jdbc:JSQLConnect://your-6bvpxyztoq/portNumber=1433/database=myDatabaseName/asciiStringParameters=false

Using Oracle 10g:
jdbc:oracle:thin:@your-6bvpxyztoq:1521:myDatabaseName

Thanks!
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Using Oracle 10g:
jdbc:oracle:thin:@your-6bvpxyztoq:1521:myDatabaseName
you mean, you tried with an oracle driver to connect to that database? that CANNOT work.

in regards to the mssql connection, you might want to check if remote connections are allowed.


0
 
hermorAuthor Commented:
It still not working. Is there a way I can add a user in the database? When I try to do so, I receive a message  saying that I do not have the proper rights to create a user.  
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what login are you connecting with?
what exact message do you get?
how exactly are you trying to create the user?
0
 
hermorAuthor Commented:
Sorry, but maybe I don't have the correct information to provide to you. I will use Oracle for the moment. Thanks to all of you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.