Re: Server connection to SQL/Server Express won't work
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Wed, 29 Aug 2007 10:24:50 -0400
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
.
- Follow-Ups:
- Re: Server connection to SQL/Server Express won't work
- From: Rick Byham, \(MSFT\)
- Re: Server connection to SQL/Server Express won't work
- Prev by Date: RE: Export the Data of a field of 5000 characters length
- Next by Date: Re: Cant connect through Management Studio, Can connect Visual Stu
- Previous by thread: Re: Cant connect through Management Studio, Can connect Visual Studio
- Next by thread: Re: Server connection to SQL/Server Express won't work
- Index(es):
Relevant Pages
|