April 29, 2009 at 6:02 am
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\instance
Domain\Username
Password
and 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.
April 29, 2009 at 8:59 am
it looks to me you've setup an ODBC connection with SQL authentication, and you are trying to use a WINDOWS account to authenticate.
You need to either setup your ODBC as windows authentication (and no matter what you type in the UDL file works using the current user context it's running as), or you setup with SQL authentication and use and SQL account in the UDL to authenticate.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply