June 5, 2007 at 8:36 pm
Hi
How do i configure SQL server 2005 to accept connections from different clients (using windows forms)on the intranet? The pc are all connected on the network and i want the SQL server to hold all the data and allow connections from other pc. Any suggestions would be helpful.
Thanks
June 6, 2007 at 9:57 am
get a book on dot net, or use a client application - such as an access client ( although this wouldn't be a personal recommendation ) - I guess I'd go for asp.net
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 7, 2007 at 6:14 am
Not sure exactly what you are asking.
To configure sql go into surface area configuration manager > database engine > remote connections
Also you might have to go into SQL Server Configuration manager > network configuration > protocols and enable / setup the ones you want.
You will also want to make sure how your database properties for security are how you want.
From the client side you will want to save the connection string somewhere (encrypted in the registry), use a DSN, encrypted file etc.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply