hermor
asked on
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!
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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-6b vpxyztoq/p ortNumber= 1433/datab ase=myData baseName/a sciiString Parameters =false
Using Oracle 10g:
jdbc:oracle:thin:@your-6bv pxyztoq:15 21:myDatab aseName
Thanks!
Using MS SQL: jdbc:JSQLConnect://your-6b
Using Oracle 10g:
jdbc:oracle:thin:@your-6bv
Thanks!
>Using Oracle 10g:
jdbc:oracle:thin:@your-6bv pxyztoq:15 21:myDatab aseName
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.
jdbc:oracle:thin:@your-6bv
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.
ASKER
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.
what login are you connecting with?
what exact message do you get?
how exactly are you trying to create the user?
what exact message do you get?
how exactly are you trying to create the user?
ASKER
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!
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!