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 |
|
13WebStreet
Starting Member
2 Posts |
 Posted - 2009-06-16 : 11:44:41
|
| Hi.I am trying to access SQL server 2008 remotely from a SSMSE instance of 2005.I have set it up to allow remote connections, i have added sql browser to the firewall as an exception and enabled the named pipes and tcp/ip(port 1433) but it still won't connect.I keep getting the same error 40.Help please...Regards,Jean-Philippe Chenot | Web Developerhttp://www.13webstreet.co.uk |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2009-06-17 : 08:29:33
|
| Is the 2008 server a named instance? |
 |
|
|
13WebStreet
Starting Member
2 Posts |
Posted - 2009-06-17 : 11:13:56
|
| Hi.I am not entirely sure how to find out as it was installed on the server when I took it. But the path is as follows: C:\Program Files\Microsoft SQL Server\MSSQL10.S15313547\MSSQL. I read that if it is called MSSQL it is a default instance. Altough it has a name such as S135753\S135753.ThanksRegards,Jean-Philippe Chenot | Web Developerhttp://www.13webstreet.co.uk |
|
|
|
|
|
|
Remote Access