Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
justin
Starting Member
7 Posts |
 Posted - 2003-01-15 : 15:34:05
|
| Alright, I am having a very difficult time with SQL Server lately. I am trying to connect to a SQL Server from ASP and Enterprise Manager running on the same machine.On this single machine, I have configured the Client Network Utility and the Server Network Utility to use only TCP/IP. All other network protocols are disabled. However, when I attempt to connect using either 127.0.0.1 or the server's real IP, I get the following error: SQL Server does not exist or access denied.What's more, in some of the older SQL Server logs, I can see the message "Now listening on 127.0.0.1:4343, xx.xx.xx.xx:4343" or something similar, but none of the recent startup logs show that.Can anyone help? |
|
|
justin
Starting Member
7 Posts |
Posted - 2003-01-15 : 15:38:44
|
| Ah, one more thing. I forgot to post the entire error message:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.From the message, you can see that the client, at least, IS using TCP/IP. It appears that it is just the server, right?Justin |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-01-15 : 16:02:38
|
| Sounds like your hitting "access denied" Be sure to check your password. Are you using intergrathed authentication or SQL authentication?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
justin
Starting Member
7 Posts |
Posted - 2003-01-15 : 16:09:45
|
| I am using SQL authentication. What I forgot to mention is that I can connect to the SQL Server if I use the server name "BEAST"...So I know the user/pass is correct.Justin |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-01-15 : 16:27:33
|
| Well, I'm at a loss then.Post both of your connection strings with a mock username and password. Maybe that will show us where the problem is.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-15 : 18:08:07
|
| Your SQL Server isn't listening on the default port. Your SQL Server is listening on 4343. You will need to add an alias to the Client Network Utility and specify the port. Just add an alias, server alias is the name that you want to call this SQL Server (it doesn't have to be its real name), server name is the IP address, then add 4343 as the port. Oh and make sure that you select TCP/IP. I believe that you should also be able to connect to SQL Server like this: xxx.xx.xx.xx,4343. Just modify the x's to your IP address. |
|
|
|
|
|
|
|
|
Connecting with IP Address