2008 Server w/2008 SQL EE on a SBS2K3

10 views
Skip to first unread message

az

unread,
Jan 29, 2009, 5:04:13 PM1/29/09
to
Just installed a new server w/2008 Enterprise and joined it to our domain
which is running SBS 2003. Installed SQL Server 2008 on the new server and
nothing else on on network can see this SQL server. Followed all of MS's
instructions to no avail, in fact, I actually disabled the firewall on the
new server and still nothing. Really stumped on this one and would
appreciate any and all assistance!

Aaron Bertrand [SQL Server MVP]

unread,
Jan 29, 2009, 5:30:58 PM1/29/09
to
How exactly are you trying to connect? Do you mean it won't respond to
pings, or you just can't connect to SQL Server? If it is a ping do you get
request timed out? Are you using IP or name? Did you try both? If it is
SQL Server, what error do you get? Login failed, or SQL Server does not
exist or access denied, or timeout expired, or something else? Please be
specific and don't paraphrase. Are you trying to connect using SQL
authentication or Windows authentication? Are you in the domain or are you
connected via VPN? Is the server in the same domain as you?

What edition of SQL Server 2008 did you install? Did you install a default
instance or a named instance, and if the latter, what did you call it? Is
this the same server that is running SBS, or a different server? Is the SQL
Server Browser service running? How about in the SQL Server Configuration
Manager, if you go into SQL Server Network Configuration \ Protocols for
<instance name>, which protocols are enabled? And under SQL Server Services
what are all the services that are listed, and what is their current state?

You say you have "disabled the firewall on the new server" which I assume
means you are talking about the built-in Windows firewall. Are you sure
there isn't a REAL, LIVE, made-of-metal firewall in play?

What are "all of MS's instructions" that you say you have followed? Can you
elaborate, provide links, etc. so we can understand what you are talking
about?


On 1/29/09 5:04 PM, in article
5B2602F2-E19F-4638...@microsoft.com, "az"

az

unread,
Jan 29, 2009, 6:21:02 PM1/29/09
to
When trying to connect from the SBS 2003 box (within the domain) to the new
Windows 2008 server (TSSQLSVR also in the domain) running SQL Server 2008
Express Edition with Advance Services, I get the message "TSSQLSVR - SQL
Server does not exist or action denied ConnectionOpen(Connect()).

I have tried authenticating with both Windows and SQL Server authentication.
I have tried addressing the server both by name and by IP Address.

Instructions that I have tried implementing:

From SQL Server 2008 Books Online (January 2009)
How to: Configure a Server to Listen on a Specific TCP Port (SQL Server
Configuration Manager).

Configuring the Windows Firewall to Allow SQL Server Access
(http://msdn.microsoft.com/en-us/library/cc646023.aspx

SQL Server was installed with the default instance. Accessing SQL Server
from the Windows 2008 Server with SQL Server Management Studio is not a
problem... the problem is being able to see the SQL Server instance from any
other computer including the SBS box.

I have pinged the server hosting the SQL Server without any problem, both by
name and IP address.

We do have a PIX 515e in place and port 1433 is open for that machine.

If you have any other questions in regards to configurations or what I have
attempted please let me know. This is day 3 in trying to get this resolved
and I am just a tad frustrated.

Aaron Bertrand [SQL Server MVP]

unread,
Jan 29, 2009, 6:35:34 PM1/29/09
to

> SQL Server was installed with the default instance.

Are you sure about that? Did you try servername\SQLEXPRESS ?

az

unread,
Jan 29, 2009, 6:49:01 PM1/29/09
to
Yes, of course... as previously mentioned. The new Windows Server 2008 name
is TSSQLSVR and I tried accessing it by TSSQLSVR\SQLEXPRESS and
192.168.0.50\SQLEXPRESS with the same error message.

I do appreciate your quick response to this and any suggestions you may have
would be greatly appreciated!

"Aaron Bertrand [SQL Server MVP]" wrote:

Aaron Bertrand [SQL Server MVP]

unread,
Jan 29, 2009, 7:29:49 PM1/29/09
to
>> Did you try servername\SQLEXPRESS ?

> Yes, of course... as previously mentioned.

Where was this previously mentioned? In this thread?

az

unread,
Jan 29, 2009, 8:58:01 PM1/29/09
to
Yes, in this thread. Do you have any suggestions that I can try, please?

"Aaron Bertrand [SQL Server MVP]" wrote:

az

unread,
Jan 31, 2009, 1:39:00 PM1/31/09
to
Do you have any advice/theories?

"Aaron Bertrand [SQL Server MVP]" wrote:

Aaron Bertrand [SQL Server MVP]

unread,
Jan 31, 2009, 1:42:47 PM1/31/09
to
Without seeing your server and being in your environment? Nope, sorry.


On 1/31/09 1:39 PM, in article
4DDDC10B-33DE-4A2C...@microsoft.com, "az"

az

unread,
Jan 31, 2009, 1:56:01 PM1/31/09
to
and your a MVP? and this is the SQL Server Setup forum? you would have to
admit you have NOT been useful at all (except for critiquing my posts).
Perhaps you might be more helpful in the LetMeWasterYourTime group. I would
recommend you highly.

Aaron Bertrand [SQL Server MVP]

unread,
Jan 31, 2009, 2:09:45 PM1/31/09
to
I asked a bunch of questions, you answered half of them, a few in smart-a$$
form (like adding "as previously mentioned" even though I could no trace of
any such mention of the SQLEXPRESS named instance). What do you expect?
Magic? I can't see your environment, I gave plenty of configuration ideas
to check, and you smugly wrote them all off. <shrug> If you don't like the
free help, I'll send your money back, m'kay?

On 1/31/09 1:56 PM, in article
17DFA678-89A6-4624...@microsoft.com, "az"

Ekrem Önsoy

unread,
Jan 31, 2009, 5:37:35 PM1/31/09
to
Recently, this kind of guys bump into you very frequently =)

--
Ekrem Önsoy

"Aaron Bertrand [SQL Server MVP]" <ten...@dnartreb.noraa> wrote in message
news:C5AA0C29.E23E%ten...@dnartreb.noraa...

Aaron Bertrand [SQL Server MVP]

unread,
Jan 31, 2009, 5:42:59 PM1/31/09
to
Yeah I guess I know how to attract the best...


On 1/31/09 5:37 PM, in article OIHSTS$gJHA...@TK2MSFTNGP06.phx.gbl, "Ekrem

chris....@gmail.com

unread,
Feb 2, 2009, 3:51:55 AM2/2/09
to
> > 5B2602F2-E19F-4638-81EC-F32426BE5...@microsoft.com, "az"

> > <a...@discussions.microsoft.com> wrote:
>
> > > Just installed a new server w/2008 Enterprise and joined it to our domain
> > > which is running SBS 2003. Installed SQL Server 2008 on the new server and
> > > nothing else on on network can see this SQL server. Followed all of MS's
> > > instructions to no avail, in fact, I actually disabled the firewall on the
> > > new server and still nothing. Really stumped on this one and would
> > > appreciate any and all assistance!

By default, network protocols are disabled on Sql Server 2008 Express.
http://msdn.microsoft.com/en-us/library/ms165677.aspx

Reply all
Reply to author
Forward
0 new messages