MSSQL 2000 - cant connect to DB from remote computer

Please bare with me as I do not have much knowledge in this area with MSSQL.

I have installed MSSQL 2000 Developer and I have setup a database which I am able to connect to and work fine with from the actual server MSSQL is installed on.

The problem comes in when i try to connect to that same database from a different remote server. It will not connect to the DB from this remote server but I know all the connection information is correct so its something on the MSSQL DB server causing this and not on this remote server.

Someone I know has had this problem and has fixed it but they wont tell me how. All I know is they said something about manually opening the ports on the MSSQL server and he also said when you set it to dynamicly determine the port that MSSQL is listening on it errored out. however if you set it staticly to 1433 it worked fine.

Ive also installed SP4 in attempt to fix this but no luck with that either. And I can also get the same exact remote server to connect to completely different DB server without issues.

If anyone can please help walk me through this I would be greatly appreciate and I am also willing to pay some money if it will make my life easier.Can "Developer Version" be connected from a remote client?|||While these (http://msdn2.microsoft.com/en-us/library/ms175043.aspx) directions are specifically for SQL 2005, I'm pretty sure that they'll work for SQL-2000 too.

-PatP|||Ronin- Yes it can be done.

Pat- The firewall is completely disabled. It says Windows Firewall and ICS(internet connection sharing) is disabled when I try to go to the firewall settings so I dont think thats the problem unless I have to enable it and then do this but that doesnt make much sense.|||can anyone help?|||Which SQL network libraries did you select?

-PatP|||named pipes, tcp/ip, nwlink ipx/spx, VIA giganet

msg18452 login failed

Hi.. all
after I connect sql I got the message "msg 18452 Login failed for user 'tt'. Reason : not associated with trusted sql server connection"
I should fix the problem, how?? please suggest me...
Thanks ppplease check for your server configuration(in Alias tab, what's network libraries used) in Client Network Utility ! is the server name was correct, if the server configuration
was correct may you check with which user you are connected !

may this help !

4ndr3.

Msg 7619, Level 16, State 1, Line 1

i have a C# program which connect to sql 2k
each time i use any arabic word in search i got the following error
Msg 7619, Level 16, State 1, Line 1
*** Sent via Developersdex http://www.codecomments.com ***
what are your globalization settings in your web.config file? Try something
like.
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
culture="ar-SA" uiCulture= "ar" />
Also is your page template directive setting the following?
<%@. Page ResponseEncoding="UTF-8" RequestEncoding="UTF-8" Culure="ar-SA"
uiCulture="ar" %>
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Amaal Ali" <eng_moli@.hotmail.com> wrote in message
news:uc4R3cHGGHA.3952@.TK2MSFTNGP10.phx.gbl...
> i have a C# program which connect to sql 2k
> each time i use any arabic word in search i got the following error
> Msg 7619, Level 16, State 1, Line 1
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Thanks Alot Mr Hilary Cotter about ur concerning
but i got this msg through Query Analyzr not program only
finally i got the soluation
as
i have to set the "language for word breaker " to Neutral option
when i add the required column to My index Catalog
Thanks Again
*** Sent via Developersdex http://www.codecomments.com ***
|||Thanks Alot Mr Hilary Cotter about ur concerning
but i got this msg through Query Analyzr not program only
finally i got the soluation
as
i have to set the "language for word breaker " to Neutral option
when i add the required column to My index Catalog
Thanks Again
*** Sent via Developersdex http://www.codecomments.com ***

Msg 18456 - login failure - sql server

Hell,

My ISP has just given me the username and passwords to connect to my sql server site.

However after setting up the ip and tcp and 1433 in the client network utility and trying to connect to the site via the query analyzer (and later EM) I am getting this wierd message:

Msg 18456, level 16...Login failure Sql Server not found...

Not I am almost absolutely sure the login username and password is correct; I have tcp/ip enabled and I am not behind a firewall.

Anyone got some ideas?

Much appreciated. If you have the silver answer could you please email me at jason@.silverscape.co.za - awesome.

JasonHow are you connecting to the server, with a name (ie ISP_Server) or with and IP address (ie. 111.111.111.111)?
[list=a]
Using the SQL Server Client Netwrork Utility verify that TCP/IP is enabled
If connecting with a name, can you PING the name from DOS? If not can you ping the IP address?
If you can ping the IP address, but not the name, add an alias using SQL Client Network Utility
[/list=a]|||Hi... thanks for quick reply and advice...

Okay:

1. The ISP provided me with an alias/name rather than a IP.
2. I tried pinging the name and had no problem...
3. I copied the IP address from the ping and replaced the name in the Client Network Utility...
4. I made sure TCP/IP was enabled...
5. Tried connecting through the SQL Query analzyer...

But got the same damn error message: "Unable to connect to server...Msg 18456, Level 16, State 1...Login failure

Got anymore ideas. The address is pingable; TCP/IP is enabled; I appear to have the right login details....what now?

Very wierd..
Jason - Cape Town

MSDTC on server <ServerName> is unvailable

Hi,
I have an issue when a client tries to connect to an
application, he gets the error message saying:
"MSDTC on server <ServerName> is unvailable"
for now, we are using two methods to work around the
problem:
- uninstall and re-install the MSDTC service on the server
- rebbot the server
Can anyone help please?
Verify that you have Netbios Name Resolution working in both directions.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

MSDTC on server <ServerName> is unvailable

Hi,
I have an issue when a client tries to connect to an
application, he gets the error message saying:
"MSDTC on server <ServerName> is unvailable"
for now, we are using two methods to work around the
problem:
- uninstall and re-install the MSDTC service on the server
- rebbot the server
Can anyone help please?Verify that you have Netbios Name Resolution working in both directions.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

msdtc config / sql server 2k cluster(sp4) / W2k3 sp1

I have an application that uses com components to connect to it's backend sql
server db. Right now the db is running on a W2k server (sp4)
(non-clustered). I've copied the dbs to the clustered environment that we
are migrating all of our databases to, and now the com components do not
connect. I've installed the Network DTC components and have configured the
MSDTC resource via Cluster Adminstrator and can see that the service starts
on each server in the node as I fail the cluster group between those nodes.
I've read and adhered to doc 301600 and it's sub article of 817064
(pre-reqs). Not sure what else may be wrong or that I need to validate. The
application returns the following error when the user tries to login via the
web portal: New transaction cannot enlist in the specified transaction
coordinator. The application runs on a W2k (sp4) server. Any guidance would
be greatly appreciated.
It isn't anything to do with the cluster. This would happen on a stand-alone
system anyway.
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server
2003
http://support.microsoft.com/default...b;en-us;555017
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"LufkinTXDbajohn" <LufkinTXDbajohn@.discussions.microsoft.com> wrote in
message news:A0E2373E-5E90-45B2-B3EA-9BD32F6D4ABB@.microsoft.com...
>I have an application that uses com components to connect to it's backend
>sql
> server db. Right now the db is running on a W2k server (sp4)
> (non-clustered). I've copied the dbs to the clustered environment that we
> are migrating all of our databases to, and now the com components do not
> connect. I've installed the Network DTC components and have configured
> the
> MSDTC resource via Cluster Adminstrator and can see that the service
> starts
> on each server in the node as I fail the cluster group between those
> nodes.
> I've read and adhered to doc 301600 and it's sub article of 817064
> (pre-reqs). Not sure what else may be wrong or that I need to validate.
> The
> application returns the following error when the user tries to login via
> the
> web portal: New transaction cannot enlist in the specified transaction
> coordinator. The application runs on a W2k (sp4) server. Any guidance
> would
> be greatly appreciated.