Avatar billede Skynet Mester
22. august 2008 - 23:01 Der er 3 kommentarer og
1 løsning

Connect to Server?

Hej

Jeg er helt ny mht MSSQL, jeg har installeret både MSSQL 2005 server, og SQL Server 2005's Management Studio.

Når jeg prøver at lave en forbindelse fra Management Studio får jeg denne fejlmeddelelse, selv om jeg har angivet at der godt må tiolgå fjernkontrol med IP/TCP

Nogen som kan give et bud på en løsning?


TITLE: Connect to Server
------------------------------

Cannot connect to MSSQL$SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

Der opstod en fejl under oprettelse af forbindelse til serveren. Under oprettelse af forbindelse til SQL Server 2005 kan denne fejl skyldes den omstændighed, at SQL Server ikke tillader fjernforbindelser under standardindstillingerne. (provider: Navngivet pipe-provider, error: 40 - Der kunne ikke åbnes en forbindelse til SQL Server.) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Avatar billede ldanielsen Nybegynder
23. august 2008 - 01:48 #1
kan du pinge den med det navn du bruger, som de nævner i hjælpen?
Avatar billede Skynet Mester
23. august 2008 - 09:37 #2
"ping command in the Windows operating system." hvordan finder jeg ud af hvad det er?
Avatar billede jensriis Novice
30. august 2008 - 20:45 #3
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.
Avatar billede Skynet Mester
31. august 2008 - 00:51 #4
mange tak..
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester