We are developing an application using VB.NET and SQL Server. We want the application to reside on a Server in a network environment with about 50 users. Some of the users may be allowed to both read and write data while some would only read the data.
Our problem is that when clients want to save data to the SQL server on the network server, application does not see the path to the database; it instead sees only the local drive.
We would be grateful if someone could help us get over the problem.
Thank you very much and best regards
Jalamang
Loading
BenjaminPosted Jun 11, 2010, 9:41 AM
did you check if the sql server browser is activated? See sql server configuration manager - services.(sql server and sql server browser should be active)
If this is ok check the security-permissions for the users. Integrated security => uses active directory, check in your database that the users have permission on your database: login etc.
By the way connectionstring looks ok for me.
Hope this helps.
PJ MartinsPosted Jun 9, 2010, 3:01 PM
Jalamang JobartehPosted Jun 7, 2010, 4:54 PM
The above is the connection string. Does it make sense?
Thank you very much.
Appreciate your help
PJ MartinsPosted Jun 5, 2010, 7:07 PM