Named Instance SQL 7 / SQL 2K

We have a server by name TEST and SQL 7 installed and exists a login 'xx'
and password 'xx'
Recently we installed a named instance SQL 2K on TEST by name TEST\TEST2K
and with a login 'xx' and password 'abc'
I created an alias for TEST\TEST2K as TEST2K
From TEST, Executed sp_addlinkedserver TEST2K
When I try executing from TEST , logged in as 'xx' and password 'xx'
SELECT * FROM TEST2K.MYDB.DBO.MYTABLE
error message
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'xx'.
Is this because of the password difference for 'xx' in TEST and TEST2K '
How to handle this '
Thanks
ShamimSee if this helps...
exec sp_addlinkedserver 'TEST2K','','SQLOLEDB','TEST\TEST2K'
exec sp_addlinkedsrvlogin 'TEST2K','false',null,'xx','abc'
--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:OV0C$P%23eDHA.1828@.TK2MSFTNGP10.phx.gbl...
> We have a server by name TEST and SQL 7 installed and exists a login 'xx'
> and password 'xx'
> Recently we installed a named instance SQL 2K on TEST by name TEST\TEST2K
> and with a login 'xx' and password 'abc'
> I created an alias for TEST\TEST2K as TEST2K
> From TEST, Executed sp_addlinkedserver TEST2K
> When I try executing from TEST , logged in as 'xx' and password 'xx'
> SELECT * FROM TEST2K.MYDB.DBO.MYTABLE
> error message
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'xx'.
> Is this because of the password difference for 'xx' in TEST and TEST2K '
> How to handle this '
> Thanks
> Shamim
>|||Thanks oj..It worked !!!! much appreciated.
Shamim
"oj" <nospam_ojngo@.home.com> wrote in message
news:e$v$do$eDHA.2748@.TK2MSFTNGP11.phx.gbl...
> See if this helps...
> exec sp_addlinkedserver 'TEST2K','','SQLOLEDB','TEST\TEST2K'
> exec sp_addlinkedsrvlogin 'TEST2K','false',null,'xx','abc'
> --
> -oj
> RAC v2.2 & QALite!
> http://www.rac4sql.net
>
> "Shamim" <shamim.abdul@.railamerica.com> wrote in message
> news:OV0C$P%23eDHA.1828@.TK2MSFTNGP10.phx.gbl...
> > We have a server by name TEST and SQL 7 installed and exists a login
'xx'
> > and password 'xx'
> > Recently we installed a named instance SQL 2K on TEST by name
TEST\TEST2K
> > and with a login 'xx' and password 'abc'
> >
> > I created an alias for TEST\TEST2K as TEST2K
> > From TEST, Executed sp_addlinkedserver TEST2K
> >
> > When I try executing from TEST , logged in as 'xx' and password 'xx'
> >
> > SELECT * FROM TEST2K.MYDB.DBO.MYTABLE
> >
> > error message
> > Server: Msg 18456, Level 14, State 1, Line 1
> > Login failed for user 'xx'.
> >
> > Is this because of the password difference for 'xx' in TEST and TEST2K
'
> >
> > How to handle this '
> >
> > Thanks
> > Shamim
> >
> >
>

mysqladmin: connect to server at localhost failed - MySQL

hi all,

I got the error like
[sait6@.localhost treestructure]$ mysqladmin -h localhost -u root -p create bedrock
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@.'localhost' (using password: YES)'

[sait6@.localhost treestructure]$ mysqladmin --no-defaults -u root ver
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@.'localhost' (using password: NO)'

and when i type mysql and start to change some password i got

mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','sait6','sait123');
ERROR 1046 (3D000): No database selected

please give suggestion to eradicate the above problem.

thanyou.
-RAJU

Quote:

Originally Posted by rajbala

hi all,

I got the error like
[sait6@.localhost treestructure]$ mysqladmin -h localhost -u root -p create bedrock
Enter password: ******
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@.'localhost' (using password: YES)'

[sait6@.localhost treestructure]$ mysqladmin --no-defaults -u root ver
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@.'localhost' (using password: NO)'

and when i type mysql and start to change some password i got

mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','sait6','sait123');
ERROR 1046 (3D000): No database selected

please give suggestion to eradicate the above problem.

thanyou.
-RAJU

I need your help............

mysql

hey I'm just trying to install mysql and it keeps saying
I need a strong password for SA. I thought I did and I'm
sure this is really simple. Thanks!This is a newsgroup for Microsoft SQL server. If you have a question about
that product, someone here will be glad to help you.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Tony" <anonymous@.discussions.microsoft.com> wrote in message
news:577501c40072$e9c72230$a501280a@.phx.gbl...
> hey I'm just trying to install mysql and it keeps saying
> I need a strong password for SA. I thought I did and I'm
> sure this is really simple. Thanks!|||Strong pwds consist of a mixture of upper and lower case letters, are genera
lly more than 8 characters long and contain at least one number.