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 |
|
WindChaser
Posting Yak Master
225 Posts |
 Posted - 2009-07-29 : 09:21:35
|
| Sorry to bother the forum with this but I've been at this for hours and can't figure it out.I've installed SQLServer 2005 on a new Windows Server 2008. I've configured the SQLServer so that TCP/IP and Named Pipes are enabled. The login is enabled, is granted access to the DBs and has all server roles. I can connect locally from the Windows Server 2008. However, I cannot connect from other local area network stations. All firewalls and protections are off for testing purposes. What am I missing? |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-07-29 : 09:22:24
|
| what is the error message?Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
 |
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2009-07-29 : 09:50:05
|
| Set conMasterDB = New ADODB.Connection With conMasterDB .Provider = "SQLOLEDB" .Properties("Data Source").Value = "NameOfServerStation\MySQLServerInstance" .Properties("User ID").Value = "sa" .Properties("Password").Value = "MyPWD" .Properties("Initial Catalog").Value = "Master" .Open End WithError message: SQL Server does not exist or access denied. However, it does exist given that I can access locally from the server station. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WindChaser
Posting Yak Master
225 Posts |
Posted - 2009-07-29 : 13:39:14
|
| Thanks Tara. Port 1433 was not specified in the IPAll section of the network protocols. But why isn't it there by default upon installation given that SQL Server connections default to 1433 by design? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Can't connect remotely