problem in connecting to MSDE database from the same domain

Hi!
I have installed MSDE 2000 in "Mixed Windows and SQL mode authentication with network access" .following is the command:

setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="password" INSTANCENAME="TempInstance" SECURITYMODE=SQL

Then I created the database TempDB in it.

When I try to connect this database from my program running on my machine , it works fine. But when i try to connect to it from the same program running on a different machine on the same domain.It gives error:

"SQL Server does not exist or access denied ."

Even when i run the same program in my machine to access the same TempDB database on a remote machine that is not in my domain, it works fine.

this is my connection string:
Data Source={Database server's IP Address}\TempInstance;Initial Catalog=TempDB;User ID=sa;PWD=password;

Please help.

KT.What's the operating system for the client from which you are unsuccessfully attempting to connect? What version of MDAC is running on it?

Also, be aware that a named instance install of MSDE will set up to run on a non-default port (ie, not 1433). You can verify your connectivity by determining what port the SQL listener is running on and then using telnet {ip address} {port} from your client machine. You may need to account for the alternate port on your client machine. You can set up an alias for it by running cliconfg at a command prompt on your client machine.

Regards,

hmscott|||Thanks hmscott!

Actually my problem was caused by windows firewall.

regards.
Kuldeep.

Problem in connecting Sql Server to ASP.NET

I installed SQL Server in My P.C using MSDE.
it is acted as local server.
All are working fine (SQL Server and .NET)

when i am trying connect the Sql Server in .net,
i got the Error Message

"Login failed for SA/"

i am trying to Windows authentication mode,
it also gives the error like,

" login failed for Sqlserver name/asp.net"

can any one give the solution for that?

thanks in advance.

regards,
Murugavelyou need to add a user machinename/ASPNET in the users tab under your database sql server enterprise manager.

hth|||am using microsoft biztalk server but i cant see the user tab under my administration? i cant see also the server enterprise manager on my mssql. please help.|||Hi ndinakar ,

i have already created User Account in Enterpriase Manager,It is working fine in SQL SERVER
but still i got the same error message "Login failed" when connecting from ASP.NET

What is the problem?

regds,
Murugavel

Problem in connecting after service pack 3a installed in MSDE 2000

Hi All,
I have installed MSDE 2000 server and i installed service pack
3a. The server machine has SQL Server 2000 client connectivity. When i
connect from client machine to Server machine it is showing error.
[Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
SQL Server does not exists or access denied.
I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
Any suggestion would be greatly appreciated.
Regards,
A.Chellam.How do you connect? Try specify the IP for the server/data source and see if
you
can connect.
-oj
http://www.rac4sql.net
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>|||Verify on the MSDE machine using Server Network Utility what netlibs it is
listening on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"chellam" <chellammal@.touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
> Any suggestion would be greatly appreciated.
>
> Regards,
> A.Chellam.
>
>

Problem getting information regarding the application connected to

I am using MSDE 2000 ,
I would like to get information from master..sysprocesses table
to see what programs are connected to the database.
I would to verfy how many times a particular program is connected to the
database
Lets say i would like to check the number of times program X is connected to
the
database.
The select statement is like Select * from master..sysprocesses where
program_name ='X'
but unfortunately whenever i connect using programX , the Program_name field
is Empty.
So I am unable to compare against the program name. Is there any other table
from which
i can gather consistent information? Any workaround would also be welcome.
Thanks in advance
Prakash
hi Prakash,
Prakash wrote:
> I am using MSDE 2000 ,
> I would like to get information from master..sysprocesses table
> to see what programs are connected to the database.
> I would to verfy how many times a particular program is connected to
> the database
> Lets say i would like to check the number of times program X is
> connected to the
> database.
> The select statement is like Select * from master..sysprocesses where
> program_name ='X'
> but unfortunately whenever i connect using programX , the
> Program_name field is Empty.
> So I am unable to compare against the program name. Is there any
> other table from which
> i can gather consistent information? Any workaround would also be
> welcome.
> Thanks in advance
> Prakash
ADO automatically provides this kind of information to SQL Server, where
SQL-DMO requires you to explicitely set it like
objServer.ApplicationName = App.EXEName
can you please check your data access model?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply