December 21, 2005 at 3:42 am
hi
I have a sql server installed on one machine. and from other m/c, which is having windows xp, i m trying to connect to the sql server. thru enterprise manager i m able to connect, but thru my code in .net, i m not able to connect. its giving me "sql server doesnt exist or access denied" error. plz give me ur valuable suggestions for this.
thanks
hiral
December 21, 2005 at 6:53 am
is the .net application on the same PC as the one you can connect to or a different one, it sounds to me as if you have an MDAC issue (but i could be wrong).
I'd re-install the SQL client tools on the PC in question, apply the same SP as on the SQL server and then reboot before trying to connect again.
Mike
December 21, 2005 at 2:25 pm
December 21, 2005 at 8:49 pm
The connection string is like this:
Server=<server name>;uid=<id>;pwd=<pwd>;database=<dbname>
The sql server is on a different m/c then the application....
December 21, 2005 at 8:51 pm
The application and db server are different m/c. which MDAC version shud i use? and i havent applied any SP to the Server, so let me know if i have to apply any...
December 21, 2005 at 9:05 pm
If you are using sql server 2000 you should consider moving it to SP4. Check out the documentation first to make sure this is ok for you. Probably won't make any difference to what you are experiencing here, except that it may update your MDAC version. That may be helpful.
You still haven't indicated if the user you are trying to log on as in the application is the same as the user you log on as when using EM. Try testing the user and password from your connection string by logging in with them via Query Analyser. This will at least rule out the possibility of a username password mix up.
December 21, 2005 at 9:10 pm
I m trying to login using the same user name password as i do with EM. So that shudnt make any diffrence to the connectivity as such.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply