MS SQL 2000 Server usage
-
Hi: please help i have a windows application connected to a local MSSQL server and i want to make the application to be used over lan, what sholud i change only the connection string so that it will work over lan and for more than one user. please help and thanks for your time and consederation
-
Hi: please help i have a windows application connected to a local MSSQL server and i want to make the application to be used over lan, what sholud i change only the connection string so that it will work over lan and for more than one user. please help and thanks for your time and consederation
Firstly, are you using Windows Security (trusted connection) or SQL Server security (you have a separate username and password for SQL Server)? Does everyone who's going to use your application access SQL Server the same way? Do all your users have access to SQL Server? These are the things that you need to determine before going forwards. If everyone in your workplace has a trusted connection to SQL Server and access to the DB, then you don't need to provide username and password information in your connection string. Otherwise, you'll have to get a username and password from each user (to include in the connection string) before they can get access to the SQL Server DB. I hope this helps.