Re: Configuring Windows Server 2008 to allow Remote SQL Server 2000 co

Carl Taylor (CarlTaylor@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have a MSDE 2000 instance installed on a 2008 Server. I am using I am
using SQL Server Management Studio Express to do the configuration. At
the server, I can login to the instance using the sa account, but the
same type of login attempt to the running instance on the 2008 server by
on another computer on the same network fails.

And the error message is?

Since the sa login credentials work at the 2008 server but not at
another computer on the network, I would assume that Sever 2008 is not
cofigured to allow external access.

Could be the firewall.

It could also be that MSDE is only set up for shared memory.

Do you have other SQL Server instances on this machine? In such case
are you able to connect to these from a remote machine?

Also, I don't know for sure about Windows 2008, but running on SQL 2000
on Windows Vista is unsupported. What this actually means in practice, and
if could have something to do with this issue, I don't know.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: User Question
    ... and write capabilities. ... Should that be an SQL login or Windows login? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 express blank sa passwords
    ... that uses the Sa login, I need to set the password to blank. ... I suggest that you get a voodoo doll of that former DBA, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)