SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 logging into localhost on another machine
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

esthera
Flowing Fount of Yak Knowledge

1388 Posts

Posted - 06/17/2014 :  13:27:11  Show Profile  Reply with Quote
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

USA
36594 Posts

Posted - 06/17/2014 :  13:45:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
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/
Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1388 Posts

Posted - 06/18/2014 :  00:49:05  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36594 Posts

Posted - 06/18/2014 :  12:34:29  Show Profile  Visit tkizer's Homepage  Reply with Quote
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/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000