Re: Install SQL Server 2000 on home network

Tech-Archive recommends: Fix windows errors by optimizing your registry

Perhaps you didn´t open the port on your firewall for that:

http://support.microsoft.com/kb/287932/en-us

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

"Mark Post" <markpost@xxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:O34tUFaUFHA.2664@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I'm a web developer who is trying to expand my database knowledge by
> learning SQL Server 2000 (I've used Access previously) for creating
> dynamic web pages. I have two computers, both running Windows XP Pro SP2
> that are networked together through a Netgear wireless router although
> these two desktop computers are connected to the router through ethernet
> cables, not wireless. On one system I have IIS running, as well as the
> software I use on a regular basis, including Dreamweaver MX2004. On the
> other computer I've kept it bare bones and am trying to install SQL Server
> 2000. I've installed SQL Server with logon set as Local System Account.
> I should mention that I don't currently have Windows passwords set up for
> either machine (blank) and I have Admin privileges on both. I have not
> installed Service Pack 3a yet although I have the cd for that. I'm able
> to get SQL Server to start when I start the computer and I can create ODBC
> connections on the machine it's running on. What I want to do and I am
> unable to do is create an ODBC connection from the other computer to the
> SQL Server computer. I'm assume it's a log in and permissions thing but
> I'm a little lost. Does anyone have any good resources that address
> something like this step by step or does anyone have any advice for doing
> this? I forgot to mention that I'm using SQL Server 2000 Developer's
> Edition. Thank you very much!
>
> Mark
>


.

Relevant Pages

  • Install SQL Server 2000 on home network
    ... I'm a web developer who is trying to expand my database knowledge by ... I've kept it bare bones and am trying to install SQL Server 2000. ... Server to start when I start the computer and I can create ODBC connections ...
    (microsoft.public.sqlserver.setup)
  • Re: How to change default sql server?
    ... When I try add a new item of SQL Server Database in App_Data or try to open a mdf file, ... Connections to SQL Server Files require SQL Server Express 2005 to function properly. ... I tried install SQL server Express 2005 but always failed. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... connections need to be returned to the pool to be ... Enterprise version of SQL Server 2000. ... server user login to be sure that it is not mixed with other running clients). ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)