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 |
|
kpgraci
Yak Posting Veteran
68 Posts |
 Posted - 2012-03-27 : 11:01:51
|
| Server crashed so I had to re-format and reinstall prior to this all was working. - here's the setup:Server 2003 with latest spSql server 2008 R2Management studio installedI can asscess sql server form server using mgmt studio.In studio I did this:Made sure rmote connects were onallowed windows auth and server authenabled sa account and set password (don't need a lecture here :0)In config utility did this:enabled tcp in server config programnoticed tcp port was blank so added port 1433 in three placesrestarted serverfirewall on server 2003 is not runningopen mgmt studio from a workstation on the LAN, browse for server - it does not show up. If I manually type the machinename\server get error message (well, it could not find it after all).what am I missing????thanks.kpg |
|
|
kpgraci
Yak Posting Veteran
68 Posts |
Posted - 2012-03-27 : 11:34:58
|
| RESOLVED. Strange...I changed absolutly nothing, and now, 15 minutes later it is showing up in both visual studio 2010 and sql mgmt studio 2008 as an available server and it all works fine.Why the delay???anyway, problem resolved...kpg |
 |
|
|
|
|
|
sql remote connection problem