logging into localhost on another machine

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 Administration

logging into localhost on another machine

Author

Topic

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-06-17 : 13:27:11

I have 2 computers

I want to be able to log in with sql managment studio from the second computer to the first

what do I need to do to make this work

as of now instead of putting in localhost I am putting in the ip but I am getting an error

Logon failure:unknown user name or bad password

named pipes and tcp/ip is open

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-17 : 13:45:50

Hostname\Instancename

But that error means you did make it to the other computer and was denied access due to your logon. Are you using SQL or Windows authentication? Has that account been granted access?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-06-18 : 00:49:05

sql authenticaion

when i connect locally i use localhost

so i tried just the ip but it didn't work
would i do ip\instancename
and how do i know what the instance name is

the same username and password work if I type in localhost

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-18 : 12:34:29

You can check the instance name by looking at the SQL Server service names in Admin Tools/Services. You would check this on the server where SQL Server is installed.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources