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 |
|
andriancruz
Starting Member
38 Posts |
 Posted - 2008-11-08 : 05:55:56
|
| Dear Everyone,Do you have any idea what should i do to my problem. I want to use the command osql -E in the dos prompt. but the problem is giving me a error. please see error below.["SQL Native Client]Login timeout expired[SQL Native Client]An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may be caused bythe fact that under the default settings SQL Server does not allow remoteconnections."I search from the internet, and giving me some instruction to settings some setup in the surface are configuration. but when i click the remote configuration throwing me the error. please see the error below"You cannot configure surface area of clustered services by connecting to computer name. connect to the virtual server to configured cluster services"Can anyone help me. how can i use the osql -E command in the dos prompt. cause in the other server i can use that command without any problem. our db is clustered.Any suggestion will highly appreciated. thank you in advanceAndie |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-08 : 07:38:47
|
| At the Surface Area Configuration application you will see "Change Computer" option. Select this one and then select Remote Computer.Then write you virtual server name. After that you will be able to see Surface Area Configuration. |
 |
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2008-11-10 : 05:48:07
|
| Thank you very much lionofdezert |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-11-10 : 05:58:35
|
| u welcome |
|
|
|
|
|
|
Database (Clustered)