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 |
|
bkimm
Starting Member
3 Posts |
 Posted - 2011-07-19 : 11:09:24
|
| I recently upgraded from SQL Server 2008r2 express to SQL Server 2008r2 developer. I had been successfully running a vwd website on server running IIS 7. Now I cannot connect from app. I can telnet to sql server via port 1433 but cannot connect. I have tried connection strings specifying the server/instance name and also using tcpip and port. Neither works. SQL Browser is started and I am trying to run the app from the "browse" function in iis so firewall should not be the problem. In any case, it is not active. I have been browsing the net for 2 days now to no avail. Any help would be greatly appreciated.Bill Kimmel |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-19 : 11:15:26
|
| SQL Server service is running?Remote connections enabled?Can you connect to SQL Server via SSMS using same credentials being passed in your connection string?What error message are you seeing? |
 |
|
|
bkimm
Starting Member
3 Posts |
Posted - 2011-07-19 : 11:20:10
|
| I can connect via smss with same credentials. I see the "A network-related or instance specific erro occurred while establishing connection to sql server...." error. SQL Server Service is running. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-19 : 11:39:30
|
| Make sure servername\instancename is correct in connection string. Make sure firewall is off, or allowing SQL Server on port 1433.Are there other instances on the machine? Is this isntance listening on 1433? |
|
|
|
bkimm
Starting Member
3 Posts |
Posted - 2011-07-19 : 12:26:04
|
| Thanks for the quick reply. The servername is the same name I can successfully use to log in to sql mgmt studio. Instance name is same as in registry. Also, I have tried using IP address and 1433 in connection string. Does not seem to make a difference. Firewall is off and there are no other instances of sql on machine. The instance is listening to 1433, I believe. I checked in sql server network configuration and the IP address and port are listed and active. Is there somewhere else I should check? |
|
|
|
|
|
|
Error Locating Server/Instance Specified