August 14, 2007 at 3:44 pm
(Standard edition of sql2005 on my PC)
Trying to set up a JDBC connection via WebSphere Data Sources to access a database on a sql2005 test machine and getting this error:
Cannot connect to SQL2005TEST.
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: Named Pipes Provider, error: 40
Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
Error Number: 1326 Severity: 20 State: 0
I have updated the server to allow both local & remote connections using both tcp/ip and named pipes using SQL Server Surface Area Configuration. Any feedback would be greatly appreciated.
Lisa
August 15, 2007 at 9:09 am
Lisa,
do you have the SQL Server client tools installed on the machine from which you are having the connection problem? If yes, can you connect from this machine to the SQL Server using any of these client tools (osql, Management Studio)?
Also, is the database instance a default instance? If it is not, have a look if the "SQL Server Browser" service is running on the server.
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply