Accessing a database on a server

[milos111]

My database is on a server. In order to acces the server I need a username and a password. When my local machine is already connected to a server, then there is no problem. But when there is no previously established connetction, I get an error message, that I dont have a permission to acces the file. How can I solve the problem? Can I enter somehow a username and a password by writing a code ?

Thanks in advance

 

[hadinatayp]

dim conn as new sqlconnection("data source=server_name; initial catalog= database_name; User ID=user_name; password=password;integrated security=true;")

can it help!?