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 |
|
krugs525
Starting Member
3 Posts |
 Posted - 2010-07-14 : 11:36:47
|
| I have a ASP.NET MVC website in IIS 7 running against a SQL Server 2008 R2 database, in which I have a linked server set up. The linked server is set up so that a SQL account from my database is linked to a SQL account on the linked server.All works fine until I recompile my website, and then it can't connect to the linked server anymore and I get this error:Named Pipes Provider: Could not open a connection to SQL Server [5].To fix it, I have to open the linked server properties in SQL Server and re-enter the password for the SQL account on the linked server in the Properties dialog and then everything will work again.Any idea why I have to do this each time and what I can do to fix it? It's like something is going in and messing with linked server security credentials that I set up in the linked server Properties dialog. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-14 : 11:40:18
|
| Sorry, don't know the answer, but we always disable Named Pipes for linked server connections - and only use TCP/IP. No idea if that is related though. |
 |
|
|
krugs525
Starting Member
3 Posts |
Posted - 2010-07-14 : 11:49:18
|
| Unfortunately I'm not really in charge of that situation, which is why I'm using named pipes. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-14 : 12:03:16
|
| Its a setting in Configuration Manager - where the Alias (for the Linked Server) is set up (just in case you have access to that - if you can get to the place where you change the password then I figure there is a fair chance you can get to that too!) |
|
|
|
krugs525
Starting Member
3 Posts |
Posted - 2010-07-14 : 12:17:34
|
| I don't have admin access to the remote SQL server that I'm trying to connect to. I just have a SQL account that is has limited privileges. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-14 : 12:46:12
|
Ah, sorry, makes sense now. Try saying "pretty please" to the IT folk?  Mind you, I have no idea if this would be a fix, or not, just that my recollection is that Named Pipes is flaky for cross-server connections but I can't remember any details, but perhaps others here will Agree/Disagree with me? |
|
|
|
|
|
|
|
|
Error connecting to linked server