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 |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2009-04-29 : 07:59:23
|
| hi all,i have an issue with remote connections on SQL2005 (SQL-01).We are trying to install Sharepoint on the remote server (WEB-1)When the developer is installing Sharepoint it errors out with the following message (Part of message):System.Data.SqlClient.SqlException: Login failed for user 'USERACCOUNT'This is where i get involved......I have confirmed on the instance • TCP/IP and Named pipes in surface area config tool.• The port number is 1280 as the default port number is used by another instance on the same sql box.• named pipes is enabled.• SQL Server properties remote connections are enabled.I created and ODBC Connection to the box and a UDL connection, i inputted the relevant information:Servername\instanceDomain\UsernamePasswordand it returns the following error....Microsoft Data Link Error Test connection failed because of an error in initializing provider. login failed for user ''Strange thing is using the same connection if i change it to use integrated security it works and it says "TEST Succeeded".and the same with a SQL Account its only when i use a domain account and try and connect it fails.Kind regardsPeteKind RegardsPete. |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-05-01 : 04:42:52
|
| Kerberos Issue.......Added relevant SPN'S to authenticated list and works fine....Thanks for looking.Kind RegardsPete. |
 |
|
|
|
|
|
Remote connections.....