My question is what is the proper way to do this? I have been try the ways that it is instructing me to do.
By creating the name, then I go to a list of potential sources, one being: the local, then another being: the actual domain on the network, last one being: the name of the created data source. I have already tried the local & domain, I will try the last one.
But, my question is if this selection is not going to connect to SQL SERVER. Then, "What should I do within the server to make this connection possible to a client computer look for the access?"
Hi,I Did not understand your explanation. But anyway, if you want to let clients access SQL Server, you would have to do nothing more than
1.Enabling remote connection (In SQL Server 2005 this is disabled by default, for SQL 2000 its enabled) (see my website for a walkthrough)
2.If you are running on a dfferent port than the default one (1433) you would have to start SQL Browser on the Server (for SQL2k only)
On the client you can use on e of the connections strings here:
www.connectionstrings.com
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment