Remote database connection
-
Im using sql server 2005 and trying to connect to a remote database, but i get the error "SQL Server does not exist or access denied". There is not problem with the code and it has worked many times on other projects and will connect to the database when run locally. The database has also been setup to accept remote connections, but i still cannot get a connection. Any ideas? Thanks for any help.
-
Im using sql server 2005 and trying to connect to a remote database, but i get the error "SQL Server does not exist or access denied". There is not problem with the code and it has worked many times on other projects and will connect to the database when run locally. The database has also been setup to accept remote connections, but i still cannot get a connection. Any ideas? Thanks for any help.
-
Yes, just though i would build some suspence before i asked it.
-
ednrgc wrote:
Is there a question?
Does "Any ideas?" not count?
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Im using sql server 2005 and trying to connect to a remote database, but i get the error "SQL Server does not exist or access denied". There is not problem with the code and it has worked many times on other projects and will connect to the database when run locally. The database has also been setup to accept remote connections, but i still cannot get a connection. Any ideas? Thanks for any help.
Have you checked the firewall between the computers. It might be blocking the port.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Have you checked the firewall between the computers. It might be blocking the port.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
Windows firewall is turned off and there is no other firewall in-between the boxes.
-
Windows firewall is turned off and there is no other firewall in-between the boxes.
wheelerbarry wrote:
Windows firewall is turned off and there is no other firewall in-between the boxes.
Has the server been configured to use a different port? Can you get Enterprise Manager/ SQL Management studio / Query Analyzer to connect?
Michael CP Blog [^] Development Blog [^]
-
ednrgc wrote:
Is there a question?
Does "Any ideas?" not count?
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
When I posted my reply, there was absolutely nothing in the original post. Hence my asking if there was a question.
ednrgc wrote:
When I posted my reply, there was absolutely nothing in the original post. Hence my asking if there was a question.
Ah... That makes sense. It also seems to be intermittent whether the post is marked as "Modified" or not. (Perhaps because the poster can remove that text if they wish)
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Im using sql server 2005 and trying to connect to a remote database, but i get the error "SQL Server does not exist or access denied". There is not problem with the code and it has worked many times on other projects and will connect to the database when run locally. The database has also been setup to accept remote connections, but i still cannot get a connection. Any ideas? Thanks for any help.
Can you connect with VS. If so you could verify the connection strings via vs.
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe
-
Im using sql server 2005 and trying to connect to a remote database, but i get the error "SQL Server does not exist or access denied". There is not problem with the code and it has worked many times on other projects and will connect to the database when run locally. The database has also been setup to accept remote connections, but i still cannot get a connection. Any ideas? Thanks for any help.
Connecting to SQL Server 2005 (and Express) has one slight difference in how you point to the sql server. In previous versions you would say the server's ip or name when requested (i.e. localhost or (local)) but it 2005, you need to put the server and the sqlserver (i.e. localhost/sqlserver) In Sql Server 2005 Express, point to it using ".\sqlexpress" Although i didn't quite understand what you are trying to do, or how, i hope this helped.
Ericos Georgiades