Link to home
Start Free TrialLog in
Avatar of ac_davis2002
ac_davis2002Flag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL2005 Server Management Studio

Hi

I have three sql2000 servers callled sql1,sql2 and sql3. i have a server called longhorn running sql2005. when I connect to longhorn, using server manager i can connect to all my other servers (sql1,sql2,sql3) andcan see the databases, when I try and connect locally i get thefollowing error 'can not connect to longhorn' additional info 'loon failed for user 'davis' ,microsoft sql server, error 18456)

I am new to sqlserver 2005 am  connecting locally in the wright way?
Avatar of slam69
slam69
Flag of United Kingdom of Great Britain and Northern Ireland image

davis does not have an account for that server, you need to create an accoutn within the logins and then within the db itself
shoudl have put instance instead of server apologies
Avatar of ac_davis2002

ASKER

thanks, can you tell me where I need to go to creat an account the instance?
Sorry to re word

I do i give davis acess to the instance longhorn?
ASKER CERTIFIED SOLUTION
Avatar of slam69
slam69
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks for your help