January 6, 2010 at 9:23 pm
Installed SQL Server 2000 EE on windows 2003 32 BIT, SP4 updated.
Iam able to connect the SQL Server locally , but when i try to connect that remotely its throwing error as:
_______________________________________________
TITLE: Connect to Server
------------------------------
Cannot connect to BELLAGIO\ENTR.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
________________________________________________________________
Thoughts please, as i have wasted 6 hrs ........
Please find the error log attached.
Cheers,
- Win.
" Have a great day "
January 6, 2010 at 9:50 pm
Where are you trying to connect from?
In SQL Server 2005, you have a tool called Surface Area Configuration through which you have to enable TCP/IP by clicking on remote connections in the left sub-menu.
I am pretty sure you have to do that first, I am not sure where that option is, in SQL Server 2000.
I will try to help you more tomorrow. Some of my company's databases are on SS 2000.
Also, you might need to make a login that you would use to connect remotely.
The above is just my hunch, I am only a year old in SQL Server but those are the things I would have tried out if it were me.
Good luck
January 6, 2010 at 10:26 pm
Did all the things..
We have SQL 2005 installed already with two instances. After then for one of our processes we need SQL 2000.
We installed SQL 2000 with SP4 - Enterprise Edition on WIN 2003 Standard Edition.
after installing SP4 , rebooted, from then the server is not able to connect remotely.
Tried connecting from other locations, but unable to.
All the TCP/IP and remote connections are enabled.
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 2:13 am
Anyone faced this issue ?
Can anyone help on this... Suggestions appreciated.
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 3:12 am
When you go SQL Server properties; is there a tick against Allow other SQL Servers to connect remotely to this SQL Server using RPC.
January 7, 2010 at 3:30 am
Yes.
Its already selected.
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 4:35 am
Could you please confirm the following:
1. SQL Browser service is running on the server.
2. On the firewall put the exception for sqlbrowser.exe and/or UDP port 1433.
3. Can you get to the server machine using the IP address instead of the name.
January 7, 2010 at 5:18 am
Could you please confirm the following:
1. SQL Browser service is running on the server.
2. On the firewall put the exception for sqlbrowser.exe and/or UDP port 1433.
3. Can you get to the server machine using the IP address instead of the name.
__________________________________________________________________________
Yes
1.SQL Browser is running - we are able to connect SQL 2005 remotely (as Its a DEV Server)
2. Yes
3. yes tried with IP Address\Instance - still no use.
And i can see the Event Viewer as :
The configuration of the AdminConnection\TCP protocol in the SQL instance ENTR is not valid.
___________________________________________________________________________
Event Type:Warning
Event Source:SQLBrowser
Event Category:None
Event ID:3
Date:1/7/2010
Time:4:21:08 PM
User:N/A
Computer:BELLAGIO
Description:
The configuration of the AdminConnection\TCP protocol in the SQL instance ENTR is not valid.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
_______________________________________________________________________________
tried many things, but no use.
Thanks for replying.
Appreciate your help and interest in this. As no one responded and no where found any resolution......
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 7:45 am
What port is 2005 instance running on.
By default 2000 uses 1433. Make sure they are different. You can't have the same port.
January 7, 2010 at 9:04 pm
SQL Server 2005 instances has different port numbers
SQL 2000 is using 1433
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 9:18 pm
<<< Edited - changes done >>>
1. we have three SQL Server 2005 Instances (one default instance and two named instance) - 3439, 4312, 1413
2. Then we installed SQL Server 2000 with named instance. - 3759
No SQL has 1433 port here
i used below query to find the port numbers of the instances:
_______________________________________________________________________
set nocount on
DECLARE @test-2 varchar(20), @key varchar(100)
if charindex('\',@@servername,0) <>0
begin
set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'
+@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'
end
else
begin
set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP'
end
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@key,@value_name='Tcpport',@value=@test OUTPUT
SELECT 'Server Name: '+@@servername + ' Port Number:'+convert(varchar(10),@test)
_________________________________________________________________________________
Can any one let me know if any settings to be changed.
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 10:34 pm
When i tried connectiing then server through Query Analyzer there is an error:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 10:52 pm
Basic thing but is the mssql service running.
"Keep Trying"
January 7, 2010 at 11:18 pm
Yes,
All the services are running...
Its a lot of hectic from past 2 days.....
Cheers,
- Win.
" Have a great day "
January 7, 2010 at 11:43 pm
Please post suggestions and thoughts if any.
Cheers,
- Win.
" Have a great day "
Viewing 15 posts - 1 through 15 (of 25 total)
You must be logged in to reply to this topic. Login to reply