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

Cool, I will add that link to my list. Thanks Rick.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:DF4F2055-79BC-43B1-9312-167A73BFA48D@xxxxxxxxxxxxxxxx
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: logs on RAID 0
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... If any Newsgroup admins review these postings, ...
    (microsoft.public.sqlserver.setup)
  • Re: Packing on data table.
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... images/pdf documents/OLE Objects). ...
    (microsoft.public.sqlserver.programming)
  • Re: Why a DELETE transaction running in read-uncomitted is acquiri
    ... You can have parts of the Delete statement run in uncommitted isolation mode such as joining on other tables to find the rows etc. ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Database files on a SAN
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... > We run our SAP SQL database on a SAN and we recently expanded our SAN ...
    (microsoft.public.sqlserver.setup)
  • Re: problem to connect sql server 2005 from localhost (W2k3)
    ... Andrew J. Kelly SQL MVP ... Solid Quality Mentors ... It's possible to connect the sql server via telnet? ...
    (microsoft.public.sqlserver.connect)