June 15, 2004 at 1:37 am
Hi,
I have a problem during installation of sql 2000, at the end the program setup tell me : "setup to failed to configure the server. Refer to server log ..." so i see this file and i find :
Starting Service ...
Latin1_General_CI_AS -m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=MioServer\MioServer;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Errore di rete generico.
Controllare la documentazione della rete.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (recv()).
driver={sql server};server=MioServer\MioServer;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Errore di rete generico.
Controllare la documentazione della rete.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (recv()).
driver={sql server};server=MioServer\MioServer;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Errore di rete generico.
Controllare la documentazione della rete.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (recv()).
SQL Server configuration failed.
It find a error on the net, during the connection, but if i try to install Sql 7.0, the program has installed correctly. On this pc is installeted a firewall (but i can not unistall and unconfigured 🙁 ), and I think that port tcp/ip 1433 is locked to comunicate with sql.
Do you have some ideas or suggestions ? Thank in advance
Massimo
Ciao
Massimo
June 15, 2004 at 10:22 am
It looks like you don't have a password for SA.
Have you started the SQL Server service? You may have to do this manually the first time for your control panel --> Adminstrative Tools --> Services --> MSSQLSERVER
You may also want to think about creating an administration account in your windows domain to start the sql server services.
Port 1433 is the standard port sql server listens on if you are using the TCP/IP network library.
Max
June 15, 2004 at 10:55 am
So are you saying SQL Server is installed correctly but you can't connect to it?
Or is SQL Server not installed?
If it is installed, but you can't connect to it then it looks like Port 1433 is blocked (as you stated).
Two solutions:
1. If you have access to the server with SQL Server, use Enterprise Manager, right click on the server and select Properties. On the General tab, click Network Properties. Highlight TCP/IP and select Properties. Change the Port. Restart SQL Server. Now set your connection using that port.
2. Have the firewall people open Port 1433 for your IP address. Access SQL Server, using Enterprise Manager, right click on the server and select Properties. On the General tab, click Network Properties. Highlight TCP/IP and select Properties. Change the Port. Restart SQL Server. Now set your connection using that port. Have the firewall people close the port again.
-SQLBill
June 15, 2004 at 11:14 am
Try telnet Servername/I.P. 1433.
If it is open, a blank screen would come up else would time out
June 15, 2004 at 1:25 pm
SQLBill,
the sql 2000 it is not installed on the pc. The messages appare at the end of installation.
Max
June 22, 2004 at 6:58 am
this problem happens to me before because I install MSDE .. then remove it then install SQL Server 2000 Developer edition.
I think the problem happened because of comparing OLE DB files in instalation
the solution was:
1- romve SQL Server manually .. see this site
http://www.swynk.com/faq/sql/sqlfaq_install.asp
2- install MDAC 2.7 SP1 on the server
3- restart and install SQL Serverr 2000 again
and it works ..
I hope this help u
Alamir Mohamed
Alamir_mohamed@yahoo.com
June 23, 2004 at 2:31 am
Mohamed,
thanks for this suggestion, but i need another little help. I cannot find in the site http://www.swynk.com ... the documentation regarding "remove sql server" can you indicate me the article ?
Thanks in advance
Massimo Valtolina
June 23, 2004 at 3:27 am
here is wat you want:
How can I completely uninstall SQL Server?
If the standard un-install utility doesn't do the trick for some reason :-
Remove the <sql> directory and everything under it
Remove the <sql> dir from the path (use control panel/system for this)
Remove the SQL registry entries using regedt32/regedit. These are :-
(all versions) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
(6.x only) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLExecutive
(7.x only) HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
(all versions) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply