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 |
|
vgr.raju
Yak Posting Veteran
95 Posts |
 Posted - 2006-06-19 : 18:04:00
|
| Hello Experts, I am trying to connect to the Named sql instance.If I use the ServerName\Instancename,PortNumber ,It works.(Rajuvenkat\instance1,52004).If I don't give the Portnumber(Rajuvenkat\instance1),it does not connect and throws the following error 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)I am using the @@servername in my sql jobs to fetch the Jobserver name.At times it works and other times it throws the above error.Not able to comprehend the SQL Server Connection Behavior.(What I understand from the articles is I have to give the Port number for the named instance if its different from the default port.(1433,1432)..I am not sure.)Any help and pointers to the relevant articles would be greatly appreciated.Thanks in advance! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
vgr.raju
Yak Posting Veteran
95 Posts |
Posted - 2006-06-19 : 22:41:56
|
| Thanks Jen.After reading your links,it seems like SQL Server Bug,which they decided not to fix. |
 |
|
|
|
|
|
Connecting to the Named Instance