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 |
|
bhuvnesh.dogra
Starting Member
22 Posts |
 Posted - 2008-08-13 : 01:11:10
|
| hi,when ever i execute a sp it gives this error withaddition of "execute as login = 'cvent\sqlman'"ERROR:OLE DB provider "SQLNCLI" for linked server "domain\DEV" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "domain\DEV" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".Msg 65535, Level 16, State 1, Line 0SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Please suggest why this happening??? |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-13 : 02:30:09
|
| Are you sure the server is up & can be accessed via the network? Try ping for example. |
 |
|
|
bhuvnesh.dogra
Starting Member
22 Posts |
Posted - 2008-08-13 : 05:58:52
|
| if i runn the script without using "execute as login = 'cvent\sqlman'" it runs fine on managemant studio .but this script is actually runs in JOB and that time it gives error.Please suggest |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-13 : 12:39:11
|
| Does SQL server agent account has access to it? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 23:24:42
|
| Does job owner have sysadmin rights? |
|
|
|
|
|
|
Error Locating Server/Instance Specified