Re: Server connection to SQL/Server Express won't work

And there is a Books Online tutorial on getting connected: http://msdn2.microsoft.com/en-us/library/ms345318.aspx
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message news:%23$Qmghk6HHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
Do these help:

http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for remote access

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"dperson" <dperson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7A396861-6C52-407E-A7ED-9AC2BD8D820E@xxxxxxxxxxxxxxxx
I have SQL/Server Express set up on two machines. I turned on all the
protocols for each. I started the server browser task on each. I opened
ports 1433 and 1434 on both firewalls. I can sometimes find the servers when
I browse. I just can't logon from either. I've tried logging on as 'sa',
I've set up windows user accounts,sql server id's will all the rights
possible. Nothing works.

This seems like a pretty simple process. Seems amazing that its actually so
hard to complete.

Oh, and I get a warning dialog when I start Managment Studio Express - with
no text! Just blank.
--

.NET Forms Developer


.

Relevant Pages

  • Re: Executing Procedures through LInked Server
    ... >I have already configured the other server for remote access and reconfigured ... > Execute a Proc -P Sitting on Machine A from Machine B. ... >> Configuring a server for remote access and RPC are two ...
    (microsoft.public.sqlserver.connect)
  • Re: Server connection to SQL/Server Express wont work
    ... Configuring Remote Access ... Solid Quality Mentors ... I started the server browser task on each. ...
    (microsoft.public.sqlserver.connect)
  • After MS Updates, VPNs not working and getting RRAS error
    ... I installed the latest MS updates on our SBS2003 server the other day. ... Now, when I try to run the Remote Access Wizard on the server, I get through ... An error occured while configuring ...
    (microsoft.public.windows.server.sbs)
  • Re: Executing Procedures through LInked Server
    ... Configuring a server for remote access and RPC are two ... >SQL Server to allow remote access. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to access server resources via vpn
    ... Please update your SBS NIC driver, ensure you install the latest driver ... Open ISA server 2004, ... 'Microsoft Firewall' service. ... Running ICW and Remote Access Wizards now intermittently ...
    (microsoft.public.windows.server.sbs)
Loading