The number of dots do not reflect the number of characters in the password. This is a security
feature.

Signature
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
> Hi - I have installed SQL Server Express (2005) on one PC and am
> trying to access it from another using mgt studio.
[quoted text clipped - 19 lines]
>
> Andrew
SQL Server and Windows logins are different beasts. With a SQL Server
login, it is SQL Server that maintains and validates the password. However,
with a Windows login, Windows validates the user identity based on the
current user credential and SQL Server knows only only the account name and
SID (not password).
Below is a sample script grant a Windows account access to SQL Server and a
database.
USE MyDatabase;
CREATE LOGIN [MyDomain\MyAccount] FROM WINDOWS;
CREATE USER [MyDomain\MyAccount];

Signature
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
> Hi - I have installed SQL Server Express (2005) on one PC and am
> trying to access it from another using mgt studio.
[quoted text clipped - 19 lines]
>
> Andrew
andrew_jmdata - 26 Jun 2008 15:54 GMT
On 26 Jun, 11:51, "Dan Guzman" <guzma...@nospam-online.sbcglobal.net>
wrote:
> SQL Server and Windows logins are different beasts. With a SQL Server
> login, it is SQL Server that maintains and validates the password. However,
[quoted text clipped - 38 lines]
>
> > Andrew
Tried the above and got..
CREATE LOGIN [data_main\Andrew] FROM WINDOWS;
CREATE USER [data_main\Andrew];
and got...
Msg 15401, Level 16, State 1, Line 2
Windows NT user or group 'data_main\Andrew' not found. Check the name
again.
Msg 15401, Level 16, State 1, Line 3
Windows NT user or group 'data_main\Andrew' not found. Check the name
again.
Any thoughts?
Andrew
Aaron Bertrand [SQL Server MVP] - 26 Jun 2008 16:11 GMT
Do you really have a domain called data_main? Does that domain really
contain a user named Andrew (usually in AD account names are first initial,
last name)? Also you don't need to include the entire conversation in every
follow-up. When bottom-posting this makes it very cumbersome to access the
new input.
> Tried the above and got..
>
[quoted text clipped - 13 lines]
>
> Andrew
andrew_jmdata - 26 Jun 2008 17:05 GMT
Hi Aaron - I don't have a domain name called data_main... no!
Does it matter how the names are formatted?
Regards
Andrew
Aaron Bertrand [SQL Server MVP] - 26 Jun 2008 17:39 GMT
If you are using a domain user and windows authentication, the it must be
valid_domain\valid_user. If you want to use SQL authentication, then the
username should be valid within SQL, and it should not contain a \ as that
will undoubtedly lead to some mistaken assumptions somewhere.
On 6/26/08 12:05 PM, in article
2a2f1eae-9ba2-4097-9007-58022c0ae741@l64g2000hse.googlegroups.com,
> Hi Aaron - I don't have a domain name called data_main... no!
>
[quoted text clipped - 3 lines]
>
> Andrew
andrew_jmdata - 26 Jun 2008 22:21 GMT
Yes to both of those... seems to make no odds.
andrew_jmdata - 26 Jun 2008 22:21 GMT
Yes to both of those... seems to make no odds.
Aaron Bertrand [SQL Server MVP] - 26 Jun 2008 22:23 GMT
Sorry, I don't know what that means. <shrug>
On 6/26/08 5:21 PM, in article
d0f9cce0-77ad-4384-8b51-483a5725e6a2@s50g2000hsb.googlegroups.com,
> Yes to both of those... seems to make no odds.
About the changing the length of the dots of your passwords are about
security as Tibor mentioned. Your password does not change in reality. This
is made only not to show the others the length of your real password.
If your first post, you said that you installed an instance of SQL Server
2005 Express Edition on a PC and you tried to reach it from another PC using
SSMS.
If you do not have a trusted environment or you work in a trusted
environment but you don't have a valid Login for your Actve Directory
account in your remote SQL Server server, then you can't log in to it.
However I somehow believe that your computers are independent, they are not
a part of a trusted environment. They are just in the same workgroup or not
even in the same workgroup. In this case, you still have a chance to connect
to your remote SQL Server instance using Window Authentication by setting up
two same Windows accounts. For example, create a Windows Account on the SQL
Server server with a user name "SQL" and password "xxx". Create this same
Windows Account in your other PC with the same user name and password.
Create a Login for this windows account in your SQL Server. And log in to
your Windows in your second PC using this Windows account then you'll be
able to connect to your SQL Server using Windows Authentication.
However, in SQL Server 2005 Express Edition, remote connection is disabled
by default. You'll need to enable it. If your SQL Server instance is a Named
Instance, then ensure your Browser Service is running and up. Configure your
Firewall to let your SQL Server ports. Ensure you can ping your SQL Server
server from your second PC and vice versa.
In non-trusted environments, it's better using SQL Logins rather than
Windows Authentication.
Also, to create a Windows Login on a stand-alone SQL Server server using the
following code as Dan's given you as a sample:
CREATE LOGIN [data_main\Andrew] FROM WINDOWS;
CREATE USER [data_main\Andrew];
You should format the Login name this way:
"Your_Computer_Name\Your_Existing_Windows_Account"
For example, My computer name is "EKREM-PC" and my user name is "Ekrem" on
my test machine. So, to create a Windows Login, I should execute the
following code:
CREATE LOGIN [EKREM-PC\EKREM] FROM WINDOWS;
CREATE USER [EKREM-PC\EKREM];

Signature
Ekrem Önsoy
> Hi - I have installed SQL Server Express (2005) on one PC and am
> trying to access it from another using mgt studio.
[quoted text clipped - 19 lines]
>
> Andrew
andrew_jmdata - 30 Jun 2008 10:53 GMT
Hi Ekrem - I'll give what you suggested a go. My PC's are just
connected using standard (home) netgear router and in the same "home"
network, there is no server as such.
"makes no odds" means nothing has changed!
Thanks
Andrew
andrew_jmdata - 30 Jun 2008 10:53 GMT
Hi Ekrem - I'll give what you suggested a go. My PC's are just
connected using standard (home) netgear router and in the same "home"
network, there is no server as such.
"makes no odds" means nothing has changed!
Thanks
Andrew