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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 password authentication

Author  Topic 

rashmi13
Starting Member

2 Posts

Posted - 2006-05-19 : 11:42:45
Hi,
I am trying to create a new login with a password. I go to Microsoft sql server management. Right-click on security and create a new login with a custom login and password.I use sql authentication. Now after creation if I check the property of the login, the password is the of same length as 'sa'.
The problem is I dont know 'sa' password even. (I use windows authentication to connect to the server.) I need a proper uid and pwd for my .Net application access.
Please help
Thanks
Rashmi

rashmi13
Starting Member

2 Posts

Posted - 2006-05-19 : 11:44:09
Oh sorry I missed to mention that I am using sql 2005 express
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-05-19 : 12:27:42
You mean the number of *'s?
Ignore that.
Just try connecting using the username and password you have created.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -