Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Remote Connections Expand / Collapse
Author
Message
Posted Thursday, October 29, 2009 6:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 7, 2012 7:00 AM
Points: 33, Visits: 58
Could some one tell me how to set up remote connections in SQL Server 2008? I think I did it with the named pipes - set ehm to enable. I am trying to install NopCommerce and keep getting an error: Login failed for user 'NT AUTHORITY\IUSR' I also do not know how ro set this. I tried to use the sql login but do not remember the password.

Thank you

Ladydee


Darlene D. Murphy
deemurphy_us@yahoo.com
Post #810681
Posted Monday, June 28, 2010 9:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 11:27 PM
Points: 170, Visits: 553
You can click properties in Management Studio, click Connections and under remote server connections, check 'Allow remote connections to this server'

Is this what you mean?
Post #944360
Posted Tuesday, June 29, 2010 6:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:38 AM
Points: 7, Visits: 194
This could be a couple of things. Normally, you have already checked 'Allow Remote Connections' in the configuration manager. So it is probably a couple three things from the top of my head....

1. Make sure account has access to SQL Server instance...that the IUSR account that you talked about.
2. Make sure SQL Agent is on...
3. Disable Windows Firewall...

Hopefully this helps you out.....


Cheers,
AJ

Arie Jones
http://www.programmersedge.com
http://www.sqlsherpa.com
Post #945138
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse