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 |
|
quarinteen
Starting Member
40 Posts |
 Posted - 2008-01-16 : 21:25:22
|
| I have a server with sql 2000 and 2005 installed on it. When I try to connect to the msde 2000 database with an app or with managment studio express I get the following error"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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476"But When I go through dos and type osql -S(local)\database -E it connects to the correct msde instance. How can I fix this with out uninstalling sql server 2005???? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-16 : 23:19:31
|
| Did you specify correct instance name in ssmse? |
 |
|
|
quarinteen
Starting Member
40 Posts |
Posted - 2008-01-17 : 01:16:50
|
| Yes., when im connecting in management studio.. |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-01-17 : 05:45:16
|
| Do you give the SA as username for that application.RKNAIR |
|
|
|
quarinteen
Starting Member
40 Posts |
Posted - 2008-01-17 : 11:04:56
|
| I dont know how to explain this I have msde 2000 that all my apps ran on. They worked fine.. I installed sql 2005 and with out reconfiguring my apps they want to try to connect to the sql server 2005. So before they were connecting to for example sql2000\database but now that I have installed sql 2005 they are tring to connect to sql2005\database so I am getting this error because the instance name it it tring to connect to is not on the sql 2005 server I am running other databases on the sql 2005. I am very sorry if I can not explaint this well. |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-17 : 22:33:32
|
| questions need to answer1. Is the server name is hard coded in connection string. 2. Is SQL 2000 is still there with same instance name if it does then u have to rename 2000 and give that name to 2005. because application is looking for instance name what is in the connection string. if u don't want to do this then make changes in connection string. give what ever the name of 2005 server |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-18 : 17:41:43
|
| configuration tools, sql server configuration manager check the tcp/ip and named pipes, and via...i recall this happening to me and i turned off via and it seemed to work, make sure tcp/ip ticked..and all others well mine are all ticked. |
|
|
|
|
|
|
Conflicting Databases