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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-20 : 13:29:34
|
| Vijay Mehta writes "Hi,I posted the following question a short while ago:.........................I have installed SQL 2005 on a Win XP SP2 laptop which already had SQL 2000 installed and working fine.I have created a new database with SQL 2005 and setup a user with db_owner and public rights to the newly created database.I am now having trouble in setting up a Data Source via Control Panel --> Administrative tools --> Data Source (ODBC).The data source that I already had for my SQL 2000 databases connects ok with the SQL 2000 db.All my attempts to set up a data source against the SQL 2005 are not working and cannot connect to the SQL 2005 database.When in the Data source, System DSN Tab, the list of drives only show SQL Server, so I presume this is the only driver to select irrespective of SQL 2000 or 2005.Please let me know what you think the problem might be. I am running into issue as I have two versions of SQL on same machine or do I need to do something else.For your reference I need the Data Source for connection from Progress Software to SQL 2005 db.......................I missed it before but do have SQL Native Client which I have tried to use from the Data Source config screen.The errors I get are as follows:Connection failed:SQLState: '08001'SQL Server Error: 1231[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [1231]Connection failed:SQLState: 'HYT00'SQL Server Error: 0[Microsoft][SQL Native Client]Login Timeout ExpiredConnection failed:SQLState: '08001'SQL Server Error: 1231[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failer may be caused by the fact that under the default settings SQL Server does not allow remote connections.I am unsure how to resolve this issue. Please advise.ThanksVijay" |
|
|
|
|
|
SQL 2005 connection error