Resolving

Hello!

I am having trouble connection to my SQL 2000 SP4 using TCP IP.

I can only connect specifying the port number in for instance query analyzer. What do I need to do to get it connecting without port number? Do I unblock the resolution protocol UDP 1434 in my firewall?

Carl
Norway

What is error message. If the error is something close to ""Error Locating Server/Instance Specified", you need to enable the sql browser and make sure the udp port 1434 is not blocked by the firewall.

The following link have plenty of the content on troubleshooting connectivity issues.

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

cheers,

|||

Thanks!

But that was concerning SQL2005. My server is 2000 SP4.

But UDP in the firewall is the only possible thing? Because I can connect spesifying the port.

Carl

|||You need connectivity to sqlbrowser in order to resolve the port number for each instance. It applies to both 2000 and 2005.|||

How can I identify the Browser Service?

I have two servers running. One where everything works fine, and this newly installed one where port resolution does not work.

As of now I can not see any difference in the configuration.

sql

Resolving

Hello!

I am having trouble connection to my SQL 2000 SP4 using TCP IP.

I can only connect specifying the port number in for instance query analyzer. What do I need to do to get it connecting without port number? Do I unblock the resolution protocol UDP 1434 in my firewall?

Carl
Norway

What is error message. If the error is something close to ""Error Locating Server/Instance Specified", you need to enable the sql browser and make sure the udp port 1434 is not blocked by the firewall.

The following link have plenty of the content on troubleshooting connectivity issues.

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

cheers,

|||

Thanks!

But that was concerning SQL2005. My server is 2000 SP4.

But UDP in the firewall is the only possible thing? Because I can connect spesifying the port.

Carl

|||You need connectivity to sqlbrowser in order to resolve the port number for each instance. It applies to both 2000 and 2005.|||

How can I identify the Browser Service?

I have two servers running. One where everything works fine, and this newly installed one where port resolution does not work.

As of now I can not see any difference in the configuration.

Resolving

Hello!

I am having trouble connection to my SQL 2000 SP4 using TCP IP.

I can only connect specifying the port number in for instance query analyzer. What do I need to do to get it connecting without port number? Do I unblock the resolution protocol UDP 1434 in my firewall?

Carl
Norway

What is error message. If the error is something close to ""Error Locating Server/Instance Specified", you need to enable the sql browser and make sure the udp port 1434 is not blocked by the firewall.

The following link have plenty of the content on troubleshooting connectivity issues.

http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

cheers,

|||

Thanks!

But that was concerning SQL2005. My server is 2000 SP4.

But UDP in the firewall is the only possible thing? Because I can connect spesifying the port.

Carl

|||You need connectivity to sqlbrowser in order to resolve the port number for each instance. It applies to both 2000 and 2005.|||

How can I identify the Browser Service?

I have two servers running. One where everything works fine, and this newly installed one where port resolution does not work.

As of now I can not see any difference in the configuration.

RESOLVED Re: SQL Server 7: Query fails with error 7607

It turned out that I had to reapply SP4 once I installed FTS over
a previously installed server. Now it works fine. Thanks for
your assistance.
Ernie Limperis wrote:
> John,
> Looks like I misspoke. The build number on the machine in question
> is 7.00.1063. The machine with 1094 is our production box and I
> have't tried running FTS on it yet (can't build the index during
> business hours, and anyhow nobody got around to installing FTS on
> that machine). I know it's hard to say, but do you think the issue
> would go away if I install the security patch on this machine?
>
> ohn Kane wrote:
>
>
==============================================
Ernie Limperis home 510-525-8801
ernie@.sonic.net cell 510-682-6373
==============================================
You're welcome, Ernie,
No, I don't think that just installing the post-SP4 security hotfix roll-up
would of resolved this issue, as hotfixes are specific and this one is
specific to security issues. However, this post-SP4 security hotfix roll-up
does prevent you from re-installing SP4 once the security hotfix is
installed.
I'm glad you were able to resolve this via my original recommendation and
that I asked you what exact build you were on and you provided the info
(@.@.version) is most important in resolving SQL FTS issues!
Regards,
John
"Ernie Limperis" <ernie@.dnai.com> wrote in message
news:#nwevpV4EHA.1976@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> It turned out that I had to reapply SP4 once I installed FTS over
> a previously installed server. Now it works fine. Thanks for
> your assistance.
> Ernie Limperis wrote:
most[vbcol=seagreen]
a[vbcol=seagreen]
had[vbcol=seagreen]
or[vbcol=seagreen]
security[vbcol=seagreen]
especially[vbcol=seagreen]
table[vbcol=seagreen]
'insurance')
>
> --
> ==============================================
> Ernie Limperis home 510-525-8801
> ernie@.sonic.net cell 510-682-6373
> ==============================================
>
sql

RESOLVED - Users Cannot Connect to SQL Server 2000 SP4 After Applying Hotfix (build 8.00.2148)

Users are reporting that they cannot connect to SQL Server using ODBC and Windows Authentication after I applied a SQL Server 2000 SP4 hotfix. The client-side error is:

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied

I installed hotfix for SQL Server 2000 SP4 (sets version to SQL Server 2000 build 8.00.2148 (SP4)); see KB894905. This hotfix was intended to resolve the following issues occurring on the server:

902955 (http://support.microsoft.com/kb/902955/) FIX: You receive a "Getting registry information" message when you run the Sqldiag.exe utility after you install SQL Server 2000 Service Pack 4

895123 (http://support.microsoft.com/kb/895123/) FIX: You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000

Has anyone else experienced this, found a solution, etc.?

Thanks,

David

The server is SQL Server 2000 SP4 on Windows 2003 SP1. The client PC has MDAC 2.8 SP1 on Windows XP SP 2.

|||

double check that windows firewall isn't blocking on both client and server.

on clients run "C:\windows\System32\CliConfg.exe" and make sure that tcp/ip is a configured protocol

on Server, run "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe" and make sure that tcp/ip is configured

|||

Thanks for your reply.

Neither client or server is running Windows Firewall. Both are enabled for TCP/IP. I also ran the MDAC Component Checker on both and neither reported mismatches.

|||

sanity check. . . is the service running?

what happens when you do this from a client -

telnet servername 1433

does the screen go blank, as if waiting for or input? or does it say - "Connecting to servername" and then time out? or something different?

what happens when you do this on the server -

telnet localhost 1433

|||

Yes, the MSSQLSERVER and SQLSERVERAGENT services are both running on the server and I can connect fine using EM from my PC. In fact, I can connect using ODBC from my PC, but a user cannot connect from his PC using the same ODBC setup. An app. server running Windows 2000 SP1 also cannot connect. I've been validating the Windows and MDAC versions and making sure no firewalls are running, etc.

When I run telnet servername 1433 from my PC the window opens and reports "Connecting to servername" and then it disappears. When I run telnet localhost 1433 on the server it does the same thing.

|||

wait a second. . .

sitting at the server, from the start menu, click run . . .

you do:

telnet localhost 1433

a command window opens up and you get a message "connecting to localhost"

and then the command window closes?
If so the connection is being refused from the machine/service.

the telnet should go to a blank/black command window as the sql telnet session awaits more commands.

Is it a named instance of sql server? or default instance?

|||This is a default instance and yes, the telnet window disappears.|||

when you are sitting at the server and trying the telnet, you are logged in as a machine administator and the telent fails?

using enterprise manager, check the server from your machine and confirm that 'servername\Administrators' have server admin permissions.

double check all your logins and db users

are you running NT Authentication or Mixed mode authentication?

|||Yes, I am logged in as an administrator on the server when I run telnet. 'BUILTIN\Administrators' has been removed from the SQL Server logins, but that should not affect users trying to connect with valid registrations. The instance uses mixed-mode authentication (Windows and SQL Server).|||

well, double check your logins and users. . . . no one is denied.

|||

This issue has been resolved. It was related to permissions for the SQL Server Service Account. That account needed permissions adjustments, as described in KB283811.

The permissions changes resolved the ODBC TCP/IP connection failures, but the root cause is still a little perplexing. Connections worked fine for many months, then the failure. The MS Support Engineer that I worked with was convinced that the 2 SP4 hotfixes did not cause the issue. He thinks it may have been the result of a change in Group Policy, which I will have to do more research on.

Reset SA password

I have a need to reset the SA password on our SQL 2000 SP4 Server. Only one
production database is on this server and I've confirmed with the vendor
that the database is not using the SA account for anything.
Under Security, login, I see that I can r/c on SA and change the password
there.
Is that OK to do?
What's the impact of changing the SA password?
Anything else that I'm not thinking of'
Thank you!
RandyHi
Take a look atv sp_password stored procedure in the BOL
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Hi Randy
If you are 100% sure that, none of your application or users are using sa
password then you can change it.
You can use sol profiler to trace wheather some one is using it or not
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Not sure what that means...sql n00b here...
but thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2O%23aEFqHHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi
> Take a look atv sp_password stored procedure in the BOL
>
>
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>|||Thanks, I will use profiler to check that out.
If no one or nothing is using SA, changing the password during production
hours won't affect anything?
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>|||I guess that I'm looking for SA in the LoginName or NTUserName Column?
I've been running it for five minutes, and never saw SA scroll by . . .
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>|||Hi Randy
It should be ok to change the SA password as you've suggested (I believed
from the Enterprise Manager?), as long as you are doing it using another
user with the sys admin permission on the SQL Server. As far as the impact,
I believe that as long as the sa account is not being used for any jobs or
application (which it should not as part of best practice), then I can't see
it have any major impact.
Thank you
Lucas
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Thank you for the input!!
I plan to change the password today.
Thanks again!
"Lucas Kartawidjaja" <luke_k@.hotmail.com> wrote in message
news:uSlN2AeqHHA.4100@.TK2MSFTNGP06.phx.gbl...
> Hi Randy
> It should be ok to change the SA password as you've suggested (I believed
> from the Enterprise Manager?), as long as you are doing it using another
> user with the sys admin permission on the SQL Server. As far as the
> impact, I believe that as long as the sa account is not being used for any
> jobs or application (which it should not as part of best practice), then I
> can't see it have any major impact.
> Thank you
> Lucas
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>>one production database is on this server and I've confirmed with the
>>vendor that the database is not using the SA account for anything.
>> Under Security, login, I see that I can r/c on SA and change the password
>> there.
>> Is that OK to do?
>> What's the impact of changing the SA password?
>> Anything else that I'm not thinking of'
>> Thank you!
>> Randy
>

Reset SA password

I have a need to reset the SA password on our SQL 2000 SP4 Server. Only one
production database is on this server and I've confirmed with the vendor
that the database is not using the SA account for anything.
Under Security, login, I see that I can r/c on SA and change the password
there.
Is that OK to do?
What's the impact of changing the SA password?
Anything else that I'm not thinking of?
Thank you!
Randy
Hi
Take a look atv sp_password stored procedure in the BOL
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of?
> Thank you!
> Randy
|||Not sure what that means...sql n00b here...
but thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2O%23aEFqHHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi
> Take a look atv sp_password stored procedure in the BOL
>
>
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>
|||Thanks, I will use profiler to check that out.
If no one or nothing is using SA, changing the password during production
hours won't affect anything?
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>
|||I guess that I'm looking for SA in the LoginName or NTUserName Column?
I've been running it for five minutes, and never saw SA scroll by . . .
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>

Reset SA password

I have a need to reset the SA password on our SQL 2000 SP4 Server. Only one
production database is on this server and I've confirmed with the vendor
that the database is not using the SA account for anything.
Under Security, login, I see that I can r/c on SA and change the password
there.
Is that OK to do?
What's the impact of changing the SA password?
Anything else that I'm not thinking of'
Thank you!
RandyHi
Take a look atv sp_password stored procedure in the BOL
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Hi Randy
If you are 100% sure that, none of your application or users are using sa
password then you can change it.
You can use sol profiler to trace wheather some one is using it or not
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Not sure what that means...sql n00b here...
but thanks!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2O%23aEFqHHA.3264@.TK2MSFTNGP04.phx.gbl...
> Hi
> Take a look atv sp_password stored procedure in the BOL
>
>
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>|||Thanks, I will use profiler to check that out.
If no one or nothing is using SA, changing the password during production
hours won't affect anything?
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>|||I guess that I'm looking for SA in the LoginName or NTUserName Column?
I've been running it for five minutes, and never saw SA scroll by . . .
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:e%23JhkEFqHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Hi Randy
> If you are 100% sure that, none of your application or users are using sa
> password then you can change it.
> You can use sol profiler to trace wheather some one is using it or not
>
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>|||Hi Randy
It should be ok to change the SA password as you've suggested (I believed
from the Enterprise Manager?), as long as you are doing it using another
user with the sys admin permission on the SQL Server. As far as the impact,
I believe that as long as the sa account is not being used for any jobs or
application (which it should not as part of best practice), then I can't see
it have any major impact.
Thank you
Lucas
"RandyH" <RHollaw@.HOTmail.com> wrote in message
news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>I have a need to reset the SA password on our SQL 2000 SP4 Server. Only
>one production database is on this server and I've confirmed with the
>vendor that the database is not using the SA account for anything.
> Under Security, login, I see that I can r/c on SA and change the password
> there.
> Is that OK to do?
> What's the impact of changing the SA password?
> Anything else that I'm not thinking of'
> Thank you!
> Randy|||Thank you for the input!!
I plan to change the password today.
Thanks again!
"Lucas Kartawidjaja" <luke_k@.hotmail.com> wrote in message
news:uSlN2AeqHHA.4100@.TK2MSFTNGP06.phx.gbl...
> Hi Randy
> It should be ok to change the SA password as you've suggested (I believed
> from the Enterprise Manager?), as long as you are doing it using another
> user with the sys admin permission on the SQL Server. As far as the
> impact, I believe that as long as the sa account is not being used for any
> jobs or application (which it should not as part of best practice), then I
> can't see it have any major impact.
> Thank you
> Lucas
> "RandyH" <RHollaw@.HOTmail.com> wrote in message
> news:B69508E4-AFC5-445C-9DD0-CD50054496B9@.microsoft.com...
>