Allow internet and EM Access (troubles) ...
-
Hey guys !!
As you'll see, i'm not only a newbie posting in this forum, with SQL Server too !.
Here's the situation...
The machine is configured with Win2k3 Server and SQL Server 2000 SP3a. I have opened the standard 1433 and 1434 ports and in the Server Network Utility enable the TCP/IP Protocol (Obviously listening the 1433 port). Aditionally, i´m not behind a firewall. The server authentication is mixed (Windows and SQL) and it's accepting RPC connections. Shortly... all opened !
Even though, i can´t access the Server via Enterprise Manager or any standard ASP query neither !!! A connstr like this:
"Driver={SQL Server};Server=IPAddress=;Database=MyDB;UID=sa;PWD=MyPWD;".
Any advice ?!. Aditionally, how can i enable an alias (like sql.domain.com) instead the IP address in the above connStr ?!.
Sorry, and .... Thanks in advance !!!!!!!!!!
-
First try to PING the SQL Server machine from your client machine.
Start>Run type cmd and click ok. Then at the prompt type PING servername and see if that returns anything. Replace the servername with the name of the SQL Server. If that fails, try PING ipaddress. Use the IP address of the SQL Server. If the IP address works and the name doesn't, the issue is with the DNS server. You don't have name resolution set up and must use the IP address of the instance for the connection to work.
Second, a security issue. The SA account is the GOD account. Do NOT let your applications use that account. Look into application roles in the BOL.
-SQLBill
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
-
Hey !!
After some investgation maybe this can be the problem. Here are some clues:
In the ErrorLOG:
SQL server listening on Shared Memory, Named Pipes.
SQL Server is ready for client connections.
In the response of the webserver:
[Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied.
Still without any resolution ... anyone got an idea ?!
Thanks again for your help !!!!!!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply