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 |
|
gav1ns
Starting Member
3 Posts |
 Posted - 2007-06-11 : 04:23:37
|
| Hi , I develop all my sql code locally, and have set up two linked servers, which I can successfully query whilst logged on with Windows authentication.If I login with the sql logons (which are mirrored on the two linked servers both usernames are the identical and passwords also) I have created for the applications I am writing, 1 server (non clustered) correctly responds with the dataset and the other server (clustered) keeps telling me SQL Server does not exist or access denied.On the server which says access denied, I can login to this box with the sql username and password and execute the query successfully, but it will not let me run the queries from my local development pc.Can anyone help or does anyone have any suggestions on what to check?thanks in advance. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 06:11:46
|
| Are you perhaps getting logged on to the local server using Windows Authentication, rather than SQL Login? (i.e. even though you may be filling in a Login UserID / Password maybe you are ACTUALLY getting a Windows Authentication connection? To the best of my knowledge you will NOT get a Windows Authentication if you connect using Query Analyser and use Q.A.'s "Login" dialog box for the UserID you want to test)If that doesn't work I would recommend dropping the existing Linked Server stuff and making a new one "just to be sure" !Kristen |
 |
|
|
gav1ns
Starting Member
3 Posts |
Posted - 2007-06-11 : 06:42:43
|
| Hi , I meant to mention that I am logging in to QA using the sql logins rather than the windows authentication, this behaviour is occurring on the sql logins through QA.I have dropped the linked servers and re-created and as before the 1 server still works correctly and the other still gives me the SQL Server does not exist or access denied.G. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-11 : 06:49:06
|
| Have you mapped your local logins with the remote logins using sp_addlinkedsrvlogin system stored proc ?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
gav1ns
Starting Member
3 Posts |
Posted - 2007-06-11 : 07:17:03
|
| Hi, Yes I have mapped the logins using the stored procedure, and I still get the error SQL Server does not exist or access denied.G |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-11 : 07:48:11
|
| If you TS into Server1 and FROM THERE use QA to connect to Server2 how does that behave?It might be some crafty settings in your Client Aliases that is allowing a connect, which is absent from Server1's settings. e.g. a non-standard Port for SQL to listen to on Server2Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 18:05:15
|
| Did you map to valid sql login on linked server? How does the security page look like in linked server properties? |
|
|
|
|
|
|
|
|
SQL Linked Servers