How to acccess the SQL database over a network
-
Hello I have a network running tcp/ip on 4 networked pc’s with windows xp home. In my network places I can see the server(Windows xp pro) and all clients, I have created a user account in the Login sections in SQL management studio express , yet how do I access the databases from the client computers What setting do I need to edit to allow my users to connect to the Server and its databases? What permissions do I need to set I o the users? What shares should be done? Please can some one assist me. Please email me on Ozzyrocsdbn@yahoo.com Regrads Ozer
-
Hello I have a network running tcp/ip on 4 networked pc’s with windows xp home. In my network places I can see the server(Windows xp pro) and all clients, I have created a user account in the Login sections in SQL management studio express , yet how do I access the databases from the client computers What setting do I need to edit to allow my users to connect to the Server and its databases? What permissions do I need to set I o the users? What shares should be done? Please can some one assist me. Please email me on Ozzyrocsdbn@yahoo.com Regrads Ozer
ozzyrocsdbn wrote:
Please email me on Ozzyrocsdbn@yahoo.com
Emailing the answer is bad, it means the answer isn't here for everyone else to benefit from.
ozzyrocsdbn wrote:
What setting do I need to edit to allow my users to connect to the Server and its databases? What permissions do I need to set I o the users? What shares should be done? Please can some one assist me.
If your compleatly starting from scratch I'd recommend getting a good book on the subject. I don't personally know of any good beginner books sorry.
ozzyrocsdbn wrote:
What setting do I need to edit to allow my users to connect to the Server and its databases?
Here's how to configure Sql Server 2005 Express for remote access: http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]
ozzyrocsdbn wrote:
What permissions do I need to set I o the users?
Google:http://www.google.co.uk/search?hl=en&q=creating+a+user+in+sql+server+2005&meta=[^]
ozzyrocsdbn wrote:
What shares should be done?
You don't need any shares. Sql Server is network based not file based.
-
ozzyrocsdbn wrote:
Please email me on Ozzyrocsdbn@yahoo.com
Emailing the answer is bad, it means the answer isn't here for everyone else to benefit from.
ozzyrocsdbn wrote:
What setting do I need to edit to allow my users to connect to the Server and its databases? What permissions do I need to set I o the users? What shares should be done? Please can some one assist me.
If your compleatly starting from scratch I'd recommend getting a good book on the subject. I don't personally know of any good beginner books sorry.
ozzyrocsdbn wrote:
What setting do I need to edit to allow my users to connect to the Server and its databases?
Here's how to configure Sql Server 2005 Express for remote access: http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]
ozzyrocsdbn wrote:
What permissions do I need to set I o the users?
Google:http://www.google.co.uk/search?hl=en&q=creating+a+user+in+sql+server+2005&meta=[^]
ozzyrocsdbn wrote:
What shares should be done?
You don't need any shares. Sql Server is network based not file based.
THANK YOU THE WEB ADDRESS ROCK MY NETWORK UP btw. MY NETWORK IS AT HOME AND WE CODING A PROJECT FREE LANCE STYLE. REGRARDS OZER MICROSOFT ROCKS :-)
-
THANK YOU THE WEB ADDRESS ROCK MY NETWORK UP btw. MY NETWORK IS AT HOME AND WE CODING A PROJECT FREE LANCE STYLE. REGRARDS OZER MICROSOFT ROCKS :-)