Sql Server does not exists or acces denied
-
Hi, I have an application running on a server. I have ported this application to other server but it gives me the above error Sql Server does not exists or access denied error.I would like to know if i have to make any changes to the connection string. Can any one help. Thanks in advance, Nitin.
-
Hi, I have an application running on a server. I have ported this application to other server but it gives me the above error Sql Server does not exists or access denied error.I would like to know if i have to make any changes to the connection string. Can any one help. Thanks in advance, Nitin.
Hi, It should not be a problem, does you connection string look like this:
data source=MYDEVSERVER;initial catalog=northwind;user id=sa;password=1234dev;Trusted_Connection=False";HTH, Thea -
Hi, It should not be a problem, does you connection string look like this:
data source=MYDEVSERVER;initial catalog=northwind;user id=sa;password=1234dev;Trusted_Connection=False";HTH, Thea -
Hi, I have an application running on a server. I have ported this application to other server but it gives me the above error Sql Server does not exists or access denied error.I would like to know if i have to make any changes to the connection string. Can any one help. Thanks in advance, Nitin.
So is the SQL and the application on different computers? Can you connect to this SQL server from the computer on which the application resides? Let's say through Query Analyzer? Your connection string looks fine. Where does your connection string reside? Web.config? Try connecting to another SQL Server from your application. HTH, Thea
-
So is the SQL and the application on different computers? Can you connect to this SQL server from the computer on which the application resides? Let's say through Query Analyzer? Your connection string looks fine. Where does your connection string reside? Web.config? Try connecting to another SQL Server from your application. HTH, Thea
Hi, sorry for responding late, as i said i have ported to application to a server which has windows 2003 installed on it and the Msde and .net framework which are built apart from theese i dont have any tools on the server from which i access the database which is onto a different server now i had a doubt whether do we need a sql Client installed on our machine or we could do without it and also i have written the code into Web.config file which runs well when i run it through my local machine and it connects to the database.but when the same file put on the server flashes me the error ,I hope i am being more explanatory and not confusing. Thanks in advance Nitin.
-
Hi, sorry for responding late, as i said i have ported to application to a server which has windows 2003 installed on it and the Msde and .net framework which are built apart from theese i dont have any tools on the server from which i access the database which is onto a different server now i had a doubt whether do we need a sql Client installed on our machine or we could do without it and also i have written the code into Web.config file which runs well when i run it through my local machine and it connects to the database.but when the same file put on the server flashes me the error ,I hope i am being more explanatory and not confusing. Thanks in advance Nitin.
Hi Nitin, You don't have to install Sql Client. If I understand correctly you have application1 on your local machine and it connects fine to MSDE db1 on win2003 server. But when you move application1 to win2003 server it does not connect to MSDE db1? If it was the other way around there could be more reasons, but I'm real sorry, I don't have an answer here. :(( I did get this link, maybe it can help you. Good luck, Thea
-
Hi Nitin, You don't have to install Sql Client. If I understand correctly you have application1 on your local machine and it connects fine to MSDE db1 on win2003 server. But when you move application1 to win2003 server it does not connect to MSDE db1? If it was the other way around there could be more reasons, but I'm real sorry, I don't have an answer here. :(( I did get this link, maybe it can help you. Good luck, Thea
Hi thea , Thanks i will try to explain a little more I have an application(x) on my local machine say machine 1 which connects to a database server (y) say machine 2 which is running . i port ths application to a machine which has only the MSDE and .net framework installed ie inbuilt in win 2003 ok now i am not connecting to the MSDE db 1 but instead trying to connect to machine 2 database from this machine say machine 3. and in the process i get an error.