all groups > sql server connect > august 2007 >
You're in the

sql server connect

group:

Server connection to SQL/Server Express won't work


Server connection to SQL/Server Express won't work dperson
8/28/2007 10:28:18 PM
sql server connect:
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.
--

Re: Server connection to SQL/Server Express won't work Rick Byham, (MSFT)
8/29/2007 8:44:52 AM
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.

[quoted text, click to view]
Re: Server connection to SQL/Server Express won't work Andrew J. Kelly
8/29/2007 10:24:50 AM
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


[quoted text, click to view]
Re: Server connection to SQL/Server Express won't work Andrew J. Kelly
8/29/2007 1:16:08 PM
Cool, I will add that link to my list. Thanks Rick.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


[quoted text, click to view]
Re: Server connection to SQL/Server Express won't work William Vaughn
8/30/2007 11:32:52 AM
And while you're reading... see:
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]
AddThis Social Bookmark Button