opsætning af SQL server 2005 express

Jeg vil tro at følgende guide - eller ihvertfald første del af den :) - kan hjælpe dig...

http://www.datamasker.com/SSE2005_NetworkCfg.htm

på din maskine hvor din sql er ... hvad er Authencation sat til ?

Mixed mode eller Windows ?

Hvordan connector du fra dine klienter ? Er der en Domain server ? eller er de bare meldt ind i en Workgroup ?

mvh

jeg vil gerne give point til isl19960, hvordan gør man?

Godt det kunne hjælpe dig...

Jeg afgiver et svar - og du kan derefter vælge hvem du vil tildele point.

Ellers må du lige sige til, så skal jeg nok hjælpe dig.

Remote connections skal enables - kig på dette link
http://forums.asp.net/p/1302020/2547594.aspx

Der står b.la.
Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
loadTOCNode(2, 'moreinformation');You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the SQL Server Browser service, follow these steps.

Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process.