By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

system DSN connection

P: 23
i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email accounts for the mail server running on this; i want to connect from another windows 2003 server while creating system DSN on the machine; but sql doesn't allow me to connect.

both machines are workgroup machines; i've installed sql with NT authentication and enabled thru surface area management remote connection (TCP) ; what could be the reason not allowing me to connect
help appreciated
Feb 23 '08 #1
Share this Question
Share on Google+
3 Replies


P: 23
i've installed SQL Express 2005 in windows 2003 server; purpose was to store the email accounts for the mail server running on this; i want to connect from another windows 2003 server while creating system DSN on the machine; but sql doesn't allow me to connect.

both machines are workgroup machines; i've installed sql with NT authentication and enabled thru surface area management remote connection (TCP) ; what could be the reason not allowing me to connect
help appreciated

Whats the connection string?
Do you have a firewall?

From the other Windows 2003 server, can you telnet to port 1433 of the SQL Express server?
Feb 23 '08 #2

P: 23
Whats the connection string?
Do you have a firewall?

From the other Windows 2003 server, can you telnet to port 1433 of the SQL Express server?
no firewall; i'ven't tried telnet to i'll;
Feb 23 '08 #3

P: 23
i tried to telnet on to 1433 but fails; when i connect from other machine i get an error which says like NT-AUTHORITY ANONYMOUS USER LOGIN and fails; can SQL express be used to connect to other machine; help
Feb 25 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.