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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2010-12-16 : 05:05:03
|
| I'm setting up sql 2008 on a new windows 2008 server. I have named pipes enabled and I still keep getting the following error:what do I need to change?A network-related or instance-specific error occured while establishing a connection to SQL serer. The server was not found or was not accessible. Verify that the intance name is correct and that SQL Server is configured to allow remote connections. |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-16 : 05:10:56
|
| Is the SQL Server up and running (You can check the same from service manager ) ?How you are trying to connect ? |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2010-12-16 : 05:15:24
|
| yesand I can connect on the server using windows authenticationI cannot connect locally to the server or from asp to the server. |
|
|
|
the_amol
Starting Member
6 Posts |
Posted - 2010-12-17 : 04:14:07
|
| Make sure under server network configuration you have enables named pipes and tcp/ip protocols.and use fully qualified name of server and databse eg.servername or ip\databasename in servername field for connection.Thanks & RegardsAmol Vermahttp://cybertechhawks.wordpress.com |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2010-12-19 : 01:42:58
|
| I solved this the problem was the firewall was blocking port 1440 |
|
|
|
|
|
|
allow remote connections