MSDE 2000 do not listen

Hi all,
I install MSDE with SP3a on my server. The service starts well and with the
local host I'm able to access the MSDE server, but if I want to access it
from another workstation the connection always failed. I troubleshoot the
problem and I found that MSDE 2000 doesn't listen on the port 1433. Why?
There is a way to enable MSDE listening on TCP 1433 port and accept
connection form other client?
Regards
YanickIn the default configuration of MSDE TCP/IP as a server network library is
disabled. There is a utility, svrnetcn.exe, that can be used to enable it.
The utility is installed with MSDE so it shoulb be on the computer. Search
for this file and open it. You should tehn be able to enable TCP/IP.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql

MSDE - Start Databases

Hello

I'm using SQL Server 2000 - 8.00.760 Desktop Engine.

When the SQL Server starts, it just start databases master, model and tempdb. The databases that I have created don't start. They just start when I connect to them for the first time.

What I can do to start my own database when the SQL Server starts?

Thank you.

All databases are opened at startup if they are attached to SQl Server. If you have switched on the autoclose option, they are in common closed (but not stopped) after the last user disconnected.

jens Suessmeyer.

http://www.sqlserver2005.de

|||I did't switched on the autoclose option - it is off, but my database just start on first use, causing a delay on my application while it starts. When it is already started, I have no delay. I need start my database when SQLServer (MSDE) starts. Is there anything to do to start my database on start of SQLServer (MSDE)?|||

The Service is autostart, but my own databases just start when I connect to them to the first time.

Is there anything to do to auto start databases?

Thanks.

|||Are you sure you are using a MSDE database not a sqlserver express database. This sounds like you are using user instances which are only available after connecting the first time. Where do you actually administer the SQL server databases ? After starting the server do you see the entries in sysdatabase tables / views using SELECT * from sysdatabases ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I am using MSDE database. To administer SQL Server I use OSQL.

After start the server I ran SELECT * from sysdatabases. My own databases are listed.

|||If the databases are listed they should be available. use the SELECT name, mode, status,status2 from sysdatabases to check their current status. What is currently displayed ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I have three databases. They are listed and the databases master, model, msdb and tempdb are listed too.

After start SQLServer, the SELECT results the same values for my three databases: mode = 0, status = 1073741848 and status2 = 16777216.

Here, my own databases are not started. In the first connect to the database I has a delay, because they are not started.

Then, I connect to one and the value for status changes to 24. Now, it is started.

Any idea?

MSDE - Start Databases

Hello

I'm using SQL Server 2000 - 8.00.760 Desktop Engine.

When the SQL Server starts, it just start databases master, model and tempdb. The databases that I have created don't start. They just start when I connect to them for the first time.

What I can do to start my own database when the SQL Server starts?

Thank you.

All databases are opened at startup if they are attached to SQl Server. If you have switched on the autoclose option, they are in common closed (but not stopped) after the last user disconnected.

jens Suessmeyer.

http://www.sqlserver2005.de

|||I did't switched on the autoclose option - it is off, but my database just start on first use, causing a delay on my application while it starts. When it is already started, I have no delay. I need start my database when SQLServer (MSDE) starts. Is there anything to do to start my database on start of SQLServer (MSDE)?|||

The Service is autostart, but my own databases just start when I connect to them to the first time.

Is there anything to do to auto start databases?

Thanks.

|||Are you sure you are using a MSDE database not a sqlserver express database. This sounds like you are using user instances which are only available after connecting the first time. Where do you actually administer the SQL server databases ? After starting the server do you see the entries in sysdatabase tables / views using SELECT * from sysdatabases ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

I am using MSDE database. To administer SQL Server I use OSQL.

After start the server I ran SELECT * from sysdatabases. My own databases are listed.

|||If the databases are listed they should be available. use the SELECT name, mode, status,status2 from sysdatabases to check their current status. What is currently displayed ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

I have three databases. They are listed and the databases master, model, msdb and tempdb are listed too.

After start SQLServer, the SELECT results the same values for my three databases: mode = 0, status = 1073741848 and status2 = 16777216.

Here, my own databases are not started. In the first connect to the database I has a delay, because they are not started.

Then, I connect to one and the value for status changes to 24. Now, it is started.

Any idea?