On the server I can access my MSDE perfectly.
But, from a remote computer it seems impossible to connect.
Some (maybe) important information:
To create a user at my msde I used:
sp_addlogin (@. the MASTER DB)
sp_adduser (@. My DB)
sp_addrolemember (@. My DB)
Then I runned SVRNETCN.exe and enabled TCP/IP.
btw: I don't have a firewall running and both computers are on the same local network.is it trying to use windows integrated auth to connect, or mixed mode?|||It's configured for Mixed Mode...
I want to use sql-authentication and not windows authentication.
(it works localy, but not from an other computer)|||if it's running on a remote computer and U R using a firewall (XP...)
then try to open some port (1433) for the SQL Server DTS with the IP of the server...|||Nope, I don't have a firewall running...
I tried to telnet to 1433 to the MSDE, but even on the computer where my MSDE is running on, I can't get a telnet connection to 1433.
SQLServer uses tcp/ip, doesn't it?
I can't connect with VS.NET, Query Analyser, ... to my MSDE from an computer diferent than the computer that is running MSDE.|||I found out than my MSDE isn't 'registered' in my 'Data Sources (ODBC)'.
I registered it but...
It still doesn't work, but I think I am on the right spot :-)|||Ok, totaly wrong...
It has nothing to do with 'Data Sources (ODBC)'.
I tried everything!
It seems like MSDE isn't capable of listening at tcp/ip 1433.
Is this disabled in MSDE?|||try to check this:
on SQL Server configuration properties -> Connections
make sure the number is 0 (unlimited) or set it to 10 (for the test)
+
I did not hear U say U don't have a firewall on the server...|||I found it!!
I guess it's a bug in the install.
There is a key in the registry that contains no value:
..\MSSQLServer\SuperSocketNetLib\Tcp\tcpPort
The value has to be: 1433
But what if you have more than one instance?
You can't bind them all to the same port...
..\MSSQLServer\SuperSocketNetLib\Tcp\TcpDynamicPorts
It also doesn't contain a value...
No comments:
Post a Comment