No Server Connection
-
First off, I'm brand new at this. Mainframe programmer for 12 years.
I'm trying to connect to the server and all I get is "cannot connect to (server name). I also get "40-Could not open a connection to SQL server.
I apologise for the simplistic nature of this post but 'help' is not providing answers and the books are worse. Thanks in advance.
-
Hello,
Can you test if the server is running? (ping...)
What kind of technology you use to connect to sql server (ado,ado.net,oledb,odbc,...) ?
-
Andy,
There could be lots of things wrong. You just don't give us enough information on what you are trying to do.
1. are you on the same network as the SQL Server?
2. As Jo asked, how are you trying to connect? What front-end application are you using?
3. How is the SQL Server set up? What TCP port is it using? Do you have a login on SQL Server? What type of authentication is SQL Server using?
4. Is the SQL Server up and running? If you can ping the server, that only means the server itself is reachable.
Once we know those answers, we can narrow down the problem.
-SQLBill
-
This is a very good KB on connectivity to SQL Server.
http://support.microsoft.com/kb/827422/en-us
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply