Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jagguy
Starting Member
27 Posts |
 Posted - 2008-08-18 : 07:34:24
|
| i have create a database in sql server 2005.where do i set the user name and login because i want to connect to it with vb.net?currently i have no user name or password set. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-18 : 07:47:11
|
Two places.1) On the database server security tab.2) In your connection string for .Net.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jagguy
Starting Member
27 Posts |
Posted - 2008-08-18 : 08:05:08
|
| i right-click on security and on the login-new page i fill in passwrd and get an error.I also fill in login and no matter what login or passowrd i type in i get MUST CHANGE option not supportedthis is confusing |
|
|
|
jagguy
Starting Member
27 Posts |
Posted - 2008-08-18 : 08:11:03
|
| ok i set the database and it works but what does enforce password policy do?when i go back into the login page i see the password is 15 characaters long which when i set it was only 4.why? |
|
|
|
jagguy
Starting Member
27 Posts |
Posted - 2008-08-18 : 09:28:11
|
| i want to access the database from vb.net.1)I need to create a password and login. what is the diffeence between user and login?2)when i first connect to SMSE i see the server type disabled why? is this a problem? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-18 : 23:46:58
|
| >> when i go back into the login page i see the password is 15 characaters long which when i set it was only 4.Sql displays it in encrypted format, no matter number of characters you entered.>> I need to create a password and login. what is the diffeence between user and login?Login can connect to sql server while db user has permission to specific db.>> when i first connect to SMSE i see the server type disabled why? is this a problem?Not sure what you mean. |
|
|
|
jagguy
Starting Member
27 Posts |
Posted - 2008-08-19 : 06:56:04
|
| ok where is the password and login I set on my database?I right click on security and see new user but nowhere to enter password? or user?This is very confusing again? |
|
|
|
jagguy
Starting Member
27 Posts |
Posted - 2008-08-19 : 07:08:45
|
| I cant find anything in help or on google .where can i see what login and user and passowrds i have set.Why is this SO hard to get information on! |
|
|
|
jagguy
Starting Member
27 Posts |
Posted - 2008-08-19 : 07:24:38
|
| there are 2 security folders and 1 is for a specific database .what do i do here ? what is the difference? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-20 : 00:08:25
|
| You create sql login under server -> security -> logins in ssms. |
|
|
|
|
|
|
set password